another database printing issue

[Gump]

Howdy folks. Here's what I am doing wrong:

CREATE TABLE days (
monday varchar(255) default NULL,
tuesday varchar(255) default NULL,
wednesday varchar(255) default NULL,
thursday varchar(255) default NULL,
friday varchar(255) default NULL,
saturday varchar(255) default NULL,
sunday varchar(255) default NULL,
FULLTEXT KEY monday (monday)
) TYPE=MyISAM;

INSERT INTO days VALUES ('monday morning', 'tuesdays stuff', 'wednessdays stuff', 'thirsty thursday', 'fridays fluff', 'saturdays hangover', 'SUNDAYS STUFF);

---

script as:

 
$get=mysql_query("SELECT monday FROM days");  

$rows=mysql_num_rows($get); 
if($rows > 0) { 
    while($row=mysql_fetch_array($get)) { 
        echo "Monday: ".$row['monday']."<br>" ;
		echo "Tuesday: ".$row['tuesday']."<br>" ;  

		echo "Wednesday: ".$row['wednesday']."<br>" ;
		echo "Thursday: ".$row['thursday']."<br>" ; 
		echo "Friday: ".$row['friday']."<br>" ;
		echo "Saturday: ".$row['saturday']."<br>" ;
		echo "Sunday: ".$row['sunday']."<br>" ;  

    } 
} 
else { 
    echo "No rows returned"; 
} 

?> 

I know that

$get=mysql_query("SELECT monday FROM days");  

Is most likely the place i am looking wrong. I suppose I could repeat the script every time but it seems a bit clunky.

Any thoughts?

[LordShryku]

Uh.....huh? I don't understand your problem here...

Only think I could guess is that you need to select more than monday....

[Gump]

That sounds correct so like:

$get=mysql_query("SELECT monday, tuesday, wednesday FROM days");

That doesn't do it. I thought there was a way to just select the whole thing. I just do not know how to select more than monday.

Thank you

Matt

[LordShryku]

SELECT * FROM days would work

[Gump]

:rolleyes:

Okay thanks for that I will now assume the * then just states select all in that row.

Cheers!

[LordShryku]

Yep, * means "select all columns"

[Gump]

Thank you once agin. Now I am off to figure out a form that will print the current content from the database in the text boxes supplied. Then the user types in foo bar, hits submit and that days data has changed.

You have many posts, any idea where to start? All my searches were not too relevant.

[LordShryku]

textboxes? Like inputs?
Maybe something like this?

$get=mysql_query("SELECT * FROM days");   

while($row=mysql_fetch_array($get)) {  

    echo "Monday: <input type=\"text\" name=\"Monday\" value=\"".$row['monday']."\">
    <br>
    Tuesday: <input type=\"text\" name=\"Tuesday\" value=\"".$row['tuesday']."\">
    <br>" ;
}
// and so forth

Don't know if this is what you're looking for....

[Gump]

You hit the nail on the head there. That was exactly what I was speaking of.

Except how is it supposed to submit the newly updated details? How can the text boxes be wider or multiline?

I think I will have it then it is starting to finally come togather 😉

[LordShryku]

That just defaults the current values. Once they change the values and submit the form, your update script can change them. Change the size of input boxes using the size=# attribute or use a textarea to make it multi-row

[Gump]

Great thanks for all your help. This site rulz

[LordShryku]

We try 😃

[Gump]

Alrighty aside from probably horribly ugly code, I cant get this baby to submit the updates....what is it missing?

<?

  //  connect to the database
$dbh=mysql_connect ("localhost", "blackwha_dynamo", "dynamo") 
or die ('I cannot connect to the database because: ' . mysql_error()); 
mysql_select_db ("blackwha_dynamo"); 

  ?>


<br>
<form method="post" action="<?php echo $PHP_SELF?>">
    <p> 
    <input type=hidden name="id" value="<?php echo $id ?>">
    <?php



  if ($id) {

// editing so select a record

$sql = "SELECT * FROM days WHERE id=$id";

$result = mysql_query($sql);

$myrow = mysql_fetch_array($result);

$id = $myrow["id"];

$monday = $myrow["monday"];

$tuesday = $myrow["tuesday"];

$wednesday = $myrow["wednesday"];

$thursday = $myrow["thursday"];

$friday = $myrow["friday"];

$saturday = $myrow["saturday"];

$sunday = $myrow["sunday"];

?>
<?  }  ?>
  </p>
  <p><font color="#0000FF" face="Verdana, Arial, Helvetica, sans-serif"><strong> 
    </strong></font><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Mondays 
    specials:<br>
    <input type="Text" name="monday" value="<? echo $monday ?>" size="50">
    <br>
    <br>
    Tuesdays specials:<br>
    <input type="Text" name="tuesday" value="<? echo $tuesday ?>" size="50">
    </font>
  <p><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Wednesdays specials:<br>
    <input type="Text" name="wednesday" value="<? echo $wednesday ?>" size="50">
    <br>
    <br>
    Thursdays specials:<br>
    <input type="Text" name="thursday" value="<? echo $thursday ?>" size="50">
    </font></p>
  <p><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Fridays specials:<br>
    <input type="Text" name="friday" value="<? echo $friday ?>" size="50">
    <br>
    <br>
    Saturdays specials:<br>
    <input type="Text" name="saturday" value="<? echo $saturday ?>" size="50">
    </font></p>
  <p><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Sundays Date:<br>
    <input type="Text" name="sunday" value="<? echo $sunday ?>" size="50">
    <br>
    <br>
    </font><br>
    <input type="Submit" name="submit" value="Enter information">
  </p>
  </form>

Thanks

[LordShryku]

Well, submittions to PHP_SELF can really suck. I suggest going to another page, then header redirecting back to the form. But otherwise, you don't have anything updateing your database. You need to write an update query for it to actually update....

[Gump]

Why do you not like posting to itself out of curiosity? Actually everything else i have written post to a javascript redirect back to the original script. Updates everything nicely that way.

I am off searching for the update query you speak of....but I may come back groveling for the correct implementation of it should I not find it, or more like code it all wrong.

😕

Cheers

[LordShryku]

Okay, it's early, so this might be right, but let me know after I've had some coffee.

<br> 
<form method="post" action="<?php echo $PHP_SELF?>"> 
   <p> 
     <input type=hidden name="id" value="<?php echo $id ?>"> 

<?
$dbh = mysql_connect("localhost", "blackwha_dynamo", "dynamo");
@mysql_select_db ("blackwha_dynamo");

if($submit) {
   $update = "UPDATE days
              SET monday = '".$monday."',
                  tuesday = '".$tuesday."',
                  wednesday = '".$wednesday."',
                  thursday = '".$thursday."',
                  friday = '".$friday."',
                  saturday = '".$saturday."',
                  sunday = '".$sunday."'
              WHERE id = '".$id."'";
   mysql_query($update);
}

if($id) { 
    $sql = "SELECT * FROM days WHERE id='".$id."'"; 
    $result = mysql_query($sql); 
    $myrow = mysql_fetch_array($result); 

$id = $myrow["id"]; 
$monday = $myrow["monday"]; 
$tuesday = $myrow["tuesday"]; 
$wednesday = $myrow["wednesday"]; 
$thursday = $myrow["thursday"]; 
$friday = $myrow["friday"]; 
$saturday = $myrow["saturday"]; 
$sunday = $myrow["sunday"]; 
}
else {
	die("<b>No ID Specified!</b>");
}

mysql_close($dbh);
?>

  </p> 
  <p><font color="#0000FF" face="Verdana, Arial, Helvetica, sans-serif"><strong> 
    </strong></font><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Mondays 
    specials:<br> 
    <input type="Text" name="monday" value="<? echo $monday ?>" size="50"> 
    <br> 
    <br> 
    Tuesdays specials:<br> 
    <input type="Text" name="tuesday" value="<? echo $tuesday ?>" size="50"> 
    </font> 
  <p><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Wednesdays specials:<br> 
    <input type="Text" name="wednesday" value="<? echo $wednesday ?>" size="50"> 
    <br> 
    <br> 
    Thursdays specials:<br> 
    <input type="Text" name="thursday" value="<? echo $thursday ?>" size="50"> 
    </font></p> 
  <p><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Fridays specials:<br> 
    <input type="Text" name="friday" value="<? echo $friday ?>" size="50"> 
    <br> 
    <br> 
    Saturdays specials:<br> 
    <input type="Text" name="saturday" value="<? echo $saturday ?>" size="50"> 
    </font></p> 
  <p><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Sundays Date:<br> 
    <input type="Text" name="sunday" value="<? echo $sunday ?>" size="50"> 
    <br> 
    <br> 
    </font><br> 
    <input type="Submit" name="submit" value="Enter information"> 
  </p> 
  </form>

[Gump]

Howdy again,

Well that returns the die error "No ID Specified!"

Thoughts? Also what does the

mysql_close($dbh);

Do for me in this case? Does this have to do with persistant connections?

[LordShryku]

Uhmm.....specify an ID...

or take out the die statement.

mysql_close closes you DB connection. Otherwise you'll be leaving connections open

[Gump]

Ahhh okay I am slow.

So I put whtever.com/file.php?id=1 and it pulls up the data, same as it was with my clunky script before, but when I update anything the only thing that updates is test.php?id=1

Not the actual database.

As for leaving connections open is this just sloppy code or will it increase a server load or have any otherwise negative effects?

[LordShryku]

Well, it's both sloppy code, and it creates broken connections. If a lot of broken connections are out there, it could increase your load.

As far as updating the DB, that's what this piece of code is for...

if($submit) { 
   $update = "UPDATE days 
              SET monday = '".$monday."', 
                  tuesday = '".$tuesday."', 
                  wednesday = '".$wednesday."', 
                  thursday = '".$thursday."', 
                  friday = '".$friday."', 
                  saturday = '".$saturday."', 
                  sunday = '".$sunday."' 
              WHERE id = '".$id."'"; 
   mysql_query($update); 
}