DBookatay Posted September 19, 2009 Share Posted September 19, 2009 I found a script online to upload multiple rows at one time, but can not get the thing to work... Anyone spot any errors? <?php $host="xxxxxxxxxxxxxxxxxxxx"; // Host name $username="xxxxxx"; // Mysql username $password="xxxxx"; // Mysql password $db_name="xxxxxx"; // Database name // Connect to server and select databse. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $sql="SELECT * FROM Inventory ORDER BY year DESC"; $result=mysql_query($sql); // Count table rows $count=mysql_num_rows($result); ?> <table> <form name="form1" method="post" action="test.php"> <tr> <td> <table> <tr> <td>Stock</td> <td>VIN</td> <td>Asking</td> </tr> <? while($rows=mysql_fetch_array($result)){ ?> <tr> <td><? $id[]=$rows['stock']; ?><? echo $rows['stock']; ?></td> <td><input size="19" name="vin[]" type="text" id="vin" value="<? echo $rows['vin']; ?>"></td> <td><input size="3" name="price_asking[]" type="text" id="price_asking" value="<? echo $rows['price_asking']; ?>"></td> </tr> <? } ?> <tr><td colspan="9" align="right"><input type="submit" name="Submit" value="Submit"></td></tr> </table> </td> </tr> </form> </table> <?php // Check if button name "Submit" is active, do this if($Submit){ for($i=0;$i<$count;$i++){ $sql1="UPDATE Inventory SET vin='$vin[$i]', price_asking='$price_asking[$i]' WHERE stock='$id[$i]'"; $result1=mysql_query($sql1); } } if($result1){ header("location:test.php"); } mysql_close(); ?> Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted September 19, 2009 Share Posted September 19, 2009 can not get the thing to work... Yes, but what is it doing? A blank page? Just shows the form again? A php error? A mysql error? There could be a couple of dozen things that could prevent it from working on any server or with any database. Unless you tell us what you see in front of you when you try it, to narrow down the problem, it is a little hard to help. Also, what does adding the following two lines of code immediately after the first opening <?php tag show - ini_set("display_errors", "1"); error_reporting(E_ALL); Quote Link to comment Share on other sites More sharing options...
DBookatay Posted September 19, 2009 Author Share Posted September 19, 2009 I added your ini_set code and got the following errors: Notice: Undefined variable: Submit in /home/.phillipina/dbookatay/login.carcityofdanbury.com/passed/New/test.php on line 49 Notice: Undefined variable: result1 in /home/.phillipina/dbookatay/login.carcityofdanbury.com/passed/New/test.php on line 62 Quote Link to comment Share on other sites More sharing options...
DBookatay Posted September 19, 2009 Author Share Posted September 19, 2009 Here is the website: http://www.login.carcityofdanbury.com/passed/New/test.php Quote Link to comment Share on other sites More sharing options...
DBookatay Posted September 19, 2009 Author Share Posted September 19, 2009 Anyone? Quote Link to comment Share on other sites More sharing options...
trq Posted September 19, 2009 Share Posted September 19, 2009 The error says it all. $Submit isn't defined anywhere in your script. Change it to $_POST['Submit'] Quote Link to comment Share on other sites More sharing options...
DBookatay Posted September 19, 2009 Author Share Posted September 19, 2009 The error says it all. $Submit isn't defined anywhere in your script. Change it to $_POST['Submit'] I did this: <?php if($_POST['Submit']){ for($i=0;$i<$count;$i++){ $sql1="UPDATE Inventory SET vin='$vin[$i]', price_asking='$price_asking[$i]' WHERE stock='$stock[$i]'"; $result1=mysql_query($sql1); } if($result1){header("location:test.php");} } mysql_close(); ?> and it deleted every row in the dB. (Good thing I had it saved) Does anyone have a better working example than the one I found? Quote Link to comment Share on other sites More sharing options...
trq Posted September 19, 2009 Share Posted September 19, 2009 The example you are using relies on a very old feature/bug called register globals. You still have undefined variables. Where is $price_asking, $vin and $stock defined? You use them in your query but don't define them anywhere. The data your looking to use within your query will be found within the $_POST array. Instead of looking around for examples of simple code (and finding terrible examples at that) why not try learning PHP yourself? Scripts like this are really quite straight forward once you know the basics. Quote Link to comment Share on other sites More sharing options...
DBookatay Posted September 19, 2009 Author Share Posted September 19, 2009 The example you are using relies on a very old feature/bug called register globals. You still have undefined variables. Where is $price_asking, $vin and $stock defined? You use them in your query but don't define them anywhere. The data your looking to use within your query will be found within the $_POST array. Instead of looking around for examples of simple code (and finding terrible examples at that) why not try learning PHP yourself? Scripts like this are really quite straight forward once you know the basics. That is how I have been learning, buy looking at working examples... Do you know of a good working example? Quote Link to comment Share on other sites More sharing options...
trq Posted September 19, 2009 Share Posted September 19, 2009 The example you are using relies on a very old feature/bug called register globals. You still have undefined variables. Where is $price_asking, $vin and $stock defined? You use them in your query but don't define them anywhere. The data your looking to use within your query will be found within the $_POST array. Instead of looking around for examples of simple code (and finding terrible examples at that) why not try learning PHP yourself? Scripts like this are really quite straight forward once you know the basics. That is how I have been learning, buy looking at working examples... Do you know of a good working example? The problem is without knowing the language you don't know whats a good example or a bad example. Learning the language itself you won't need to look for examples to be able to use a script, you'll just write one. Theres a good free book in my signature (Hudzilla), you could start there. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.