Code problem Or installed wrong?

CoderJohan

I have a problem... I have installed PHP Apache and Mysql on my windows system PHP and Mysql is the new version but Apache is 1.35. When i try to insert information into the database with this code you see bellow it doesn't work... but i can extract information from the database and put it on a webpage... Can't see what the trouble is...

<?php
	include './global/dblib.php';
	if(!empty($Submit)){
		$sql="INSERT INTO ubn_klotter(id,namn,text) VALUES ('$id','$namn','$text')";
		mysql_query("$sql");
	}
	$result = mysql_query("SELECT * FROM ubn_klotter  ORDER BY id ASC");
?>

Here is a menu code i made in php that also doesn't work localy but on the main webserver it works like a charm... When clicking on Webshop there should be a foldout and show the links in Webshop but it doesn't work for some reson...

<?php

function lista(){
global $val;
	if($val=="info"){
		echo"<table width=\"50\" border=\"0\">";
		echo"  <tr>";
		echo"    <td nowrap=\"nowrap\"><img src=\"./images/unfold.gif\"border='0'>Information<br><img src=\"./images/space.gif\"><a href='news.php' target='mainFrame' class='forumlink'>Nyheter</a><br><img src=\"./images/space.gif\"><a href='villkor.php' target='mainFrame' class='forumlink'>Köpvillkor</a><br></td>";
		echo"  </tr><tr>";
		echo"    <td nowrap=\"nowrap\"><img src=\"./images/fold.gif\"border='0'><a href=\"left.php?val=shop\" class=\"forumlink\">Webshop</a></td>";
		echo"  </tr><tr>";
		echo"    <td nowrap=\"nowrap\"><img src=\"./images/fold.gif\"border='0'><a href=\"left.php?val=kont\" class=\"forumlink\">Kontakta</a></td>";
		echo"  </tr><tr>";
		echo"</table>";
	}
	else if($val=="shop"){
		echo"<table width=\"50\" border=\"0\">"; 
		echo"  <tr>";
		echo"    <td nowrap=\"nowrap\"><img src=\"./images/fold.gif\" border='0'><a href=\"left.php?val=info\" class=\"forumlink\">Information</a></td>";
		echo"  </tr><tr>";
		echo"    <td nowrap=\"nowrap\"><img src=\"./images/unfold.gif\" border='0'>Webshop<br>";
		echo"	 <img src=\"./images/space.gif\" border='0'><img src=\"./images/fold.gif\" border='0'><a href=\"left.php?val=Cell Entertainment\" class=\"forumlink\">Cell Entertainment</a><br>";
		echo"	 <img src=\"./images/space.gif\"><a href=\"left.php?val=Games-Workshop\" class=\"forumlink\"><img src=\"./images/fold.gif\" border='0'>Games Workshop</a><br>";
		echo"	 <img src=\"./images/space.gif\"><a href=\"left.php?val=Utförsäljning\" class=\"forumlink\"><img src=\"./images/fold.gif\" border='0'>Utförsäljning</a><br><br>";
		echo"	 <img src=\"./images/space.gif\"><a href='kassa.php' class='forumlink' target='mainFrame' class='forumlink'>Gå till kassan</a></td>";
		echo"  </tr><tr>";
		echo"    <td nowrap=\"nowrap\"><img src=\"./images/fold.gif\" border='0'><a href=\"left.php?val=kont\" class=\"forumlink\">Kontakta</a></td>";
		echo"  </tr>";
		echo"</table>";
	}

//Länkarna till GW
		else if($val=="Games-Workshop"){
			$result = mysql_query("SELECT * FROM webshop_kategori WHERE foretag = '$val' ORDER BY kategori ASC");
			echo"<table width=\"50\" border=\"0\">";
			echo"  <tr>";
			echo"    <td nowrap=\"nowrap\"><img src=\"./images/fold.gif\" border='0'><a href=\"left.php?val=info\" class=\"forumlink\">Information</a></td>";
			echo"  </tr><tr>";
			echo"    <td nowrap=\"nowrap\"><img src=\"./images/space.gif\" border='0'><img src=\"./images/fold.gif\" border='0'><a href=\"left.php?val=Cell Entertainment\" class=\"forumlink\">Cell Entertainment</a><br>";
			echo"	 <img src=\"./images/space.gif\"><img src=\"./images/unfold.gif\" border='0'>Games Workshop<br>";
				while ($row = mysql_fetch_array($result)){
					echo "<img src=\"./images/space.gif\" width=\"57\" height=\"16\" /><a href=\"val.php?val=$row[kategori]&foretag=$val\" target=\"mainFrame\" class=\"forumlink\"><font size=\"2\">$row[kategori]</font></a><br>";
				}
			echo"<img src=\"./images/space.gif\"><img src=\"./images/fold.gif\" border='0'>Utförsäljning<br><br><img src=\"./images/space.gif\"><a href='kassa.php' class='forumlink' target='mainFrame' class='forumlink'>Gå till kassan</a></td>";
			echo"  </tr><tr>";
			echo"    <td nowrap=\"nowrap\"><img src=\"./images/fold.gif\" border='0'><a href=\"left.php?val=kont\" class=\"forumlink\">Kontakta</a></td>";
			echo"  </tr>";
			echo"</table>";
		}

//Länkarna till Utförsäljning
		else if($val=="Utförsäljning"){
			$result = mysql_query("SELECT * FROM webshop_kategori WHERE foretag = '$val' ORDER BY kategori ASC");
			echo"<table width=\"50\" border=\"0\">";
			echo"  <tr>";
			echo"    <td nowrap=\"nowrap\"><img src=\"./images/fold.gif\"><a href=\"left.php?val=info\" class=\"forumlink\">Information</a></td>";
			echo"  </tr><tr>";
			echo"    <td nowrap=\"nowrap\"><img src=\"./images/fold.gif\">Webshop<br><img src=\"./images/space.gif\"><a href=\"left.php?foretag=Cell Entertainment\" class=\"forumlink\"><img src=\"./images/fold.gif\" border='0'>Cell Entertainment</a><br><img src=\"./images/space.gif\"><a href=\"left.php?val=Games-Workshop\" class=\"forumlink\"><img src=\"./images/fold.gif\" border='0'>Games Workshop</a><br>";
			echo"<img src=\"./images/space.gif\"><img src=\"./images/unfold.gif\">Utförsäljning<br>";
				while ($row = mysql_fetch_array($result)){
					echo "<img src=\"./images/space.gif\" width=\"57\" height=\"16\" /><a href=\"val.php?val=$row[kategori]&foretag=$val\" target=\"mainFrame\" class=\"forumlink\"><font size=\"2\">$row[kategori]</font></a><br>";
				}
			echo" <img src=\"./images/space.gif\"><a href='kassa.php' class='forumlink' target='mainFrame' class='forumlink'><a href='kassa.php' class='forumlink' target='mainFrame' class='forumlink'>Gå till kassan</a></a></td>";
			echo"  </tr><tr>";
			echo"    <td nowrap=\"nowrap\"><img src=\"./images/fold.gif\"><a href=\"left.php?val=kont\" class=\"forumlink\">Kontakta</a></td>";
			echo"  </tr>";
			echo"</table>";
		}		

//Länkarna till Cell
		else if($val=="Cell Entertainment"){
			$result = mysql_query("SELECT * FROM webshop_kategori WHERE foretag = '$val' ORDER BY kategori ASC");
			echo"<table width=\"50\" border=\"0\">";
			echo"  <tr>";
			echo"    <td nowrap=\"nowrap\"><img src=\"./images/fold.gif\" border='0'><a href=\"left.php?val=info\" class=\"forumlink\">Information</a></td>";
			echo"  </tr><tr>";
			echo"    <td nowrap=\"nowrap\"><img src=\"./images/unfold.gif\">Webshop<br><img src=\"./images/space.gif\"><img src=\"./images/unfold.gif\">Cell Entertainment<br>";
				while ($row = mysql_fetch_array($result)){
					echo "<img src=\"./images/space.gif\" width=\"57\" height=\"16\" /><a href=\"val.php?val=$row[kategori]&foretag=$val\" target=\"mainFrame\" class=\"forumlink\"><font size=\"2\">$row[kategori]</font></a><br>";
				}
			echo"	 <img src=\"./images/space.gif\"><a href=\"left.php?val=Games-Workshop\" class=\"forumlink\"><img src=\"./images/fold.gif\" border='0'>Games Workshop</a><br>";
			echo"	 <img src=\"./images/space.gif\">Utförsäljning<br>";
			echo"	 <img src=\"./images/space.gif\"><a href='kassa.php' class='forumlink' target='mainFrame' class='forumlink'>Gå till kassan</a></td>";
			echo"  </tr><tr>";
			echo"    <td nowrap=\"nowrap\"><img src=\"./images/fold.gif\"><a href=\"left.php?val=kont\" class=\"forumlink\">Kontakta</a></td>";
			echo"  </tr>";
			echo"</table>";
		}

	else{
		echo"<table width=\"50\" border=\"0\">";
		echo"  <tr>";
		echo"    <td nowrap=\"nowrap\"><img src=\"./images/fold.gif\"><a href=\"left.php?val=info\" class=\"forumlink\">Information</a></td>";
		echo"  </tr><tr>";
		echo"    <td nowrap=\"nowrap\"><img src=\"./images/fold.gif\"><a href=\"left.php?val=shop\" class=\"forumlink\">Webshop</a></td>";
		echo"  </tr><tr>";
		echo"    <td nowrap=\"nowrap\"><img src=\"./images/fold.gif\"><a href=\"left.php?val=kont\" class=\"forumlink\">Kontakta</a></td>";
		echo"  </tr>";
		echo"</table>";
	}

}
?>

