advanced code snippet search

Posted By

kidmizere on 03/27/11


Tagged

form mysql php variables


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

mikael12


CREATE INSERT FOR ALL FORM VARIABLES (POST /GET) INTO MYSQL USING PHP

 / Published in: PHP
 

This generates a simple insert statement for mysql based on all the variables in $GET or $POST using a simple page. It does not do the inserts although that is a simple addition - just builds and displays your insert statement.

Expand | Embed | Plain Text 
  1. <?php
  2. session_start();
  3.  
  4. 	$fields = '';
  5. 	$values = '';
  6. 	$sql = display_post_get();
  7.  
  8. echo "<br>strSQL:<br>" . $sql;
  9.  
  10.  
  11. function display_post_get() { 
  12.    if ($_POST) { 
  13.       while (list($result_nme, $result_val) = each($_POST)) { 
  14.  		$fields .= $result_nme . "," ;
  15. 		$values .= $result_val . "','" ;
  16.       } 
  17. 	$fields=substr($fields,0,strlen($fields)-5);
  18. 	$values=substr($values,0,strlen($values)-12);  
  19. 	echo "Field Count : " . count(explode(",", $fields)) . "<p />";
  20. 	echo "Fields: " . $fields;
  21. 	echo "<p />Value Count : " . count(explode(",", $values)) . "<p />";
  22. 	echo "Values: " . $values . "<p />";
  23. 	$strSQL = "Insert into YOURDB ($fields) VALUES ('$values)";
  24. 	return $strSQL;
  25. 	} 
  26.    if ($_GET) { 
  27.       while (list($result_nme, $result_val) = each($_GET)) { 
  28.  		$fields .= $result_nme . "," ;
  29. 		$values .= $result_val . "','" ;
  30.       } 
  31. 	$fields=substr($fields,0,strlen($fields)-5);
  32. 	$values=substr($values,0,strlen($values)-12);  
  33. 	echo "Field Count : " . count(explode(",", $fields)) . "<p />";
  34. 	echo "Fields: " . $fields;
  35. 	echo "<p />Value Count : " . count(explode(",", $values)) . "<p />";
  36. 	echo "Values: " . $values . "<p />";
  37. 	$strSQL = "Insert into YOURDB ($fields) VALUES ('$values)";
  38. 	return $strSQL;
  39.    } 
  40. } 
  41.  
  42. ?>

Report this snippet  

You need to login to post a comment.