That’s because that’s an SQL function, not PHP. You can use PDO::lastInsertId(). Like: $stmt = $db->prepare(“…”); $stmt->execute(); $id = $db->lastInsertId(); If you want to do it with SQL instead of the PDO API, you would do it like a normal select query: $stmt = $db->query(“SELECT LAST_INSERT_ID()”); $lastId = $stmt->fetchColumn();
You’ll have it in your connection string like: “mysql:host=$host;dbname=$db;charset=utf8mb4” HOWEVER, prior to PHP 5.3.6, the charset option was ignored. If you’re running an older version of PHP, you must do it like this: $dbh = new PDO(“mysql:host=$host;dbname=$db”, $user, $password); $dbh->exec(“set names utf8mb4”);
$sql = “SELECT count(*) FROM `table` WHERE foo = ?”; $result = $con->prepare($sql); $result->execute([$bar]); $number_of_rows = $result->fetchColumn(); Not the most elegant way to do it, plus it involves an extra query. PDO has PDOStatement::rowCount(), which apparently does not work in MySql. What a pain. From the PDO Doc: For most databases, PDOStatement::rowCount() does not return … Read more
Table and Column names CANNOT be replaced by parameters in PDO. In that case you will simply want to filter and sanitize the data manually. One way to do this is to pass in shorthand parameters to the function that will execute the query dynamically and then use a switch() statement to create a white … Read more
According to the official Laravel 7.x documentation, you can solve this quite easily. Update your /app/Providers/AppServiceProvider.php to contain: use Illuminate\Support\Facades\Schema; /** * Bootstrap any application services. * * @return void */ public function boot() { Schema::defaultStringLength(191); } Alternatively, you may enable the innodb_large_prefix option for your database. Refer to your database’s documentation for instructions on … Read more
Well, you could argue with the object oriented aspect, the prepared statements, the fact that it becomes a standard, etc. But I know that most of the time, convincing somebody works better with a killer feature. So there it is: A really nice thing with PDO is you can fetch the data, injecting it automatically … Read more
You need to have a module called pdo_mysql. Looking for following in phpinfo(), pdo_mysql PDO Driver for MySQL, client library version => 5.1.44
From the manual entry for PDOStatement::bindParam: [With bindParam] Unlike PDOStatement::bindValue(), the variable is bound as a reference and will only be evaluated at the time that PDOStatement::execute() is called. So, for example: $sex = ‘male’; $s = $dbh->prepare(‘SELECT name FROM students WHERE sex = :sex’); $s->bindParam(‘:sex’, $sex); // use bindParam to bind the variable $sex … Read more
Laravel 4: Change “host” in the app/config/database.php file from “localhost” to “127.0.0.1” Laravel 5+: Change “DB_HOST” in the .env file from “localhost” to “127.0.0.1” I had the exact same problem. None of the above solutions worked for me. I solved the problem by changing the “host” in the /app/config/database.php file from “localhost” to “127.0.0.1”. Not … Read more
You’ll have to construct the query-string. <?php $ids = array(1, 2, 3, 7, 8, 9); $inQuery = implode(‘,’, array_fill(0, count($ids), ‘?’)); $db = new PDO(…); $stmt = $db->prepare( ‘SELECT * FROM table WHERE id IN(‘ . $inQuery . ‘)’ ); // bindvalue is 1-indexed, so $k+1 foreach ($ids as $k => $id) $stmt->bindValue(($k+1), $id); $stmt->execute(); … Read more