Create Dynamic MySQL Record Inserter with PHP

As a PHP programmer, we always need to write INSERT statement repeatedly to insert records into database. This sometimes makes us annoyed to write same thing again and again in same script. To overcome this, we have created a generic insert script to handle all insert record by just passing array of table field name and table field values.

Also, read:

• Convert Associative Array into XML in PHP
• Convert XML into Associative Array in PHP
• Converting an Array to JSON in PHP
• Converting JSON to Array or Object in PHP

Here is complete code of function insertRecord() that you may use in your PHP project.

<?php 
function insertRecord($table, $fields, $values, $return = false){ 
    $newFields = "(`" . implode("`, `", $fields) . "`)"; 
    $newValues = "('" . implode("', '", $values) . "')"; 
    $insertRecord = mysql_query("INSERT INTO `{$table}` {$newFields} VALUES {$newValues}"); 
    if($insertRecord){ 
        if($return){ 
            return mysql_insert_id(); 
        }else{ 
            return true; 
        } 
    }else{ 
        return false; 
    } 
} 

The above function insertRecord() that can be used in any PHP project. The function will take four parameters. The first parameter needs the table name you’re creating the new record in. The second parameter will be the variable that contains the array of field names of the table you have chosen. The third parameter will contain the values to add into the field names in its own record. The fourth parameter is option. Adding true to it will return the last ID that MySQL auto incremented to your PHP code, so you may use it in any way you like.

Here we will learn how to use generic insertRecord() function:

$tblFields = array("topic_id", "topic_userid", "topic_title", "topic_content", "topic_date"); 
$tblValues = array(NULL, $user_id, $topic_title, $topic_content, $topic_date); 
$insert    = insertRecord("topics", $tblFields, $tblValues, true); 
if($insert){ 
	echo "Record Inserted Successfully!";    
} 
?>

You may also like:

• Working with php.ini file Configuration
• Control Statements in PHP
• Convert Associative Array into XML in PHP
• Convert XML into Associative Array in PHP
• Using Prepared Statement with PHP & MySQL
• How to Upload File in PHP
• Converting an Array to JSON in PHP
• Converting JSON to Array or Object in PHP
• Manipulating PHP arrays: push, pop, shift, unshift
• Remove Repeated Words From String in PHP
• Converting a PHP Array to a Query String
• 15+ regular expressions for PHP developers
• 10 Most Important Directory Functions in PHP
• 10 little known but useful PHP functions
• PHP Script to Download Large Files Reliably