Hello, I'm having a hard time wrapping my brain around PHP/SQL... This is probably super easy for someone with more experience.. but I've been going back and forth with this since saturday.
I have a database that I want to update by a PHP form.
So far I can get it to read from the datebase (I only have information in the table where filminfo_id = 1)
This is the code I'm using: (I know it's probably aweful)
<?php
if ($submit) {
// process form
$db = mysql_connect("localhost", "<username>", "<password>");
mysql_select_db("reelide_movabletype",$db);
$sql = "INSERT INTO mt_filminfo (filminfo_director,filminfo_producer,filminfo_name,filminfo_address,filminfo_la,filminfo_dayphone,filminfo_evephone,filminfo_fax,filminfo_email,filminfo_web,filminfo_running,filminfo_orgformat,filminfo_complete) VALUES ('filminfo_director','filminfo_producer','filminfo_name','filminfo_address','filminfo_la','filminfo_dayphone',',filminfo_evephone','filminfo_fax','filminfo_email','filminfo_web','filminfo_running','filminfo_orgformat','filminfo_complete')";
$result = mysql_query($sql);
echo "Thank you! Information entered.\n";
} else{
$db = mysql_connect("localhost", "<username>", "<password>");
mysql_select_db("reelide_movabletype",$db);
$result = mysql_query("SELECT * FROM mt_filminfo WHERE filminfo_id = $record",$db);
// show value of "$record" (it should be passed via URL?record=1
echo $record;
if ($myrow = mysql_fetch_array($result)) {
?>
<input type="Hidden" name="<?php echo"$record"?>">
<a href="http://reelidentities.org/films/test.html?record=<?php echo $record + 1; ?>">Next Record</a>
<form method="post" action="<?php echo $PHP_SELF?>">
<h1>Film Information</h2>
<div class="formname">Film Title</div><input type="Text" name=""><br>
<div class="formfield"></div>
<div class="formname">Director</div>
<div class="formfield"><input type="Text" name="filminfo_director" value="<?php echo $myrow["filminfo_director"]; ?>" ></div>
<div class="formname">Producer</div><div class="formfield"><input type="Text" name="filminfo_producer" value="<?php echo $myrow["filminfo_producer"]; ?>"></div>
<h1>Entrant Information</h1>
<div class="formname">Current Status:</div>
<div class="formfield"></div>
<div class="formname">Name:</div>
<div class="formfield"><input type="Text" name="filminfo_name" value="<?php echo $myrow["filminfo_name"]; ?>"></div>
<div class="formname">Mailing Address:</div>
<div class="formfield"><input type="Text" name="filminfo_address" value="<?php echo $myrow["filminfo_address"]; ?>"></div>
<div class="formname">Louisiana Filmmaker?</div>
<div class="formfield"><input type="Text" name="filminfo_la" value="<?php echo $myrow["filminfo_la"]; ?>"></div>
<div class="formname">Daytime Phone?</div>
<div class="formfield"><input type="Text" name="filminfo_dayphone" value="<?php echo $myrow["filminfo_dayphone"]; ?>"></div>
<div class="formname">Evening Phone?</div>
<div class="formfield"><input type="Text" name="filminfo_evephone" value="<?php echo $myrow["filminfo_evephone"]; ?>"></div>
<div class="formname">Fax:</div>
<div class="formfield"><input type="Text" name="filminfo_fax" value="<?php echo $myrow["filminfo_fax"]; ?>"></div>
<div class="formname">E-Mail:</div>
<div class="formfield"><input type="Text" name="filminfo_email" value="<?php echo $myrow["filminfo_email"]; ?>"></div>
<div class="formname">Web Address</div>
<div class="formfield"><input type="Text" name="filminfo_web" value="<?php echo $myrow["filminfo_web"]; ?>"></div>
<div class="formname">Exact Running Time of Film:</div>
<div class="formfield"><input type="Text" name="filminfo_running" value="<?php echo $myrow["filminfo_running"]; ?>"></div>
<div class="formname">Original Format:</div>
<div class="formfield"><input type="Text" name="filminfo_orgformat" value="<?php echo $myrow["filminfo_orgformat"]; ?>"></div>
<div class="formname">Film Category</div>
<div class="formfield"></div>
<div class="formname">Date Completed:</div>
<div class="formfield"><input type="Text" name="filminfo_completed" value="<?php echo $myrow["filminfo_completed"]; ?>"></div>
<div class="formname">Synopsis:</div>
<div class="formfield"></div>
<input type="Submit" name="submit" value="Enter information">
</form>
<?php
}
} // end if
?>
Now that I can read data from (and advance to the next record...2 I'd like to be able to fill out the form, and save it to the database. There's the rub. I'd like to keep this all in the same file if possible.
Any suggestions for a total newbie?
Vincent
