pdo
Organization of work with DataBase
I have some expierence in PHP, but have no one in application architecture Now I want to orginize my own \"bicycle\". It\'s something not useful, maybe mini-framework or mini-application, I want get s[详细]
2023-03-28 18:53 分类:问答How to bind a value if I want it to accept both INT and NULL with PDO?
$stmt = $dbh->prepare( \'SELECT id, name FROM folders WHERE parent_folder_id = :id\' ); $stmt->bindValue( \':id\', $folder_id, PDO::开发者_如何转开发PARAM_INT );[详细]
2023-03-28 17:42 分类:问答Which is faster for Large Data Sets? mysql, mysqli or PDO?
I am working with a rather large database of information now and so开发者_高级运维me queries return quite a hefty amount of information. From what I have read, foreach() is quicker than using while()[详细]
2023-03-28 13:16 分类:问答Placeholder For SQLite table In PHP
I have a query I would like to use that I would like to be reused for other select queries. Is it possible to have a select query like this:[详细]
2023-03-28 11:03 分类:问答Binding parameters for WHERE IN clause with PDO [duplicate]
This question already has answers here: 开发者_StackOverflow社区 PHP - Using PDO with IN clause array[详细]
2023-03-27 23:16 分类:问答Why are my JOINs failing?
I have a function to retrieve a single row of data representing a sales report for a store on a specific date.I\'m using similar methodology to retrieve data throughout the same class and application[详细]
2023-03-27 06:00 分类:问答How do you join two PDO objects in the same foreach loop?
Forgive me because I\'m new to PDO. I\'m not sure if there is a simple solution. I\'ve been searching online for some time and have yet to find an answer.[详细]
2023-03-27 00:13 分类:问答Is there a way to simiulate SQL server error responses/states without writing something that brings down the DB?
The other day on ou开发者_运维问答r production DB we had a few bad queries come to light that caused some blocking in our productions systems. While these queries have been fixed, there was another pr[详细]
2023-03-26 21:53 分类:问答PDO::execute() is an undefined method for me?
Here is the PDO code in question: $db->prepare(\"INSERT INTO user (id, name, password, salt, email, join_date, chats)[详细]
2023-03-26 21:28 分类:问答What is PDO & why should I use it?
People keep on mentioning that I should be using PDO in my PH开发者_JS百科P when dealing with MySQL, I have never heard of this before.[详细]
2023-03-26 21:12 分类:问答