My next question (PHP)

flishess · 12-03-2007, 05:12 AM

I am trying to get the "platforms" listed in my database to show up where "$platform" is at in the drop down box.

Code:

<?
include("config.php");
?>
<html>
<form method="post" action="cp_admin/submitgame.php">

<h3>Title:</h3>
<input type="text" NAME="title">

<h3>Description:</h3>
<textarea name="description" rows="10" cols="48"></textarea>

<h3>Platform:</h3>
<select name="platform">
  <option value="$platform">
</select>
<br>
<br>
<INPUT TYPE="submit" name="submit" value="submit">
</form>
</html>

can anyone help out?

Peter · 12-03-2007, 05:47 AM

$platform is not within php tags. It should be:-

PHP Code:

<?PHP echo $platform ?>

Daniel · 12-03-2007, 06:15 AM

Is it even set to a variable yet, from the code it doesn't look like it is, unless you set it in config.php.

I'll be on in a few hours if you need help

flishess · 12-03-2007, 11:35 AM

here is what I have now, I tried it with GET and POST - neither of the two work.

Code:

<?
include("config.php");
$platform = mysql_real_escape_string($_GET['platname']);
?>
<html>
<form method="post" action="cp_admin/submitgame.php">

<h3>Title:</h3>
<input type="text" NAME="title">

<h3>Description:</h3>
<textarea name="description" rows="10" cols="48"></textarea>

<h3>Platform:</h3>
<select name="platform">
  <option value="<?PHP echo $platform ?>">
</select>
<br>
<br>
<INPUT TYPE="submit" name="submit" value="submit">
</form>
</html>

I think it needs to say something about selecting the row that the table is, or something like that instead of GET or POST.

I also tried this, and it does not work either:
????: NamePros.com http://www.namepros.com/programming/402651-resolved-my-next-question-php.html

Code:

