Issue with PHP header

@Elizabeth - JSFiddle is only for HTML/CSS/Javascript not PHP.

However there's an app for that, use a PHP Sandbox

Obed, can you post the code you have in admin.php ?

Hey Caroline here's the gist

https://gist.github.com/4349753.git

That link just gives me a blank screen o_O

@caroline , it seems i can't share the code , it a little bit long , don't want to paste it here

@Caroline

i gonna send you the file in the facebook group

Okie dokie

You can also use a http://pastebin.com

Pastebin or Jsfiddle will work too. Or go through the Facebook group ;P Glad to see the teamwork goin on! Woop woop!

http://codepad.viper-7.com/e3heVJ here the codepad version , thanks James Barnett hope it's working

@Randy Hoyt ok i got what you said , this is the way i have it setup <?php include('inc/db_connect.php'); include('inc/admin.php'); include('inc/header.php') ?> In the error output it said , the issue is in the Header ,but the header.php is all html , there's no PHP code.so this thing really confuse.

Actually, the HTML is the problem. The error happens in admin.php with the header() command. The error tells you that it is too late to use a header() command because there was already some HTML in header.php. Once there's any HTML to get sent to the browser, then headers can no longer be changed. Headers have to come before the content of the page. Once an echo statement in PHP happens or once there's any non-PHP code (HTML or plain text outside of PHP tags), then any header command will produce an error.

can i send you a link that you can see it live

Yes, please share a link. I'll take a look at it tomorrow. We won't be able to see the server-side code, but it may help.

@Randy Hoyt , This is the link , http://www.mizikbox.com/entry.php , this link is control by the Admin.php

the header prob seems resolve because i don't have the warning anymore about the header , i don't know what i tweak , seems working now , but how i can prevent when i press back for the form not submitting again , cause i end up having duplicates records in the database .

Other questions: in the same form i have an update button to update the records on the database, i use the MySQL update command in the PHP script , but seems when i try to update ,it simply create a new record instead of update the record mentions by the WHERE clause.

in ruby before update , you have to retrieve the records first and apply the update and save. i'masking myself if the same rule apply for PHP .

here's the update PHP script.

if(isset($_GET['updatevideo'])) { include'update.html.php'; exit(); } //updating record if (isset($_POST['VideoTITLE']) && isset($_POST['ByArtist']) && isset($_POST['GroupName']) && isset($_Post['URL'] )) { try { $sql = 'UPDATE videoclip SET VideoTITLE = :VideoTITLE, ByArtist = :ByArtist, GroupName = :GroupName, URL = :URL WHERE ID = ID;';

$s = $pdo -> prepare($sql); $s -> bindValue(':VideoTITLE',$_POST['VideoTITLE']); $s -> bindValue(':ByArtist',$_POST['ByArtist']); $s -> bindValue(':GroupName',$_POST['GroupName']); $s -> bindValue(':URL',$_POST['URL']); $s -> execute(); } catch(PDOException $e) { $error = 'error adding submitted data' . $e-> getMessage(); include 'error.html.php'; exit(); } header('Location: entry.php'); exit(); }

I talk about preventing the form re-submission over in the PHP tutorial videos about the contact form:

• Adding a Contact Form

The video called "Redirecting After A Form Submission" discusses this.

First of all, I think your SQL statement has an error in it. The WHERE clauses says this:

WHERE ID = ID

That will be true for every record, so it looks like you will be loading the data submitted through the form into every record. I don't think that's what you are intending to do, are you? Perhaps you are trying to update only one record? You'll need to have a variable with the ID for that one record somewhere.

Now to your question: When you say "in Ruby," I trust you mean Ruby on Rails, right? Ruby on Rails is a framework that makes development faster; with frameworks, you are not typically executing your SQL statements directly against the database. The PHP code you have included, however, is directly executing a SQL query directly. You wouldn't have to retrieve any records first. If you execute an UPDATE SQL statement, it won't create a new record.