Comments on: Data Table Inline Editing using jQuery, Ajax, PHP and MySQL

By: Graeme

Graeme — Wed, 18 Oct 2023 12:38:52 +0000

Excellent, really useful and easy to follow. After saving, the script returns the new value to the data table. OK for plain text input, not so much for drop-down select lists. Can you suggest a simple workaround for different types of input box besides text?

By: Nee

Nee — Sat, 21 May 2022 09:32:45 +0000

How to record information and how to file information

By: Kurnia

Kurnia — Mon, 27 Sep 2021 13:28:07 +0000

Works like a charm!!.. Specially DB.class.
Totally simple and works!

By: Samir

Samir — Tue, 23 Mar 2021 10:23:07 +0000

How can we use OR option

By: Gareth

Gareth — Tue, 24 Sep 2019 20:04:40 +0000

Are there any instructions on how to do this with multiple tables please?

By: CodexWorld

CodexWorld — Mon, 12 Nov 2018 21:01:48 +0000

In reply to Tunde. You can specify multiple WHERE conditions in getRows() function. As per your requirement, the example code is given below:

// Get users from database
$con = array(
    'where' => array(
        'Subject' => '...',
        'Session' => '...'
    )
);
$users = $db->getRows('users', $con);

By: Tunde

Tunde — Mon, 12 Nov 2018 17:23:19 +0000

Hello, this script is working; i can display my table but i can add my WHERE Clause. Can the script be simplified? or can you this condition for me in the UPDATE? My WHERE clause is where Subject =”…” AND Session=”…”

Thank u

By: CodexWorld

CodexWorld — Fri, 24 Aug 2018 18:27:33 +0000

In reply to domenico. Yes, you can easily. See the example below.

$conditions = array(
    'where' => array(
        'id' => $id
    )
);
$users = $db->getRows('users', $conditions);

By: domenico

domenico — Thu, 23 Aug 2018 12:45:13 +0000

HI,
Thanks for this amazing script!

How can I add/use the where condition?

Thanks a lot

By: Aram

Aram — Fri, 11 May 2018 22:15:03 +0000

Hello there. thanks for this wonderful example.
I added a checkbox in this example. There are “yes” and “no” options. but there was no change in the database. How to add CheckBox Thank you