|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2003-02-04 09:28 UTC] jensalfkersten at web dot de
I' am sorry for my bad english, but I have a Problem with this Script.
function exec_sql_lines($sql_file, $old_string = '', $new_string = '') {
$sql_query = isset($sql_query) ? $sql_query : "";
if(!empty($sql_file) && $sql_file != "none") {
$sql_query = fread(fopen($sql_file, "r"), filesize($sql_file));
/* If magic_quotes_runtime is enabled, most functions that return data from any sort of external source
including databases and text files will have quotes escaped with a backslash.
*/
if (get_magic_quotes_runtime() == 1) $sql_query = stripslashes($sql_query);
/* replace old_string with new_string if they are set */
if($old_string != '') {
$sql_query = ereg_replace($old_string,$new_string,$sql_query);
}
}
$sql_query = trim($sql_query);
if($sql_query != "") {
$sql_query = remove_remarks($sql_query);
$pieces = split_sql_file($sql_query,";");
$cnt_pieces = count($pieces);
/* run multiple queries */
for ($i=0; $i<$cnt_pieces; $i++) {
$sql = trim($pieces[$i]);
if (!empty($sql) and $sql[0] != "#") $result = mysql_query($sql);
}
}
return true;
}
My Provider changed the PHP-Verion to 4.3.0 and from this
time this Script dosn't work.
Is there a Bug, nobody can help me.
Thanx Alf
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Wed Oct 29 10:00:01 2025 UTC |
So I want to creat two new Tables with this funktionscript __________________________________________________________ exec_sql_lines(SQL_LOGS, "pphl_xxxxx_logs", $tbl_prefix.$id.$tbl_logs); exec_sql_lines(SQL_MPDL, "pphl_xxxxx_mpdl", $tbl_prefix.$id.$tbl_mpdl); __________________________________________________________ The Funktion 'exec_sql_lines' is __________________________________________________________ function exec_sql_lines($sql_file, $old_string = '', $new_string = '') { $sql_query = isset($sql_query) ? $sql_query : ""; if(!empty($sql_file) && $sql_file != "none") { $sql_query = fread(fopen($sql_file, "r"), filesize($sql_file)); /* If magic_quotes_runtime is enabled, most functions that return data from any sort of external source including databases and text files will have quotes escaped with a backslash. */ if (get_magic_quotes_runtime() == 1) $sql_query = stripslashes($sql_query); /* replace old_string with new_string if they are set */ if($old_string != '') { $sql_query = ereg_replace($old_string,$new_string,$sql_query); } } $sql_query = trim($sql_query); if($sql_query != "") { $sql_query = remove_remarks($sql_query); $pieces = split_sql_file($sql_query,";"); $cnt_pieces = count($pieces); /* run multiple queries */ for ($i=0; $i<$cnt_pieces; $i++) { $sql = trim($pieces[$i]); if (!empty($sql) and $sql[0] != "#") $result = mysql_query($sql); } } return true; } __________________________________________________________ It works before my provider changed the php-version and i don't changed anything on the script but the tables dosn't creat and the script can't read it when it dosn't exist. I hope this information can help you to help me with my problem when not tell me what information do you need. Thanx alf from germany