note 72174 added to function.vsprintf
| From: | 2ge at 2ge dot us | Date: | Fri, 05 Jan 2007 16:40:54 +0000 |
| Subject: | note 72174 added to function.vsprintf | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-121325@lists.php.net to get a copy of this message | ||
This is small script, which I use to import some other export:
<?php
$sql_insert = " INSERT INTO subs_partners
SET Partner = '%s',
PartnerID = '%s',
Name = '%s',
Object = '%s'
ON DUPLICATE KEY UPDATE ID = ID";
$handle = fopen($url, "r") or die("Can't open URL: $url");
while (!feof($handle)) {
$ar = explode("\t", str_replace("\n", "", fgets($handle)));
if(empty($ar[1])) continue;
$data = array(
'Partner' => 'partnername',
'PartnerID' => $ar[0],
'Name' => $ar[1],
'Object' => serialize (
array(
'category' => $ar[2],
'size' => $ar[3],
'uploaders' => $ar[4],
'downloaders' => $ar[5]
)
)
);
foreach($data as $key => $value) { $data[$key] = $db->SqlCorrection($value); }
$db->DbQuery(vsprintf($sql_insert, $data));
}
fclose($handle);
?>
Hope it will help someone
----
Server IP: 62.65.181.66
Probable Submitter: 84.16.39.202
----
Manual Page -- http://www.php.net/manual/en/function.vsprintf.php
Edit -- https://master.php.net/note/edit/72174
Del: integrated -- https://master.php.net/note/delete/72174/integrated
Del: useless -- https://master.php.net/note/delete/72174/useless
Del: bad code -- https://master.php.net/note/delete/72174/bad+code
Del: spam -- https://master.php.net/note/delete/72174/spam
Del: non-english -- https://master.php.net/note/delete/72174/non-english
Del: in docs -- https://master.php.net/note/delete/72174/in+docs
Del: other reasons-- https://master.php.net/note/delete/72174
Reject -- https://master.php.net/note/reject/72174
Search -- https://master.php.net/manage/user-notes.php