I don't know if i have installed PHP wrong couse it won't foldout any ideas on how to solve this? The code is really messy and i shall rewrite it but i need to know what the problem is before i start rewriting it... There must something wrong with my PHP configuration...
//Johan

cgraz

Are you getting the values that go into the INSERT from a form? My guess would be register globals is set to off (as it is by default), and on your web server it's set to on. If this is the case, you have two solutions:

In your php.ini file, set register globals to on.
Change all occurences of $form_val to $POST['form_val']
(assuming your form method is set to POST). All your form values need to be in the format: $POST['var_name']

Number 1 would be easier, but it's up to you. They set register globals to off for a reason, but if you'll be using this code on your web server later, might as well just change register globals to on on your system.

Cgraz

CoderJohan

Hmmm... i have set global on ON but still no change and put php.ini in c:\winnt

The problem is still the same... i even installed php 4.2.3 that the webserver that is gonna run this script is running but that wasn't the problem... But i know for a fact that these codes work on the other server that is running 4.2.3 but not on mine?!?!?!
//Johan

cgraz

try changing

$sql="INSERT INTO ubn_klotter(id,namn,text) VALUES ('$id','$namn','$text')";
        mysql_query("$sql");

$sql="INSERT INTO ubn_klotter(id,namn,text) VALUES ('$id','$namn','$text')";
        print $sql . "<br>";
        mysql_query($sql) or die(mysql_error());

