Comments on: PHP CRUD Operations with MySQLi Extension

By: Newbie

Newbie — Sat, 03 Jun 2023 06:25:08 +0000

I tired. Update and insert not working for me :(.
I change this script.
public function change($table, $coloumn, $conditions){
$queryClass = “UPDATE “.$table.” SET “.$coloumn.” WHERE $conditions”;
$changeClass = $this->db->query($queryClass);
return $changeClass?$this->db->affected_rows:false;
}

#===
$changed = “product_status=’$getChange'”;
$whereId = “id = $postId “;
$update = $db->change(‘products’, $changed, $whereId);
if($update > 0){
echo alert(‘Change status is Successfully‘, ‘success’);
}else{
echo alert(‘Somethink went wrong to change status.’, ‘danger’);
}

By: Tom King

Tom King — Tue, 21 Mar 2023 20:30:24 +0000

Its great code that I’ve been using for a couple of years. Licensed user. My question is PHP 8.2 is giving a warning about line 22 in the DBclass.php file.
“Deprecated: Creation of dynamic property DB::$db is deprecated”

Whenever PHP 9 comes out it will throw a fatal error. The fix for now is to add this line above the DBclass
#[AllowDynamicProperties]
class DB{

By: Addisu

Addisu — Wed, 04 Nov 2020 08:17:05 +0000

Nice tutor, Thanks

By: kowai

kowai — Mon, 23 Dec 2019 04:58:30 +0000

how can select multi tables

By: Vinod Verma

Vinod Verma — Mon, 24 Jun 2019 00:07:37 +0000

How can show mysqli data show randomly

By: Alvaro Fuenzalida

Alvaro Fuenzalida — Fri, 19 Apr 2019 15:48:47 +0000

has anyone worked around this:
when we do the update or insert, how do we treat numbers or null values? does don’t go without quotes, same as values that can’t be empty, but rather null. thanks!

By: CodexWorld

CodexWorld — Sun, 28 Jan 2018 20:47:11 +0000

In reply to alonso sirenio. For search functionality, see this tutorial - https://www.codexworld.com/server-side-filtering-jquery-ajax-php-mysql/

By: alonso sirenio

alonso sirenio — Fri, 26 Jan 2018 20:46:33 +0000

how can i do if i want to search a user for name and show in the table