Jump to content

fixafone123

New Members
  • Posts

    2
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

fixafone123's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Here is the form that gets filled out to add a new Speaker to our Seminar database: [code] <html> <head> <title>Genetics Seminar - Add Speaker</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <form action="speaker_insert.php" method="post" enctype="multipart/form-data" name="MForm">   <p align="center">Use this form to book a Seminar Speaker<br>     If you need to start a new semester, <a href="newsemester.php">Click Here </a></p>   <table width="95%" border="0" align="center" cellpadding="2" cellspacing="0">     <tr>       <td colspan="4"> </td>     </tr>     <tr>       <td width="25%">Speaker</td>       <td width="1%"> </td>       <td width="35%" valign="top"><input name="speaker" type="text" id="speaker" size="60"></td>       <td width="34%" rowspan="6" align="center" valign="middle"><input type="submit" name="Submit" value="Submit"></td>     </tr>     <tr>       <td>Speaker's Location </td>       <td> </td>       <td valign="top"><input name="location" type="text" id="location" size="60"></td>     </tr>     <tr>       <td>Topic</td>       <td> </td>       <td valign="top"><input name="topic" type="text" id="topic" size="60"></td>     </tr>     <tr>       <td>Host</td>       <td> </td>       <td valign="top"><input name="spkhost" type="text" id="spkhost" size="60"></td>     </tr>     <tr>       <td>Time<font size="2"> </font></td>       <td> </td>       <td valign="top"><select name="spktime" id="select">         <option value="12:00am">12:00am</option>         <option value="12:30am">12:30am</option>         <option value="1:00am">1:00am</option>         <option value="1:30am">1:30am</option>         <option value="2:00am">2:00am</option>         <option value="2:30am">2:30am</option>         <option value="3:00am">3:00am</option>         <option value="3:30am">3:30am</option>         <option value="4:00am">4:00am</option>         <option value="4:30am">4:30am</option>         <option value="5:00am">5:00am</option>         <option value="5:30am">5:30am</option>         <option value="6:00am">6:00am</option>         <option value="6:30am">6:30am</option>         <option value="7:00am">7:00am</option>         <option value="7:30am">7:30am</option>         <option value="8:00am">8:00am</option>         <option value="8:30am">8:30am</option>         <option value="9:00am">9:00am</option>         <option value="9:30am">9:30am</option>         <option value="10:00am">10:00am</option>         <option value="10:30am">10:30am</option>         <option value="11:00am">11:00am</option>         <option value="11:30am">11:30am</option>         <option value="12:00pm" selected>12:00pm</option>         <option value="12:30pm">12:30pm</option>         <option value="1:00pm">1:00pm</option>         <option value="1:30pm">1:30pm</option>         <option value="2:00pm">2:00pm</option>         <option value="2:30pm">2:30pm</option>         <option value="3:00pm">3:00pm</option>         <option value="3:30pm">3:30pm</option>         <option value="4:00pm">4:00pm</option>         <option value="4:30pm">4:30pm</option>         <option value="5:00pm">5:00pm</option>         <option value="5:30pm">5:30pm</option>         <option value="6:00pm">6:00pm</option>         <option value="6:30pm">6:30pm</option>         <option value="7:00pm">7:00pm</option>         <option value="7:30pm">7:30pm</option>         <option value="8:00pm">8:00pm</option>         <option value="8:30pm">8:30pm</option>         <option value="9:00pm">9:00pm</option>         <option value="9:30pm">9:30pm</option>         <option value="10:00pm">10:00pm</option>         <option value="10:30pm">10:30pm</option>         <option value="11:00pm">11:00pm</option>         <option value="11:30pm">11:30pm</option>       </select></td>     </tr>     <tr>       <td>Location of Seminar <font size="2"> </font></td>       <td> </td>       <td valign="top"><input name="where" type="text" id="where" value="Department of Genetics Library - McDonnell Science Building" size="60"></td>     </tr>     <tr>       <td>Speaker's Photo</td>       <td><br></td>           <td><input type=file name="userfile"></td>           <td> </td>           <td> </td>     </tr>     <tr>       <td colspan="4">           </td>     </tr>   </table>           <?PHP include "../conf/conf.php"; $data=mysql_query("select * from reserve") or die($SELECT_ERROR); ?> <TABLE ALIGN="CENTER" BORDER="1" BORDERCOLOR="#990000"> <TR>         <TD align="center"><B>ID<br>EDIT</B></TD>         <TD align="center"><B>Date</B></TD>         <TD align="center"><B>Speaker</B></TD>         <TD align="center"><B>Topic</B></TD>         <TD align="center"><B>Host</B></TD> </TR> <?PHP $i=1; while ($break_data=mysql_fetch_array($data)) {    if ($i % 2)   {     $color = $tbl_oncolor;   } }   else   {     $color = $tbl_offbgcolor;   }   $uid=$break_data['uid'];   $dbdate=$break_data['dbdate'];   $speaker=$break_data['speaker'];   $location=$break_data['location'];   $topic=$break_data['topic'];   $spkhost=$break_data['spkhost'];   print "<TR>";   print "<TD BGCOLOR=$color>$uid <input name=\"choose\" type=\"radio\" value=\"$uid\"> </TD>";   print "<TD BGCOLOR=$color>$dbdate</TD>";   print "<TD BGCOLOR=$color >$speaker - $location</TD>";   print "<TD BGCOLOR=$color>$topic</TD>";   print "<TD BGCOLOR=$color>$spkhost</TD>";   print "</TR>";   $i++; } ?> </TABLE> </form> </body> </html> [/code] Here is the script the form gets sent to: [code] <?php include "../conf/conf.php"; import_request_variables("gP", "rvar_"); mysql_query("UPDATE reserve SET speaker='$rvar_speaker', location='$rvar_location', topic='$rvar_topic', spkhost='$rvar_spkhost', spktime='$rvar_spktime', whereheld='$rvar_where' WHERE uid='$rvar_choose'"); $data=mysql_query("select * from reserve where uid='$rvar_choose'") or die($SELECT_ERROR); ?> <style type="text/css"> <!-- .style1 {         font-family: Arial, Helvetica, sans-serif;         font-weight: bold; } --> </style> <P><center class="style1">Here is the entry you Added/Changed <BR>Please click <a href="newspeaker.php">Here</a> to return to the Add/Change page</center> </P> <TABLE ALIGN="CENTER" BORDER="1" BORDERCOLOR="#990000"> <TR>         <TD align="center"><B>ID</B></TD>         <TD align="center"><B>Date</B></TD>         <TD align="center"><B>Speaker</B></TD>         <TD align="center"><B>Topic</B></TD>         <TD align="center"><B>Host</B></TD> </TR> <?PHP $i=1; while ($break_data=mysql_fetch_array($data)) {    if ($i % 2)   {     $color = $tbl_oncolor;   }   else   {     $color = $tbl_offbgcolor;   }   $uid=$break_data['uid'];   $dbdate=$break_data['dbdate'];   $speaker=$break_data['speaker'];   $location=$break_data['location'];   $topic=$break_data['topic'];   $spkhost=$break_data['spkhost'];   print "<TR>";   print "<TD BGCOLOR=$color>$uid</TD>";   print "<TD BGCOLOR=$color>$dbdate</TD>";   print "<TD BGCOLOR=$color >$speaker - $location</TD>";   print "<TD BGCOLOR=$color>$topic</TD>";   print "<TD BGCOLOR=$color>$spkhost</TD>";   print "</TR>";   $i++; } if(!empty($_FILES["userfile"])) {     $uploaddir = "/home/www/fisher/docs/seminarphp/admin/photos/"; // set this to wherever     //copy the file to some permanent location     if (move_uploaded_file($_FILES["userfile"]["tmp_name"], $uploaddir . $_FILES["userfile"]["name"])) {             echo("file uploaded"); } else {         echo ("error!");     } } $picturename = $_FILES["userfile"]["name"]; mysql_query("UPDATE reserve SET picture='http://www.genetics.wustl.edu/seminarphp/admin/photos/$picturename' WHERE uid='$rvar_choose'"); ?> </TABLE> [/code]
  2. First off, I am very much a novice when it comes to PHP so talk to me like I am an idiot [img src=\"style_emoticons/[#EMO_DIR#]/smile.gif\" style=\"vertical-align:middle\" emoid=\":smile:\" border=\"0\" alt=\"smile.gif\" /] I have a script that uploads a file to my webserver and places a link to it in the database (MySQL) It stopped working recently and if I remember correctly nothing has changed on my webserver php-4.3.9-3.9.i386 mysql-4.1.12-3 httpd-2.0.52-22 Here is the script: [!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]if(!empty($_FILES["userfile"])) { $uploaddir = "/home/www/fisher/docs/seminarphp/admin/photos/"; // set this to wherever //copy the file to some permanent location if (move_uploaded_file($_FILES["userfile"]["tmp_name"], $uploaddir . $_FILES["userfile"]["name"])) { echo("file uploaded"); } else { echo ("error!"); } } $picturename = $_FILES["userfile"]["name"]; mysql_query("UPDATE reserve SET picture='http://www.mywebserver.com/seminarphp/admin/photos/$picturename' WHERE uid='$rvar_choose'");[!--colorc--][/span][!--/colorc--] I don't see "File Uploaded" or "error"... Any help would be appreciated. Thanks, Kyle
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.