Ok, I found this quite by chance, as it&#39;s not in the documentation at present...

There is a `getOriginal()` method available which returns an array of the original attribute values:

    User::updating(function($user)
    {
        if ($user-&gt;username != $user-&gt;getOriginal(&#39;username&#39;)) {
            doSomething();
        }

        // If you need multiple attributes you may use:
        // $originalAttributes = $user-&gt;getOriginal();
        // $originalUsername = $originalAttributes[&#39;username&#39;]; 
    });

&gt; Be careful, prior to Laravel 7 `getOriginal` ignores attribute type casting.

In Laravel 4.0 and 4.1, you can check with [isDirty() method](http://laravel.com/api/4.1/):

    User::updating(function($user)
    {
        if ($user-&gt;isDirty(&#39;username&#39;)){
            doSomething();
        }
    });

You could overload the methods, then call the parent method.

Given the string:

    &quot;Hello there world&quot;

how can I create a URL-encoded string like this:

    &quot;Hello%20there%20world&quot;

I would also like to know what to do if the string has other symbols too, like:

    &quot;hello there: world, how are you&quot;

What would is the easiest way to do so? I was going to parse and then build some code for that.

Parsing string to add to URL-encoded URL

I&#39;m running Ubuntu 12.10 and I&#39;m trying to install Netbeans 7.1(or later)
I have the .sh file, but it won&#39;t install, the error appears here:

    [2013-06-27 19:11:28.918]:     	at org.netbeans.installer.Installer.main(Installer.java:81)
    [2013-06-27 19:11:28.918]:     An error occured while initializing the NetBeans IDE installer UI.
    [2013-06-27 19:11:28.918]:     Most probably the running JVM is not compatible with the current platform.
    [2013-06-27 19:11:28.919]:     See FAQ at http://wiki.netbeans.org/FaqUnableToPrepareBundledJdk for more information.
    [2013-06-27 19:11:28.919]:     /usr/local/java/jre1.7.0_25/lib/i386/xawt/libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory
    [2013-06-27 19:11:28.919]:     
    [2013-06-27 19:11:28.919]:     Exception:
    [2013-06-27 19:11:28.919]:       java.lang.UnsatisfiedLinkError:
    [2013-06-27 19:11:28.919]:       /usr/local/java/jre1.7.0_25/lib/i386/xawt/libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory
    [2013-06-27 19:11:28.919]:     
    [2013-06-27 19:11:28.919]:     You can get more details about the issue in the installer log file:
    [2013-06-27 19:11:28.919]:      /root/.nbi/log/20130627191128.log

I don&#39;t have the libXtst.so.6 file in any directory, and I can&#39;t seem to find it anywhere to download. Has anyone else run into this problem, or know a work around?

Can&#39;t find/install libXtst.so.6?

Is there a way to see the old/previous value of a model&#39;s attribute in its `saving` or `updating` event?

eg. Is something like the following possible:

    User::updating(function($user)
    {
        if ($user-&gt;username != $user-&gt;old-&gt;username) doSomething();
    });

Get previous attribute value in Eloquent model event

Is there a way to see the old/previous value of a model's attribute in its <code>saving</code> or <code>updating</code> event?
eg. Is something like the following possible:
<pre><code class="hljs language-sql">User::updating(function($user)
{
 if ($user->username != $user->old->username) doSomething();
});
</code></pre>

I need to display and handle UTC dates in the following format:

&gt; 2013-06-28T22:15:00Z

As this format is part of the ISO8601 standard I have no trouble creating DateTime objects from strings like the one above. However I can&#39;t find a clean way (meaning no string manipulations like substr and replace, etc.) to present my DateTime object in the desired format. I tried to tweak the server and php datetime settings, with little success. I always get:

    $date-&gt;format(DateTime::ISO8601); // gives 2013-06-28T22:15:00+00:00

Is there any date format or configuration setting that will give me the desired string? Or I&#39;ll have to append the &#39;Z&#39; manually to a custom time format?

How to format an UTC date to use the Z (Zulu) zone designator in php?

I have file  /root/update/test.php. There&#39;s also a file, /root/connect.php; This file has a line 
  
    include &quot;../config.php&quot;;

In /root/update/test.php. There&#39;s the code

    set_include_path(&quot;.:/root&quot;);
    include &quot;connect.php&quot;;

When I run /root/update/test.php, it finds connect.php, but fails to find config.php, giving me 

    PHP Warning:  include(../config.php): failed to open stream: No such file or directory in /root/connect.php on line 2
    PHP Warning:  include(): Failed opening &#39;../config.php&#39; for inclusion (include_path=&#39;.:/root&#39;)



This is confusing to me because the warnings make it seem like I&#39;m doing everything correctly - the include path is /root, and it&#39;s looking for file ../config.php (/config.php), which exists. Can someone clear this up for me? Note that using absolute paths is not an option for me, due to deploying to a production server that I have no access to.

Ubuntu/Apache

PHP include relative path

I had this construction error when trying to creating a new DateTime object using a timestamp:

&gt;Exception: DateTime::__construct(): Failed to parse time string (1372622987) at position 8 (8): Unexpected character in DateTime-&gt;__construct()

The object creation code is:

    $start_date = new DateTime( &quot;@{$dbResult-&gt;db_timestamp}&quot; );

Where $dbResult-&gt;db_timestamp is a valid unix timestamp taken from a database. The timestamp in question was:

&gt;1372622987

I would understand this error for invalid formats being passed, but this is a genuine timestamp.

The reason this is very strange: I since ran a script to create a new DateTime object with the timestamp passed in as a hard coded value, and it reported no errors.

This seems to have been a one off, but I need an explanation if there is one, as I can&#39;t afford for this to happen again.

PHP DateTime __construct() Failed to parse time string (xxxxxxxx) at position x

My server runs CentOS 6.4 with MySQL 5.1.69 installed using yum with CentOS&#39;s repos, and PHP 5.4.16 installed using yum with ius&#39;s repos. **Edit3** Upgraded to MySQL Server version: 5.5.31 Distributed by The IUS Community Project, and error still exists.  Then changed library to mysqlnd, and seems to eliminate the error. Still, with this back and forth, need to know why this error only sometimes manifests.

When using PDO and creating the PDO object using `PDO::ATTR_EMULATE_PREPARES=&gt;false`, I sometimes get the following error:

    Table Name - zipcodes
    Error in query:
    SELECT id FROM cities WHERE name=? AND states_id=?
    SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.
    File Name: /var/www/initial_install/build_database.php
    Line: 547
    Time of Error: Tuesday July 2, 2013, 5:52:48 PDT

Line 547 is the last line of:

    $stmt_check_county-&gt;execute(array($data[5],$data[4]));
    if(!$county_id=$stmt_check_county-&gt;fetchColumn())
    {
        $stmt_counties-&gt;execute(array($data[5]));
        $county_id=db::db()-&gt;lastInsertId();
    }
    //$stmt_check_county-&gt;closeCursor(); //This will fix the error
    $stmt_check_city-&gt;execute(array($data[3],$data[4]));

I had a similar problem several years ago, but upgraded from PHP 5.1 to PHP 5.3 (and MySQL probably was updated as well), and the problem magically went away, and now I have it with PHP 5.5.

Why does it only manifest itself when `PDO::ATTR_EMULATE_PREPARES=&gt;false`, and with only alternating version of PHPs?

I&#39;ve also found that `closeCursor()` will also fix the error.  Should this always be done after every `SELECT` query where `fetchAll()` is not used?  Note that the error still occurs even if the query is something like `SELECT COUNT(col2)` which only returns one value.

**Edit**  By the way, this is how I create my connection.  I&#39;ve only recently added `MYSQL_ATTR_USE_BUFFERED_QUERY=&gt;true`, however, it doesn&#39;t cure the error.  **Also, the following script could be used as is to create the error.**

    function sql_error($e,$sql=NULL){return(&#39;&lt;h1&gt;Error in query:&lt;/h1&gt;&lt;p&gt;&#39;.$sql.&#39;&lt;/p&gt;&lt;p&gt;&#39;.$e-&gt;getMessage().&#39;&lt;/p&gt;&lt;p&gt;File Name: &#39;.$e-&gt;getFile().&#39; Line: &#39;.$e-&gt;getLine().&#39;&lt;/p&gt;&#39;);}

    class db {
        private static $instance = NULL;
        private function __construct() {}   //Make private
        private function __clone(){}   //Make private
        public static function db() //Get instance of DB
        {
            if (!self::$instance)
            {
                //try{self::$instance = new PDO(&quot;mysql:host=localhost;dbname=myDB;charset=utf8&quot;,&#39;myUsername&#39;,&#39;myPassword&#39;,array(PDO::ATTR_EMULATE_PREPARES=&gt;false,PDO::ATTR_ERRMODE=&gt;PDO::ERRMODE_EXCEPTION,PDO::ATTR_DEFAULT_FETCH_MODE=&gt;PDO::FETCH_ASSOC));}
                try{self::$instance = new PDO(&quot;mysql:host=localhost;dbname=myDB;charset=utf8&quot;,&#39;myUsername&#39;,&#39;myPassword&#39;,array(PDO::ATTR_EMULATE_PREPARES=&gt;false,PDO::MYSQL_ATTR_USE_BUFFERED_QUERY=&gt;true,PDO::ATTR_ERRMODE=&gt;PDO::ERRMODE_EXCEPTION,PDO::ATTR_DEFAULT_FETCH_MODE=&gt;PDO::FETCH_ASSOC));}
                //try{self::$instance = new PDO(&quot;mysql:host=localhost;dbname=myDB;charset=utf8&quot;,&#39;myUsername&#39;,&#39;myPassword&#39;,array(PDO::ATTR_ERRMODE=&gt;PDO::ERRMODE_EXCEPTION,PDO::ATTR_DEFAULT_FETCH_MODE=&gt;PDO::FETCH_ASSOC));}
                catch(PDOException $e){echo(sql_error($e));}
            }
            return self::$instance;
        }
    }

    $row=array(
        &#39;zipcodes_id&#39;=&gt;&#39;55555&#39;,
        &#39;cities_id&#39;=&gt;123
    );
    $data=array($row,$row,$row,$row);

    $sql = &#39;CREATE TEMPORARY TABLE temp1(temp_id INT UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (temp_id) )&#39;;
    db::db()-&gt;exec($sql);

    $sql=&#39;SELECT COUNT(*) AS valid FROM cities_has_zipcodes WHERE cities_id=? AND zipcodes_id=?&#39;;
    $stmt1 = db::db()-&gt;prepare($sql);

    $sql =&#39;SELECT temp_id FROM temp1&#39;;
    $stmt2 = db::db()-&gt;prepare($sql);

    foreach($data AS $row)
    {
        try
        {
            $stmt1-&gt;execute(array($row[&#39;zipcodes_id&#39;],$row[&#39;cities_id&#39;]));
            $rs1 = $stmt1-&gt;fetch(PDO::FETCH_ASSOC);
            //$stmt1-&gt;closeCursor();
            syslog(LOG_INFO,&#39;$rs1: &#39;.print_r($rs1,1).&#39; &#39;.rand());
            $stmt2-&gt;execute();
            $rs2 = $stmt2-&gt;fetch(PDO::FETCH_ASSOC);
            syslog(LOG_INFO,&#39;$rs2: &#39;.print_r($rs2,1).&#39; &#39;.rand());
        }
        catch(PDOException $e){echo(sql_error($e));}            
    }
    echo(&#39;done&#39;);

Causes of MySQL error 2014 Cannot execute queries while other unbuffered queries are active

I am getting this PHP error:

    PHP Notice:  Undefined offset: 1

Here is the PHP code that throws it:

    $file_handle = fopen($path.&quot;/Summary/data.txt&quot;,&quot;r&quot;); //open text file
    $data = array(); // create new array map

    while (!feof($file_handle) ) {
		$line_of_text = fgets($file_handle); // read in each line
		$parts = array_map(&#39;trim&#39;, explode(&#39;:&#39;, $line_of_text, 2)); 
		// separates line_of_text by &#39;:&#39; trim strings for extra space
		$data[$parts[0]] = $parts[1]; 
		// map the resulting parts into array 
		//$results(&#39;NAME_BEFORE_:&#39;) = VALUE_AFTER_:
	}

What does this error mean?  What causes this error?

PHP Notice: Undefined offset: 1 with array when reading data

I&#39;m stuck on a simple task. 
I just need to order results coming from this call 

    $results = Project::all();

Where `Project` is a model. I&#39;ve tried this

    $results = Project::all()-&gt;orderBy(&quot;name&quot;);
   
But it didn&#39;t work. Which is the better way to obtain all data from a table and get them ordered? 

Laravel Eloquent: Ordering results of all()

I have a many to many relationship set up and working, to add an item to the cart I use:

    $cart-&gt;items()-&gt;attach($item);

Which adds an item to the pivot table (as it should), but if the user clicks on the link again to add an item they have already added it creates a duplicate entry in the pivot table.

Is there a built in way to add a record to a pivot table only if one does not already exist?

If not, how can I check the pivot table to find if a matching record already exists?

Preventing Laravel adding multiple records to a pivot table

I got a model called Run which contains this method:

    public function getNameAttribute($name){
        if($name == &#39;Eendaags&#39;)
            return $this-&gt;race_edition-&gt;race-&gt;name;

        return $this-&gt;race_edition-&gt;race-&gt;name.&#39; &#39;.$name;
    }

I need this setup for laravel administrator, since alot of runs will have the same name and the only difference is the race name. But in 1 place in the website i need to get the name only, without mutating. Is this possbile?

Skip model accessor

I want to set headers as `array(&#39;Cache-Control&#39;=&gt;&#39;no-cache, no-store, max-age=0, must-revalidate&#39;,&#39;Pragma&#39;=&gt;&#39;no-cache&#39;,&#39;Expires&#39;=&gt;&#39;Fri, 01 Jan 1990 00:00:00 GMT&#39;);` for all my views, currently I&#39;m doing this in all controllers while returning views, like 


    $headers=array(&#39;Cache-Control&#39;=&gt;&#39;no-cache, no-store, max-age=0, must-revalidate&#39;,&#39;Pragma&#39;=&gt;&#39;no-cache&#39;,&#39;Expires&#39;=&gt;&#39;Fri, 01 Jan 1990 00:00:00 GMT&#39;);

    Redirect::to(&#39;/&#39;,301,$headers);`

So instead of writing this for each and every route can it be done in global scope, so that headers are set for every view.

I tried setting headers by creating after filter, but didn&#39;t get it to work.

Can anyone tell me where can I set the headers for all my views? 

**UPDATE**
One of my view file meta content

    &lt;!doctype html&gt;
    &lt;html lang=&quot;en&quot;&gt;
    &lt;head&gt;
    &lt;meta charset=&quot;UTF-8&quot;&gt;
    &lt;title&gt;

Now when i use `Redirect::to(&#39;/&#39;,301,$headers)`
The header in firebug is

    Cache-Control	max-age=0, must-revalidate, no-cache, no-store, private
    Connection	Keep-Alive
    Content-Type	text/html; charset=UTF-8
    Date	Tue, 09 Jul 2013 14:52:08 GMT
    Expires	Fri, 01 Jan 1990 00:00:00 GMT

And when I use `Redirect::to(&#39;/&#39;);`

The header in firebug is

    Cache-Control	no-cache
    Connection	Keep-Alive
    Content-Type	text/html; charset=UTF-8
    Date	Tue, 09 Jul 2013 14:52:08 GMT
   

Where can I set headers in laravel

Simple question - how do I order by &#39;id&#39; descending in Laravel 4.

The relevant part of my controller looks like this:

    $posts = $this-&gt;post-&gt;all()

As I understand you use this line:

    -&gt;orderBy(&#39;id&#39;, &#39;DESC&#39;);

But how does that fit in with my above code?

Laravel 4: how to &quot;order by&quot; using Eloquent ORM

I am using Laravel 4. I would like to access the current URL inside an `@if` condition in a view using the Laravel&#39;s Blade templating engine but I don&#39;t know how to do it.

I know that it can be done using something like `&lt;?php echo URL::current(); ?&gt;` but It&#39;s not possible inside an `@if` blade statement.

Any suggestions?

How to Get the Current URL Inside @if Statement (Blade) in Laravel 4?

Lets say we are using Laravel&#39;s query builder:

    $users = DB::table(&#39;really_long_table_name&#39;)
               -&gt;select(&#39;really_long_table_name.id&#39;)
               -&gt;get();

I&#39;m looking for an equivalent to this SQL:

    really_long_table_name AS short_name

This would be especially helpful when I have to type a lot of selects and wheres (or typically I include the alias in the column alias of the select as well, and it get&#39;s used in the result array). Without any table aliases there is a lot more typing for me and everything becomes a lot less readable. Can&#39;t find the answer in the laravel docs, any ideas?

How to alias a table in Laravel Eloquent queries (or using Query Builder)?

Given the following code:

&lt;!-- language: lang-php --&gt;

    DB::table(&#39;users&#39;)-&gt;get();

I want to get the raw SQL query string that the database query builder above will generate. In this example, it would be `SELECT * FROM users`.

How do I do this?

Content Type	Original Author	Original Content on Stackoverflow
Question	coatesap	View Question on Stackoverflow
Solution 1 - Php	coatesap	View Answer on Stackoverflow
Solution 2 - Php	Ola	View Answer on Stackoverflow
Solution 3 - Php	Rob W	View Answer on Stackoverflow

Get previous attribute value in Eloquent model event

Php Problem Overview

Php Solutions

Solution 1 - Php

Solution 2 - Php

Solution 3 - Php

Can't find/install libXtst.so.6?

Parsing string to add to URL-encoded URL

Attributions