1. Home
2. PHP/MySQL - any shorthand equivalent for PDO UPDATE?

173 votes

0 answers

PHP/MySQL - any shorthand equivalent for PDO UPDATE?

Get the solution ↓↓↓

Solution:

You can omit thebindParam calls by putting an array of parameters in the call toexecute:

$sth = $conn->prepare("UPDATE user SET session = :session WHERE email = :email");
$sth->execute(array(':session' => $session, ':email' => $email));
Copy code

I don't like it much, but if you don't want to have to write "session" and "email" so many times, you could use positional parameters instead of named ones:

$sth = $conn->prepare("UPDATE user SET session = ? WHERE email = ?");
$sth->execute(array($session, $email));
Copy code

Undefined asked

2023-09-28

Write your answer

---

Share solution ↓

Additional Information:

Date the issue was resolved:

2023-09-28

Link To Source
Link To Answer People are also looking for solutions of the problem: trying to access array offset on value of type bool

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

---

Similar questions

Find the answer in similar questions on our website.

310 PHP/MySQL - any shorthand equivalent for PDO UPDATE?

634 Print informative, well formatted mysql errors in PHP

950 php - Use mysql_fetch_array() with foreach() instead of while()

730 php - Cakephp 2.8.4 ignoring hasMany

559 php - File format or extension invalid PHPExcel

272 php - Why should you validate forms using javascript?

808 php - Nested mysql_query() - Resets first result's pointer?

298 PHP + SQL - Using SQL Server 'Create To' scripts to create tables through PHP

474 php - I honestly have no clue how to formulate this pass-by-reference conundrum

812 Including a html form in a php script

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/

MySQL

DBMS is a database management system. It is designed to change, search, add and delete information in the database. There are many DBMSs designed for similar purposes with different features. One of the most popular is MySQL. It is a software tool designed to work with relational SQL databases. It is easy to learn even for site owners who are not professional programmers or administrators. MySQL DBMS also allows you to export and import data, which is convenient when moving large amounts of information.
https://www.mysql.com/