The mysql_inse">
Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 mySQL: Opposite of mysql_fetch_assoc Jump to:  
Category: >> mySQL >> Opposite of mysql_fetch_assoc Bookmark and Share

<< lastnext >>

Snippet Name: Opposite of mysql_fetch_assoc

Description: The mysql_fetch_assoc "converts" a row from a table into an associative array.
The mysql_insert_array "converts" an associative array into a row in a table.

Comment: (none)

Language: PHP, MYSQL
Highlight Mode: MYSQL
Last Modified: March 02nd, 2009

<?php
     FUNCTION mysql_insert_array ($my_table, $my_array) {
 
 
          // VERSION 1.1 
          // 31.aug..2006 12:41
          // Copyright: you may DO whatever you wish (AND can ;-) ) WITH this code
 
          // Find ALL the KEYS FROM the array $my_array
          $keys = array_keys($my_array);
 
          // Find the number of the KEYS
          $keys_number = COUNT($keys);
 
          // Generate the COLUMN name for the $sql query
          $column_names = "(";
          $values = "(";
 
          for ($i = 0; $i < $keys_number; $i++) {
               $column_name = $keys[$i];
 
               // We don't add "," after the last one
               if ($i == ($keys_number - 1)) {
                    $column_names .= "`$keys[$i]`";
                    $values .= "'$my_array[$column_name]'";
               } else {
                    $column_names .= "`$keys[$i]`" . ", ";
                    $values .= "'$my_array[$column_name]'" . ", ";
               }
          }
 
          // Proper end the column name and the value 
          $column_names .= ")";
          $values .= ")";
 
          // We compose the query
          $sql = "insert into `$my_table` ";
          $sql .= $column_names;
          $sql .= ' VALUES ';
          $sql .= $values;
 
          $result = mysql_query($sql);
 
          if ($result) 
          {
               echo "The row was added sucessfully";
               return true;
          }
          else
          {
               echo ("The row was not added<br>The error was" . mysql_error());
               return false;
          }
     }
?>
 
Example:
<?php
 
     // Include the function's code
     require_once ("mysql_insert_array.php");
 
     // Establish the CONNECTION WITH the DATABASE
     require_once ("dbconnect.php");
 
     // The DATABASE has one TABLE, called `test`, created AS following:
     // CREATE TABLE `test` 
     // (
     //      `one` VARCHAR(20) DEFAULT NULL,
       //      `two` VARCHAR(20) DEFAULT NULL
     // ) 
     // TYPE=MyISAM;
 
 
     // We CREATE the $row array
     $row = array (
          "one" => "first",
          "two" => "second"
     );
 
     // We want TO INSERT the $row INTO $table
     $table = "test";
 
     // We INSERT the array INTO the DATABASE
     mysql_insert_array ($table, $row);
?>
 
The dbconnect.php:
<?php
 
     // *************************************************
     //      SET USER Access
     // *************************************************
 
     $hostname = "localhost";
 
     $username = " "; // Change your username
     $password = " "; // Change your PASSWORD
     $database = " "; // Change your DATABASE's name
 
     // *************************************************
     //      Database Connection
     // *************************************************
 
     $connection = mysql_connect($hostname, $username, $password) or die(mysql_error());
 
     $database = mysql_select_db($database, $connection) or die(mysql_error());
?>


Free
Oracle Magazine
Subscriptions
and Oracle White Papers


SQL University.net courses meet the most demanding needs of the business world for advanced education in a cost-effective manner. SQL University.net courses are available immediately for IT professionals and can be taken without disruption of your workplace schedule or processes.

Compared to traditional travel-based training, SQL University.net saves time and valuable corporate resources, allowing companies to do more with less. That's our mission, and that's what we deliver.

Click here to find out more
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 103 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?