Location: PHPKode > projects > ADbNewsSender > ADbNewsSender 2.1.0/protected/skeleton/includes/db_defs/mysql/insert_into.php.inc
<?php
/* 
    Last change in version: 2.0 Alpha 1
#########################################################################################
#    ADbNewsSender 2 									#
#    Copyright (C) 2009  Florian Grannemann (E-mail: hide@address.com)  		#
#    Website: http://adbnewssender.sf.net						#
#											#
#    This program is free software: you can redistribute it and/or modify		#
#    it under the terms of the GNU General Public License as published by		#
#    the Free Software Foundation, either version 3 of the License, or			#
#    any later version.									#
#											#
#    This program is distributed in the hope that it will be useful,			#
#    but WITHOUT ANY WARRANTY; without even the implied warranty of			#
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the			#
#    GNU General Public License for more details.					#
#											#
#    You should have received a copy of the GNU General Public License			#
#    along with this program.  If not, see http://www.gnu.org/licenses/.		#
#########################################################################################
	
*/
/*
	This file implements the insert_into function.
	
*/

//$querystring contains the table name
//$params contains the columns as an associative array
//$params["columnname"]=value

$columnstring="(";
$valuestring="(";
$i=1;
foreach($params as $columnname => $value)
{
	$columnstring=$columnstring."`".strtolower($columnname)."`";
	if(is_numeric($value))
	{
		$valuestring=$valuestring.$value;
	}
	else
	{
		$valuestring=$valuestring."'".$value."'";
	}
	if($i <count($params))
	{
		$columnstring=$columnstring.",";
		$valuestring=$valuestring.",";
	}
	$i++;
}

$columnstring=$columnstring.")";
$valuestring=$valuestring.")";
$query="INSERT INTO `$querystring` $columnstring VALUES $valuestring;";


		
if(@mysql_select_db($this->DB_name,$this->session))
{
	if(@mysql_query($query,$this->session))
	{

		$result=true;
	}
}

?> 
 
Return current item: ADbNewsSender