Reusable PHP CRUD DATABASE FUNCTIONS

Today, We want to share with you Reusable PHP CRUD DATABASE FUNCTIONS.In this post we will show you TIME SAVING DATABASE FUNCTIONS, hear for insert update delete in php using classes we will give you demo and example for implement.In this post, we will learn about crud operations in php using oops with an example.

Reusable PHP CRUD DATABASE FUNCTIONS

There are the Following The simple About Reusable PHP CRUD DATABASE FUNCTIONS Full Information With Example and source code.

As I will cover this Post with live Working example to develop php oop crud pdo, so the sample php application with mysql for this example is following below.

PHP Reuse a MySQL object in function Examples

RowUpdateData('my_any_table', $request_data, "WHERE id = '$id'");
RowDeleteData('my_db_table', "WHERE id = '$id'");

$request_data = array(
    'member_name' => $member_name,
    'sir_name' => $sir_name,
    'profile' => $profile,
    'address1' => $address1,
    'country' => $country,
    'city' => $city,
    'areacode' => $areacode,
    'phone' => $phone,
    'mobile' => $mobile,
    'fb_url' => $fb_url,
    'pay' => $pay,
    'title' => $title,
    'information' => $information,
    'reference' => $reference,
    'time' => time()
);

function addRowInsertData($db_tbl_name, $request_data)
{
    // retrieve the keys of the array (column titles)
    $fields = array_keys($request_data);

    // build the query
    $sql = "INSERT INTO ".$db_tbl_name."
    (`".implode('`,`', $fields)."`)
    VALUES('".implode("','", $request_data)."')";

    // run and return the query result resource
    return mysql_query($sql);
}

we would create a PHP delete function:

Read Also:  crud with php oop and mvc design pattern

// the mysql query where clause is left optional incase the user wants to delete every row!
function RowDeleteData($db_tbl_name, $where_set='')
{
    // check for optional where clause
    $whereQry = '';
    if(!empty($where_set))
    {
        // check to display if the 'where' keyword exists
        if(substr(strtoupper(trim($where_set)), 0, 5) != 'WHERE')
        {
            // not found, add keyword
            $whereQry = " WHERE ".$where_set;
        } else
        {
            $whereQry = " ".trim($where_set);
        }
    }
    // build the SQL query
    $sql = "DELETE FROM ".$db_tbl_name.$whereQry;

    // run and return the query result resource
    return mysql_query($sql);
}

And then for PHP an update function:

Read Also:  PHP change Laravel Date Formats Example

// again where clause is left optional
function RowUpdateData($db_tbl_name, $request_data, $where_set='')
{
    // check for optional where clause
    $whereQry = '';
    if(!empty($where_set))
    {
        // check to see if the 'where' keyword exists
        if(substr(strtoupper(trim($where_set)), 0, 5) != 'WHERE')
        {
            // not found, add key word
            $whereQry = " WHERE ".$where_set;
        } else
        {
            $whereQry = " ".trim($where_set);
        }
    }
    // start the actual SQL statement
    $sql = "UPDATE ".$db_tbl_name." SET ";

    // loop and build the column /
    $sets = array();
    foreach($request_data as $column => $value)
    {
         $sets[] = "`".$column."` = '".$value."'";
    }
    $sql .= implode(', ', $sets);

    // append the where statement
    $sql .= $whereQry;

    // run and return the query result
    return mysql_query($sql);
}

Angular 6 CRUD Operations Application Tutorials

Read :

Read Also:  Convert Array to XML and XML to Array using PHP

Summary

You can also read about AngularJS, ASP.NET, VueJs, PHP.

I hope you get an idea about Reusable PHP CRUD DATABASE FUNCTIONS.
I would like to have feedback on my Pakainfo.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.