<?
include("config.php");
$platform = $row['platname'];
while($row = mysql_fetch_array( $result )) {
$result = mysql_query("SELECT * FROM platform") 
or die(mysql_error());
?>
<html>
<form method="post" action="cp_admin/submitgame.php">

<h3>Title:</h3>
<input type="text" NAME="title">

<h3>Description:</h3>
<textarea name="description" rows="10" cols="48"></textarea>

<h3>Platform:</h3>
<select name="platform">
  <option value="<?PHP echo $row['platname']; ?>">
</select>
<br>
<br>
<INPUT TYPE="submit" name="submit" value="submit">
</form>
</html>

edit · 12-03-2007, 12:43 PM

Code:

$result = mysql_query("SELECT * FROM platform");

while ($row = mysql_fetch_assoc($result)) {

$platform = '<option value="' . $row['platname']. '">';

}
?>

<select name="platform">
<?php echo $platform; ?>
</select>

Not sure if that will work in this situation, as its just off the top of my head but test it out and let me know.

flishess · 12-03-2007, 03:52 PM

edit, I don't get any errors with your version, but It doesn't show up either with the platforms.

edit · 12-03-2007, 06:25 PM

I actually forgot a pretty important part of that code

Code:

$platform = '<option value="' . $row['platname']. '">';

Should be

Code:

$platform = '<option value="' . $row['platname']. '">' . $row['platname'] . '</option>';

flishess · 12-04-2007, 11:18 AM

Edit, that worked, however there are more than one Platforms listed in the database and it only shows the last one.

edit · 12-04-2007, 01:30 PM

try adding

Code:

$platform = '';

prior to the while statement. I ran a quick test on this on my home server and all came out ok. If this doesn't work, let me know and I'll continue to troubleshoot.

flishess · 12-04-2007, 02:47 PM

Like, this: it didn't work...

Code:

$result = mysql_query("SELECT * FROM platform");
$platform = '';
while ($row = mysql_fetch_assoc($result)) {

$platform = '<option value="' . $row['platname']. '">';

}
?>

<select name="platform">
<?php echo $platform; ?>
</select>

Barrucadu · 12-04-2007, 03:00 PM

Try this:

PHP Code:

 
$result = mysql_query("SELECT * FROM platform");

$platform = '';

while ($row = mysql_fetch_assoc($result)) {

 
$platform .= '<option value="' . $row['platname']. '">' . $row['platname']. '</option>';

 
}

?>

 
<select name="platform">

<?php echo $platform; ?>

????: NamePros.com http://www.namepros.com/showthread.php?t=402651
</select>

flishess · 12-04-2007, 04:06 PM

mikor: Thanks that fixed it! Thanks to all those that helped!

edit · 12-04-2007, 07:20 PM

There we go, Thanks Mikor I knew I was missing a character somewhere

12-03-2007, 05:47 AM	#2 (permalink)
Peter NamePros Expert Join Date: Nov 2003 Location: Scotland Posts: 5,069	$platform is not within php tags. It should be:- PHP Code: `<?PHP echo $platform ?>` __________________ Manage your portfolio using my new Domain Portfolio Management script. Securing Your Domain Name From Theft

12-03-2007, 06:15 AM	#3 (permalink)
Daniel Danltn.com Join Date: May 2007 Location: Danltn.com / Nottingham, UK Posts: 1,201	Is it even set to a variable yet, from the code it doesn't look like it is, unless you set it in config.php. I'll be on in a few hours if you need help __________________ :lala: *VERY CHEAP ADVANCED* BULK DOMAIN-STATISTICS LOOKUP** :kickass: Danltn's Blog - Daniel Neville's Site Spoof your links! Submit your blog NOW! Putting bloggers on the map!

12-03-2007, 12:43 PM	#5 (permalink)
edit NamePros Member Join Date: Nov 2003 Posts: 107	Code: $result = mysql_query("SELECT * FROM platform"); while ($row = mysql_fetch_assoc($result)) { $platform = '<option value="' . $row['platname']. '">'; } ?> <select name="platform"> <?php echo $platform; ?> </select> Not sure if that will work in this situation, as its just off the top of my head but test it out and let me know. __________________ Complete Resource Management Script - Myspace / Social Network Layout and Graphic Script Online business lens - My personal experiences in internet business.

12-03-2007, 06:25 PM	#7 (permalink)
edit NamePros Member Join Date: Nov 2003 Posts: 107	I actually forgot a pretty important part of that code Code: $platform = '<option value="' . $row['platname']. '">'; Should be Code: $platform = '<option value="' . $row['platname']. '">' . $row['platname'] . '</option>'; __________________ Complete Resource Management Script - Myspace / Social Network Layout and Graphic Script Online business lens - My personal experiences in internet business.

12-04-2007, 01:30 PM	#9 (permalink)
edit NamePros Member Join Date: Nov 2003 Posts: 107	try adding Code: $platform = ''; prior to the while statement. I ran a quick test on this on my home server and all came out ok. If this doesn't work, let me know and I'll continue to troubleshoot. __________________ Complete Resource Management Script - Myspace / Social Network Layout and Graphic Script Online business lens - My personal experiences in internet business.

12-03-2007, 03:52 PM	THREAD STARTER #6 (permalink)
flishess NamePros Regular Join Date: Apr 2005 Posts: 394	edit, I don't get any errors with your version, but It doesn't show up either with the platforms.

12-04-2007, 11:18 AM	THREAD STARTER #8 (permalink)
flishess NamePros Regular Join Date: Apr 2005 Posts: 394	Edit, that worked, however there are more than one Platforms listed in the database and it only shows the last one.

12-04-2007, 03:00 PM	#11 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	Try this: PHP Code: `$result = mysql_query("SELECT * FROM platform"); $platform = ''; while ($row = mysql_fetch_assoc($result)) { $platform .= '<option value="' . $row['platname']. '">' . $row['platname']. '</option>'; } ?> <select name="platform"> <?php echo $platform; ?> ????: NamePros.com http://www.namepros.com/showthread.php?t=402651 </select>` __________________ Website \| Blog Arch Hurd developer; GNU Webmaster; FSF member #8385

12-04-2007, 04:06 PM	THREAD STARTER #12 (permalink)
flishess NamePros Regular Join Date: Apr 2005 Posts: 394	mikor: Thanks that fixed it! Thanks to all those that helped!

12-04-2007, 07:20 PM	#13 (permalink)
edit NamePros Member Join Date: Nov 2003 Posts: 107	There we go, Thanks Mikor I knew I was missing a character somewhere __________________ Complete Resource Management Script - Myspace / Social Network Layout and Graphic Script Online business lens - My personal experiences in internet business.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)