Jump to content

pulling info from database to select list

dropfaith

By dropfaith
in PHP Coding Help

Recommended Posts

dropfaith Advanced Member

dropfaith

Posted
Posted

So i have a select box for business hours  im going to be making it  update into database so i need it to pull data from mysql then show the current selected hour from database

<?php

// form not yet submitted

// display initial form

if (!isset($_POST['submit']))

{

?>


			<fieldset>
				<legend>Add Hours</legend>
				<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="POST">


<?php
    $u = $_SESSION['username'];
    $uid = $_SESSION['loginid'];
$Id = mysql_escape_string($_GET['Id']);
$query = "SELECT * FROM food WHERE Id = '$Id'";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
// if records present
if (mysql_num_rows($result) > 0)
{
// iterate through resultset
// print article Names
while($row = mysql_fetch_object($result))
{
?>
<input type=hidden name="Id" value="<? echo $row->Id; ?>">
<input type=hidden name="Name" value="<? echo $row->Name; ?>">
<?php
}
}
// if no records present
// display message
else
{
?>

<?php
}
// close database connection
mysql_close($connection);
?>



				<p>
					<label>Sunday</label>
						<select name="OpenSun">	
							<option value="6am">1 am
						    <option value="6am">2 am
							<option value="6am">3 am
							<option value="6am">4 am
							<option value="6am">5 am
							<option value="6am">6 am
							<option value="6am">7 am
							<option value="6am">8 am
							<option value="6am">9 am
							<option value="6am">10 am
							<option value="6am">11 am
							<option value="6am">12 am
							<option value="6am">1 pm
						    <option value="6am">2 pm
							<option value="6am">3 pm
							<option value="6am">4 pm
							<option value="6am">5 pm
							<option value="6am">6 pm
							<option value="6am">7 pm
							<option value="6am">8 pm
							<option value="6am">9 pm
							<option value="6am">10 pm
							<option value="6am">11 pm
							<option value="6am">12 pm
						</select>To
						<select name="CloseSun">
							<option value="6am">1 am
						    <option value="6am">2 am
							<option value="6am">3 am
							<option value="6am">4 am
							<option value="6am">5 am
							<option value="6am">6 am
							<option value="6am">7 am
							<option value="6am">8 am
							<option value="6am">9 am
							<option value="6am">10 am
							<option value="6am">11 am
							<option value="6am">12 am
							<option value="6am">1 pm
						    <option value="6am">2 pm
							<option value="6am">3 pm
							<option value="6am">4 pm
							<option value="6am">5 pm
							<option value="6am">6 pm
							<option value="6am">7 pm
							<option value="6am">8 pm
							<option value="6am">9 pm
							<option value="6am">10 pm
							<option value="6am">11 pm
							<option value="6am">12 pm
						</select>
				</p>
<p>
					<label>Monday</label>
						<select name="OpenMon">
							<option value="6am">1 am
						    <option value="6am">2 am
							<option value="6am">3 am
							<option value="6am">4 am
							<option value="6am">5 am
							<option value="6am">6 am
							<option value="6am">7 am
							<option value="6am">8 am
							<option value="6am">9 am
							<option value="6am">10 am
							<option value="6am">11 am
							<option value="6am">12 am
							<option value="6am">1 pm
						    <option value="6am">2 pm
							<option value="6am">3 pm
							<option value="6am">4 pm
							<option value="6am">5 pm
							<option value="6am">6 pm
							<option value="6am">7 pm
							<option value="6am">8 pm
							<option value="6am">9 pm
							<option value="6am">10 pm
							<option value="6am">11 pm
							<option value="6am">12 pm	
						</select>To
						<select name="CloseMon">
							<option value="6am">1 am
						    <option value="6am">2 am
							<option value="6am">3 am
							<option value="6am">4 am
							<option value="6am">5 am
							<option value="6am">6 am
							<option value="6am">7 am
							<option value="6am">8 am
							<option value="6am">9 am
							<option value="6am">10 am
							<option value="6am">11 am
							<option value="6am">12 am
							<option value="6am">1 pm
						    <option value="6am">2 pm
							<option value="6am">3 pm
							<option value="6am">4 pm
							<option value="6am">5 pm
							<option value="6am">6 pm
							<option value="6am">7 pm
							<option value="6am">8 pm
							<option value="6am">9 pm
							<option value="6am">10 pm
							<option value="6am">11 pm
							<option value="6am">12 pm	
						</select>
				</p>






<input type="Submit" name="submit" value="Add">									
				</form>
			</fieldset>
<?php
}
else
{
   // includes
    include("../template/conf.php");
    // set up error list array
    $errorList = array();
    $count = 0;
    // validate text input fields
    $Name = mysql_escape_string($_POST['Name']);
    $Id = mysql_escape_string($_POST['Id']);
    $OpenSun = mysql_escape_string($_POST['OpenSun']);
    $CloseSun = mysql_escape_string($_POST['CloseSun']);
    $OpenMon = mysql_escape_string($_POST['OpenMon']);
    $CloseMon = mysql_escape_string($_POST['CloseMon']);
    $OpenTue = mysql_escape_string($_POST['OpenTue']);
    $CloseTue = mysql_escape_string($_POST['CloseTue']);
    $OpenWed = mysql_escape_string($_POST['OpenWed']);
    $CloseWed = mysql_escape_string($_POST['CloseWed']);
    $OpenThur = mysql_escape_string($_POST['OpenThur']);
    $CloseThur = mysql_escape_string($_POST['CloseThur']);
    $OpenFri = mysql_escape_string($_POST['OpenFri']);
    $CloseFri = mysql_escape_string($_POST['CloseFri']);
    $OpenSat = mysql_escape_string($_POST['OpenSat']);
    $CloseSat = mysql_escape_string($_POST['CloseSat']);
    // check for errors
    // if none found...
    if (sizeof($errorList) == 0)
    {
        // open database connection
        $connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
        // select database
        mysql_select_db($db) or die ("Unable to select database!");
        // generate and execute query
        $query = "INSERT INTO hours (Name, Id, OpenSun, CloseSun, OpenMon, CloseMon, OpenTue, CloseTue, OpenWed, CloseWed, OpenThur, CloseThur, OpenFri, CloseFri, OpenSat, CloseSat) VALUES('$Name','$Id','$OpenSun','$CloseSun','$OpenMon','$CloseMon','$OpenTue','$CloseTue','$OpenWed','$CloseWed','$OpenThur','$CloseThur','$OpenFri',' $CloseFri','$OpenSat','$CloseSat')";
        $result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
        // print result
        echo "<?<font size=-1>Update successful.<a href=index.php>Go Home</a>.<br /></font>";
        // close database connection
        mysql_close($connection);
    }
    else
    {
        // errors found
        // print as list
        echo "<font size=-1>The following errors were encountered: <br>";
        echo "<ul>";
        for ($x=0; $x<sizeof($errorList); $x++)
        {
            echo "<li>$errorList[$x]";
        }
        echo "</ul></font>";
    }
}
?>

phoenixx Member

phoenixx

Posted
Posted

Are you trying to get the current server time to be auto selected in the select box or the client's machine local time?  The problem is that if you are trying to get the client's local time then you need javascript to get the local machine time and integrate it into your php time() or date() statement.

dropfaith Advanced Member

dropfaith

Posted
  • Author
Posted

neither its business hours

http://www.lawrenceguide.org/user/addhours.php?Id=1 im making a business index and  i want it so the business can list hours of operation  then update them if they change the hours

 

username: admin

Password: twisted

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • 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.