What about this? :-
<?php
$array =
array("id"=>"123456","name"=>"Robert","email"=>"test@xxxxxxxx","status"=>"con
firm");
echo makeSQL("usertab",$array);
function makeSQL($table,$arr) {
$sql = "insert into '$table' ";
$sqlfields = "(";
$sqlvalues = "(";
$first = true;
reset($arr);
foreach ($arr as $key => $value) {
if ($first) {
$sqlfields .= "'$key'";
$sqlvalues .= "'$value'";
$first = false;
} else {
$sqlfields .= ",'$key'";
$sqlvalues .= ",'$value'";
}
}
$sqlfields .= ")";
$sqlvalues .= ")";
$sql .= "$sqlfields VALUES $sqlvalues";
return $sql;
}
?>
Rob.
-----Original Message-----
From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On
Behalf Of raul_berina_fq
Sent: 09 February 2007 10:54
To: php-objects@xxxxxxxxxxxxxxx
Subject: Transfer Data into MySql command
Hi,
I want to create a functions that automatic create an MySql commands:
Lets say I have data like this:
USER
Id : 348374
Name : Raul Berina
Email : raul_berina_fq@xxxxxxxxx
status : confirm
and PHP script should create a result like this
INSERT INTO `user` ( `id` , `Name` , `Email` , `status`) `departmentid` ,
`status` ) VALUES ( '348374', 'Raul Berina', 'raul_berina_fq@xxxxxxxxx',
'confirm');
The purpose of this script is to transfer data into another database (Let say
in other hosting company).
Inquiring mind here needs help.
Thanks in advance.
RAul BErina
***********************************************************************************
Any opinions expressed in email are those of the individual and not necessarily those of the company. This email and any files transmitted with it are confidential and solely for the use of the intended recipient
or entity to who they are addressed. It may contain material protected by attorney-client privilege. If you are not the intended recipient, or a person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited.
Random House Group + 44 (0) 20 7840 8400
http://www.randomhouse.co.uk
http://www.booksattransworld.co.uk
http://www.kidsatrandomhouse.co.uk
Generic email address - enquiries@xxxxxxxxxxxxxxxxx
Name & Registered Office:
THE RANDOM HOUSE GROUP LIMITED
20 VAUXHALL BRIDGE ROAD
LONDON
SW1V 2SA
Random House Group Ltd is registered in the United Kingdom with company No. 00954009, VAT number 102838980
***********************************************************************************
