PHP Simple Database Class

Add Database Connection Settings

At the top of your PHP page (AJAX or include file), add:

$db_conn = array(
    'host' => 'localhost',
    'user' => 'root',
    'pass' => '',
    'database' => 'test',
);

$db = new SimpleDBClass($db_conn);

Warning Settings

Inside the class file, you will notice:

// To show query error messages set on
// To hide them set off

public $ShowQryErrors = 'on';

During development and testing, keep this setting turned on so you can identify errors quickly.

Once your application is ready for production, switch it to off.

Functions You Need To Know

There are 5 main query functions:

• Select → Get rows
• Insert → Add rows
• Update → Update rows
• Delete → Delete rows
• Qry → General purpose query

There is also 1 important security function:

• CleanDBData()

It is highly recommended that you sanitize all user data before inserting it into your database.

Select Function

Retrieve rows from your database table.

$db->select("select * from users");

This returns all rows from the users table.

Select Rows Using Criteria

$user_id = $db->CleanDBData($_POST['user_id']);

$db->select("
    select * from users
    where user_id='$user_id'
");

Insert Function

$insert_arrays = array(
    'user_id' => $db->CleanDBData($UserID),
    'user_email' => $db->CleanDBData($UserEmail),
    'user_password' => $db->CleanDBData($UserPassword),
);

$db->Insert('users', $insert_arrays);

Always hash your passwords before storing them into your database.

Update Function

$array_fields = array(
    'userid' => $db->CleanDBData($UserID),
    'sitename' => $db->CleanDBData($UserSite),
);

$array_where = array(
    'rec_id' => $RecID,
);

$db->Update(
    $strTableName,
    $array_fields,
    $array_where
);

Delete Function

$array_where = array(
    'site_name' => $site_name,
    'user_email' => $user_email,
);

$Qry = $db->Delete(
    $tabl_name,
    $array_where
);

Final Thoughts

This PHP Simple Database Class was built to help developers create secure and powerful applications faster without dealing with unnecessary complexity.

If you want a lightweight way to handle MySQL CRUD operations using PHP, this class can save you a lot of development time.