and tell me what that prints

CoderJohan

Nothing... It happens nothing... it's like it won't accept post variables for some reason... here is the whole script

<!DOCTYPE html PUBLIC "_//W3C//DTD XHTML 1.0 transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Pragma" content="no-cache">
<link href="global/style.css" rel="stylesheet" type="text/css" />
</head>
<?php
	include './global/dblib.php';
	if(!empty($Submit)){
$sql="INSERT INTO ubn_klotter(id,namn,text) VALUES ('$id','$namn','$text')";
        print $sql . "<br>";
        mysql_query($sql) or die(mysql_error());
	}
	$result = mysql_query("SELECT * FROM ubn_klotter  ORDER BY id ASC");
?>
<body topmargin="0">
<table width="100%" border="0">
  <tr>
    <td><div align="center">
	<?php
		$i=0;
        echo "<table width='100%' border='0' cellpadding='0' cellspacing='0'>";
          while ($row = mysql_fetch_array($result)){
		  	if($i==0){	
				echo"<tr>";
            		echo"<td><p>$row[namn]: $row[text]</p></td>";
          		echo"</tr>";
				$i++;
			}
			else{          	
				echo"<tr>";
            		echo"<td bgcolor='#3C3C3C'><p>$row[namn]: $row[text]</p></td>";
          		echo"</tr>";
				$i=0;
			}
		  }
        echo"</table>";
	?>

	<form name="form1" id="form1" method="post" action="klotter.php">
    <table width="100%" border="0">
      <tr> 
        <td><input name="namn" type="text" id="namn" value="Namn" maxlength="20" class="box" /></td>
      </tr>
      <tr> 
        <td><input name="text" type="text" id="text" value="Meddelande" maxlength="1024" class="box"/></td>
      </tr>
      <tr> 
          <td nowrap="nowrap"> <div align="center">
              <input type="reset" name="Reset" value="&Aring;terst&auml;ll" class="button" />
              <input type="submit" name="Submit" value="Skicka" class="button" />
            </div></td>
      </tr>
    </table>
	</form>
  </div></td>
  </tr>
</table>
</body>
</html>

CoderJohan

I have solved the problem... For some reason my php.ini hade register_globals on to places in php.ini...

The on set to on
and the other who came lower down was set to off so that was the problem... now it works like a charm again... Thanks for the help
//Johan