netfrugal Posted November 30, 2006 Share Posted November 30, 2006 I found a tutorial online from this site: [URL=http://www.phpeasystep.com/mysql/10.html]http://www.phpeasystep.com/mysql/10.html[/URL] Now, I have attempted using the code provided, but I consistantly get an error concerning the header() function found on the bottom on the script.What am I not understanding about header information?I always get this error:[B]Warning: Cannot modify header information - headers already sent by (output started at C:\apache\Apache2\htdocs\PHP\update\update.php:9) in C:\apache\Apache2\htdocs\PHP\update\update.php on line 71[/B]Is the tutorial not correct? Because I've seen similar tutorials that put the header() function in similar places too. Here is the code: <strong>Update multiple rows in mysql</strong><br><?php$host="localhost"; // Host name$username="root"; // Mysql username$password="password"; // Mysql password$db_name="test"; // Database name$tbl_name="test_mysql"; // Table 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 $tbl_name";$result=mysql_query($sql);// Count table rows$count=mysql_num_rows($result);?><table width="500" border="0" cellspacing="1" cellpadding="0"><form name="form1" method="post" action=""><tr><td><table width="500" border="0" cellspacing="1" cellpadding="0"><tr><td align="center"><strong>Id</strong></td><td align="center"><strong>Name</strong></td><td align="center"><strong>Lastname</strong></td><td align="center"><strong>Email</strong></td></tr><?phpwhile($rows=mysql_fetch_array($result)){?><tr><td align="center"><? $id[]=$rows['id']; ?><? echo $rows['id']; ?></td><td align="center"><input name="name[]" type="text" id="name" value="<? echo $rows['name']; ?>"></td><td align="center"><input name="lastname[]" type="text" id="lastname" value="<? echo $rows['lastname']; ?>"></td><td align="center"><input name="email[]" type="text" id="email" value="<? echo $rows['email']; ?>"></td></tr><?php}?><tr><td colspan="4" align="center"><input type="submit" name="Submit" value="Submit"></td></tr></table></td></tr></form></table><?php// Check if button name "Submit" is active, do thisif($Submit){for($i=0;$i<$count;$i++){$sql1="UPDATE $tbl_name SET name='$name[$i]', lastname='$lastname[$i]', email='$email[$i]' WHERE id='$id[$i]'";$result1=mysql_query($sql1);}}[B][COLOR=DarkRed]if($result1){header("location:update.php");}[/COLOR][/B]mysql_close(); ?>This is a script to update multiple rows from one form.It is driving me crazy! Quote Link to comment https://forums.phpfreaks.com/topic/29022-header-function-question/ Share on other sites More sharing options...
chipk1 Posted November 30, 2006 Share Posted November 30, 2006 Make sure there are no spaces before or after your <?php ?>. If <?php is not the very first this on the page, server will send its own header info. hence the error your getting. Quote Link to comment https://forums.phpfreaks.com/topic/29022-header-function-question/#findComment-132991 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.