Page 1 of 1

Create SQL Insert script from a MySQL Database and a $_GET[]

Posted: Tue Jan 04, 2005 3:49 am
by Hagar

Code: Select all

<?php
# This code will generate you a sql script from a $_GET[] where you also have the
#option of a ID field in the Mysql DB
function insertion_script($tablename,$field_names,$has_id_field = "yes"){
		if($has_id_field == "yes"){
			$sql = "insert into {$tablename} (id,";
		}else{
			$sql = "insert into {$tablename} (";
		}

		for($i=1;$i <= count($field_names);$i++){
			if($i == count($field_names)){
			$sql .= "{$field_names[$i]})";
			}else{
			 $sql .= "{$field_names[$i]},";
			}
		#echo  "SQL Script: {$sql}<br>";
		}

		if($has_id_field == "yes"){

			$sql .="VALUES ('',";

		}else{
			$sql .="VALUES (";
		}

		for($i=1;$i <= count($field_names);$i++){
			if($i == count($field_names)){
				$sql .= "{$_GET[$field_names[$i]]}";
			}else{
				$sql .= "{$_GET[$field_names[$i]]},";
			}
		}
		$sql .= ")";

	#echo $sql;
	return $sql;
	}


?>
:D

Posted: Tue Jan 04, 2005 8:50 am
by feyd
Is there a problem you are having with this code, or just wanted to share it?

Posted: Tue Jan 04, 2005 8:54 am
by Hagar
No I thought that I'll share it :oops:

Posted: Tue Jan 04, 2005 9:01 am
by feyd
okay, just wanted to make sure. :D