[Resolved] need serious help and fast -- parsing sql file

juschillinnow

I got a bizarre problem. Has PHP made any recent new releases?

I have this program (e-commerce) and I exported the final .sql file using phpMyAdmin.

I use this simple code during the install to setup the database.

$filename = './install/icart.sql';
$fd = fopen($filename, "r");
$contents = fread($fd, filesize($filename));
$sql_array = explode(";\r\n", $contents);
$i = 0;
while($i < count($sql_array)) {
$sql = $sql_array[$i];
mysql_query($sql, $mysql_link);
echo $sql_array[$i]."<br><br><br><br>";
$i++;
}

It puts everything in there ok, but when I go to the storefront and click on a category, no products show up.

BUUUUT, if I take that same sql file that I am parsing with the script above and run it in the phpMyAdmin SQL, then I go to the storefront, and click on a category, everything shows up.

WHAT'S the dileo?

The part that is killing me is that everything was working about two weeks ago, noone has made any changes, and now it's doing this.

Any suggestions?

nemonoman

Debugging sucks. There are several paths to investigate however, based on the two facts of relevance:

Your php script USED to work
You get OK results using phpMyAdmin that differ from your php script

Here are some questions based on (1):

If you haven't changed your script, have you changed your FILENAME or PATH? Since the script looks for a PATH/FILENAME.sql it might fail, but when you manually browse for the file.

Have you changed the phpMyAdmin export parameters? (example, extended inserts, etc.? Structure only, not structure and data?)

I'd start there.

RE: fact 2 (ok w.phpMyAdmin):
What does your resulting db look like when you try to reinstall the db using your script?

If structure but no records, you might want to check your export parameters.

If old data, unchanged by script, you'd want to check your path/filename -- i.e. nothing happened.

Good luck with debugging! Debugging SUCKS!!!

tsinka

Hi,

could it be that the text file has been saved in unix format for some reason. It would then contain \n and not \r\n.

You could try to use file and trim, file already reads a file into an array, each row containing one line of the file. Trim then removes \r \n and some other chars from the beginning and the end of a string.

$sql_array = file($filename);

for ($i=0;$i<count($sql_array);$i++) {
$sql = trim($sql_array[$i]);
mysql_query($sql, $mysql_link);
echo $sql."<br><br><br><br>";
}

juschillinnow

What does your resulting db look like when you try to reinstall the db using your script?

That's just it. When I run my script, It sets up the database, everything else works except for pulling the products, like maybe something in the products (\n, \r\n, ' " etc) is being recorded wrong.

It might be possible that someone extended the inserts. I'll check that.

It's just crazy stupid when I put all the factors together. 1. it was working on six different test server, now it doesn't work on none, which puts out the idea of php beind upgraded. I don't think they'd all do it at once 2. It was working and everybody swears they haven't made any changes 3. the file can't be corrupted because it works via the phpMyAdmin, so this is why I'm stuck on the sql file being screwy and not compling with the parse script i posted earlier

It would then contain \n and not \r\n.

well I had \n at first, but then changed it to \r\n. The echo is in there so I could see what the script was doing.

It seems that it is taking \r\n instead of \n.

If I trim the sql then I won't have anything to parse the file with.

Anymore thoughts. These are all great, but lead me to dead ends still

juschillinnow

here's the sql file if anyone dares 🙂

juschillinnow

any more thoughts here?