If Then Statements

Jamez

Hi Guys,

I'm not entirely new to php but I'm still learning a lot of the syntax and functions, so i'm still making stupid mistakes.

Basically im trying to edit my code so that i can insert information into different mysql tables dependant on a variable transerred from a form.

mysql_select_db("thejamez_linkcontrol");

if ($tbl == 'tooth');
{
$query = "INSERT INTO teeth (url, before, anchor, after) VALUES ('$url', '$before', '$anchor', '$after')";
 $result = mysql_query($query);
echo mysql_insert_id();
if ($result)
  echo "mysql_affected_rows()"." Inserted into DB.";
  echo "Printing to see if it works - put into teeth $url : $anchor";
  exit;}

else ($tbl == 'team2g');
{
$query = "INSERT INTO team2g (url, before, anchor, after) VALUES ('$url', '$before', '$anchor', '$after')";
 $result = mysql_query($query);
echo mysql_insert_id();
if ($result)
  echo "mysql_affected_rows()"." Inserted into DB.";
  echo "Printing to see if it works - put into team2g $url : $anchor";
  exit;}

The variable im trying to carry over is "$tbl" , and if it equals "tooth" i want it to insert into the "teeth" table, but if it equals "team2g" i want it to insert into the "team2g" table.

I'm obviously doing something wrong because when $tbl was equal to either variable it was only adding to teeth.

Anyone see an obvious error?

jonno946

What about this?


mysql_select_db("thejamez_linkcontrol"); 

if ($tbl == 'tooth') {

$query = "INSERT INTO teeth (url, before, anchor, after) VALUES ('$url', '$before', '$anchor', '$after')";

$result = mysql_query($query);

if($result) {

echo "Inserted OK";

} else {

echo "Something went wrong...";

}

}

if($tbl == 'team2g') {

$query = "INSERT INTO team2g (url, before, anchor, after) VALUES ('$url', '$before', '$anchor', '$after')";

$result = mysql_query($query);

if($result) {

echo "Inserted OK";

} else {

echo "Something went wrong...";

}

}

Jamez

Well i tried that and it didnt echo the confirm or the error message...

heres all the code:

for insert.php

<? include 'connect.php'; ?>

<h1>Results of Addition</h1>
<?
 if (!$url || !$anchor)
  { echo "You must enter a URL and Anchor Text.<br>"
         ."Go Back and Try again.";
	exit;
  }

$tbl = ($tbl); 
$url = ($url);
$before = ($before);
$anchor = ($anchor);
$after = ($after);


mysql_select_db("thejamez_linkcontrol");  

if ($tbl == 'tooth') { 

$query = "INSERT INTO teeth (url, before, anchor, after) VALUES ('$url', '$before', '$anchor', '$after')"; 

$result = mysql_query($query); 

if($result) { 

echo "Inserted OK"; 

} else { 

echo "Something went wrong..."; 

} 

} 

if($tbl == 'team2g') { 

$query = "INSERT INTO team2g (url, before, anchor, after) VALUES ('$url', '$before', '$anchor', '$after')"; 

$result = mysql_query($query); 

if($result) { 

echo "Inserted OK"; 

} else { 

echo "Something went wrong..."; 

} 

}

?>

and for the actual form that is sending the variables to insert.php

<?
if($_GET["cmd"]=="teeth")
{$tbl = 'tooth';}

if($_GET["cmd"]=="team2g")
{$tbl = 'team2g';}
?>

<html>
<body>
<h1>Add Entries to <? echo $tbl; ?></h1>
<form action="insert.php" method="post">
<input type="hidden" name="<? echo $tbl ?>" value="<? echo $tbl ?>">
<table><tr>
<td>Site URL:</td><td><input type="text" name="url"></td>
</tr><tr>
<td>Before Text:</td><td><input type="text" name="before"></td>
</tr>
<tr>
<td>Anchor Text:</td><td><input type="text" name="anchor"></td>
</tr>
<tr>
<td>After Text:</td><td><input type="text" name="after"></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" value="Add"></td>
</tr></table>
</form>
</body>
</html>

I'm completely lost as to where the error might be 🙁

Jamez

I just tried echoing the $tbl variable on insert.php and it came out blank - meaning im somehow losing the variable...😕

jonno946

is register_globals on or off in your php.ini?

Jamez

fixed mistake 🙂

needed to add the hidden value on the form to be named=tbl instead of what $tbl equals...

<input type="hidden" name="tbl" value="<? echo $tbl ?>">

😃 thanx for your help j