Selecting database - Codewalkers

Codewalkers Forums Sponsor:

Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here!

July 1st, 2002, 01:27 AM

russ

Join Date: Apr 2007

Location: London, UK

Posts: 129

Time spent in forums: < 1 sec
Reputation Power: 2

Selecting database

okay, I'm trying to make my site easy for my to update and stuff, I also want it to have less pages, so I had the great idea of haveing a drop down menu to select a database, but for some reason its not working, basicly, the select variable doesn't seem to be passing though.

php Code:

Original - php Code

 
<?php 
$db = @mysql_connect("$dbhost", "$dbuname", "$dbpage");
if (!$db) {
  echo( "<p>Unable to connect to the " .
        "database server at this time.</p>" );
  exit();
}
mysql_select_db("$dbname", $db);
if (! @mysql_select_db("$dbname") ) {
  echo( "<p>Unable to locate the $select " .
        "database at this time.</p>" );
  exit();
}
if($submit)
{
$sql = "INSERT INTO ".$_GET['select']."db (band, song, tab) VALUES ('$band', '$song', '$tab')";
$result = mysql_query($sql); 
echo( "Thank you! Information entered. Click <a href=/".$_GET['select'].".php>here</a> to view your tab" ); 
} 
else 
{ 
?> 
<form method="post" action="<?=$PHP_SELF?>"> 
Band Name:
<br><input type="Text" name="band"> 
<br>Song Title:
<br><input type="Text" name="song">
<br>Guitar/Bass/Drum:
<br><select name="select">
<option value="guitar">Guitar</option>
<option value="bass">Bass</option>
<option value="drum">Drum</option>
</select> 
<br>Tab:
<br><textarea name="tab" cols=40 rows=8></textarea> 
<br>
<input type="Submit" name="submit" value="Submit"></form>
<? 
} 
?>

July 1st, 2002, 01:50 AM

Anonymous

Registered User

Codewalkers God 35th Plane (22000 - 22499 posts)

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

RE: Selecting database

your form is using the post method and you are trying to access the select via the get superglobal. Try $_POST instead.....

July 1st, 2002, 07:54 PM

russ

Join Date: Apr 2007

Location: London, UK

Posts: 129

Time spent in forums: < 1 sec
Reputation Power: 2

RE: Selecting database

cheers thank you

July 1st, 2002, 09:27 PM

russ

Join Date: Apr 2007

Location: London, UK

Posts: 129

Time spent in forums: < 1 sec
Reputation Power: 2

RE: Selecting database

Okay, so the first one worked, but I don't get why this one doesn't, its pretty much exactly the same, I seriously can't see whats wrong

php Code:

Original - php Code

 
<?php 
$db = @mysql_connect("$dbhost", "$dbuname", "$dbpage");
if (!$db) {
  echo( "<p>Unable to connect to the " .
        "database server at this time.</p>" );
  exit();
}
mysql_select_db("$dbname", $db);
if (! @mysql_select_db("$dbname") ) {
  echo( "<p>Unable to locate the $select " .
        "database at this time.</p>" );
  exit();
}
if($submit)
{
$sql = "INSERT INTO ".$_POST['select']."db (add, link) VALUES ('$add', '$link')";
$result = mysql_query($sql); 
echo( "Thank you! Information entered. Click <a href=/links.php?action=view&type=".$_POST['select'].">here</a> to view your link" ); 
} 
else 
{ 
?> 
<form method="post" action="<?=$PHP_SELF?>"> 
Type:
<br><select name="select">
<option value="label">Labels</option>
<option value="band">Bands</option>
<option value="zine">Zines</option>
<option value="tab">Tabs</option>
<option value="other">Other</option>
</select>
 
 
<br>Link Address
<br>http://<input type="Text" name="add"> 
 
<br>Link Address
<br><input type="Text" name="link"> 
<br>
<input type="Submit" name="submit" value="Submit"></form>
<? 
} 
?>

July 2nd, 2002, 09:02 PM

russ

Join Date: Apr 2007

Location: London, UK

Posts: 129

Time spent in forums: < 1 sec
Reputation Power: 2

RE: Selecting database

Okay, now I have changed the code to this

php Code:

Original - php Code

 
<?php 
$db = @mysql_connect("$dbhost", "$dbuname", "$dbpage");
if (!$db) {
  echo( "<p>Unable to connect to the " .
        "database server at this time.</p>" );
  exit();
}
mysql_select_db("$dbname", $db);
if (! @mysql_select_db("$dbname") ) {
  echo( "<p>Unable to locate the $select " .
        "database at this time.</p>" );
  exit();
}
if($submit)
{
$sql = "INSERT INTO labeldb (add, link) VALUES ('$add', '$link')";
$result = mysql_query($sql); 
echo( "Thank you! Information entered." ); 
} 
else 
{ 
?> 
<form method="post" action="<?=$PHP_SELF?>"> 
<br>Link Address
<br>http://<input type="Text" name="add"> 
 
<br>Link Address
<br><input type="Text" name="link"> 
<br>
<input type="Submit" name="submit" value="Submit"></form>
<? 
} 
?>

and its still not adding the information

July 2nd, 2002, 09:38 PM

CmdrDats

Join Date: Apr 2007

Location: <br><img src='http://www.dats.co.za/icon.gif'>

Posts: 269

Time spent in forums: < 1 sec
Reputation Power: 2

RE: Selecting database

Is it giving you an error? if not, add this into your code :

php Code:

Original - php Code
<? ... $result = mysql_query($sql); // Add this line print(mysql_error()); echo( "Thank you! Information entered." ); ... ?>

 
<?
  ...
  $result = mysql_query($sql); 
 
  // Add this line
  print(mysql_error());
 
  echo( "Thank you! Information entered." ); 
  ...
?>

Test that and give us the results..

July 2nd, 2002, 10:04 PM

russ

Join Date: Apr 2007

Location: London, UK

Posts: 129

Time spent in forums: < 1 sec
Reputation Power: 2

RE: Selecting database

ah thank u, now I get this error, which is wierd because the code is pretty much exactly the same as my other codes

You have an error in your SQL syntax near 'add, link) VALUES ('www.epitaph.com', 'Epitaph')' at line 1Thank you! Information entered. Click here to view your link

July 3rd, 2002, 08:04 AM

CmdrDats

Join Date: Apr 2007

Location: <br><img src='http://www.dats.co.za/icon.gif'>

Posts: 269

Time spent in forums: < 1 sec
Reputation Power: 2

RE: Selecting database

I have a feeling that the column name "add" is reserved. try changing it to something like "address" or "addy" and see if that works.

I think "link" isn't a reserved word in mysql, so it shouldn't be a problem, but if it still gives headaches, try changing that too..

July 3rd, 2002, 07:39 PM

russ