i just update my server. it showing an error today Deprecated: mysql_query(): The mysql extension is deprecated and will be removed in the >future: use mysqli or PDO instead in C:\wamp\www\work\db\dbfields – Copy.php on line 33 my dbfields – Copy.php page is mysql_query(“insert into user(name,address) values(‘$name’,’$address’)”); i create 2 columns (name&address), need to insert the … Read more
I’d use the try/catch block when the normal path through the code should proceed without error unless there are truly some exceptional conditions — like the server being down, your credentials being expired or incorrect. I wouldn’t necessarily use it to handle non-exceptional errors — say like the current user not being in the correct … Read more
If the WAMP icon is Orange then one of the services has not started. In your case it looks like MySQL has not started as you are getting the message that indicates there is no server running and therefore listening for requests. Look at the mysql log and if that tells you nothing look at the Windows … Read more
You have a typo in public function __contruct(), it should be public function __construct() { (you are missing an s)
from is a keyword in SQL. You may not used it as a column name without quoting it. In MySQL, things like column names are quoted using backticks, i.e. `from`. Personally, I wouldn’t bother; I’d just rename the column. PS. as pointed out in the comments, to is another SQL keyword so it needs to … Read more
This error you are receiving: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined is because the number of elements in $values & $matches is not the same or $matches contains more than 1 element. If $matches contains more than 1 element, then the insert will fail, because there is only 1 column name referenced in … Read more
Just a rather simple question with regards to PDO compared to MySQLi. With MySQLi, to close the connection you could do: However with PDO it states you open the connection using: but to close the connection you set it to null. Is this correct and will this actually free the PDO connection? (I know it … Read more
The short answer is NO, PDO prepares will not defend you from all possible SQL-Injection attacks. For certain obscure edge-cases. I’m adapting this answer to talk about PDO… The long answer isn’t so easy. It’s based off an attack demonstrated here. The Attack So, let’s start off by showing the attack… In certain circumstances, that will return more than … Read more
$pdo is undefined. You’re not declaring it inside the function, and it isn’t being passed in as an argument. You need to either pass it in (good), or define it in the global namespace and make it available to your function by placing global $pdo at the top (bad).
Using bindParam() the variable is bound as a reference. A string can’t be passed by reference. The following things can be passed by reference: Variables, i.e. foo($a) New statements, i.e. foo(new foobar()) References returned from functions Try using bindValue()