Comments on: PHP OOP CRUD Operations using PDO Extension with MySQL

By: Parmod

Parmod — Sat, 06 May 2023 05:58:33 +0000

are you planning to upgrade with code for php 8+

By: Nilton Oliveira

Nilton Oliveira — Thu, 17 Nov 2022 13:24:17 +0000

What is the possibility of an example crud with select option of table states and cities related to the user table and also including the photo in the record.

By: Mahesh Kumar

Mahesh Kumar — Wed, 05 Jan 2022 20:52:42 +0000

how to use where condition on getRows() for multiple tables with JOINS or table1 as t1 , table2 as t2

By: CodexWorld

CodexWorld — Wed, 07 Apr 2021 17:48:42 +0000

In reply to Shahzad Choudhary. The insert() function will return the last insert ID if an insert is successful.

By: Shahzad Choudhary

Shahzad Choudhary — Sun, 04 Apr 2021 12:54:54 +0000

How we get here last insert id?
$insert = $db->insert($tblName,$userData);

By: Tom

Tom — Tue, 12 Jun 2018 09:01:17 +0000

awesome tutorial man.
it will be better if it comes with sql query error handling
thanks

By: Alen

Alen — Fri, 15 Dec 2017 20:49:07 +0000

Hi I want to ask you about form data. which is secure way to post form data???

By: Raj Dhanki

Raj Dhanki — Tue, 21 Nov 2017 01:56:29 +0000

Please upload php with mysqli with all fields like textbox checkbox select radio file upload and do insert update delete display in tabular format

By: Riad Hossain

Riad Hossain — Thu, 09 Mar 2017 07:21:37 +0000

Hello,
This is awesome… Now i want to add some columns. how to do this???

By: rene

rene — Tue, 07 Feb 2017 14:30:03 +0000

Very Nice.

I added a “IN” clause. Add this right after the if(array_key_exists(“in”,$conditions)){ section:

if(array_key_exists(“in”,$conditions)){
$i = 0;
foreach($conditions[‘in’] as $key => $value){
$pre = ($i > 0)?’ , ‘:’ AND ‘.$key.’ IN (‘;
$sql .=$pre;
$j=0;
foreach($value as $a => $b){
$pre1 = ($j > 0)?’ , ‘:”;
$sql.=$pre1.”‘”.$b.”‘”;
$j++;
}
$sql.=”)”;
$i++;
}
}