[RESOLVED] Can't add but I can update, collation ?

jeffafd

I changed servers and now I am having trouble inserting items.

The new mysql that I am using is 4.1.19 and has the collation field, the old did not.

I can go and edit any record through my script, but for some reason I now cannot add any records, I am using the same php pages so it appears to be the mysql collation, it is now set on "latin1_swedish1_ci.

Here is my insert file that did work on the old but not on the new:

<?php
if ($submit) {

//Database Connection
   include "db.inc.php";

  $sql = "INSERT INTO jokes (title,content,category) VALUES ('$title','$content','$category')";

  $result = mysql_query($sql);

echo "Thank you! Information entered.\n  <a href='http://www.blondesandrednecks.com/admin'>Continue</a>";

} else{

  // display form

  ?>

   <img src="http://www.blondesandrednecks.com//barlogo.jpg" align="center">
	<br>
	<table border="0" width="100%">
	<tr>
	<td width="25%" align="left"><a href="index.php">Return to Administration</a></td>
	<td width="75%" align="left"><h2><u>Enter New Joke</u></h2></td>
	</tr></table>
<hr>

  <center><table width="90%" border="0">
  <tr><td valign="top">

  <form method="post" action="<?php echo $PHP_SELF?>">

  Title:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<textarea name="title" rows="1" cols="70"></textarea><br>

  Content:&nbsp;&nbsp;&nbsp;&nbsp;<textarea name="content" rows="14" cols="70"></textarea><br>

  Category: <?php include_once("category.php"); ?> 

  <br>

  <br>

  <input type="Submit" name="submit" value="Enter information">

  </form>
</td>
<td valign="top">


</td></tr>
</table></center>
  <?php


} // end if


?>

Please help.

TheDefender

Change this:

$result = mysql_query($sql);

to this:

$result = mysql_query($sql) or die(mysql_error());

And let us know if that reports anything... I'd be interested in seeing where your insertion variables are being assigned... It's almost like you went from a server with Register Globals ON to Register Globals OFF, in which case, your script may need to be adjusted accordingly.

It looks like you are calling them based on Register Globals being ON...

Try:

if ($_POST['submit']) {

And make sure you make the same changes to the other form variables in your insertion statement. If you need help beyond that, post back the modified code.

I don't think it's a collation thing, because I have an old PHP/MySQL server here, and one running 5xx and my code is interchangeable between the two regardless of the collation.

jeffafd

Thanks for the quick response,

I tried this but it didn't work-

$result = mysql_query($sql) or die(mysql_error());

But not sure where to put this -

if ($_POST['submit']) {

jeffafd

I didn't mean didn't work, I mean it didn't return anything, it just refreshes the page, it does not go to the page it is set to after inserting.

jeffafd

I just checked and sure enough the Register globals were on with the old and are off with the new.

Do I just need to change the scripts?

TheDefender

Well, you could either turn it on on the new server (NOT RECOMMENDED) or modify your scripts to call the variables from the $GET and $POST arrays accordingly... Your call, but I reccomend the latter of the 2 options.

cricher

yea i find $GET and $POST much easier

jeffafd

Thanks defender and cricher -

I'm not sure how to code it but I will see what I can do.

I don't like to ask anyone to do my work but I will post the script again if someone can help me get it right, but in the mean time I will get out my book and give it a try.

<?php 
if ($submit) { 

//Database Connection 
   include "db.inc.php"; 

  $sql = "INSERT INTO jokes (title,content,category) VALUES ('$title','$content','$category')"; 

  $result = mysql_query($sql); 

echo "Thank you! Information entered.\n  <a href='http://www.blondesandrednecks.com/admin'>Continue</a>"; 

} else{ 

  // display form 

  ?> 

   <img src="http://www.blondesandrednecks.com//barlogo.jpg" align="center"> 
    <br> 
    <table border="0" width="100%"> 
    <tr> 
    <td width="25%" align="left"><a href="index.php">Return to Administration</a></td> 
    <td width="75%" align="left"><h2><u>Enter New Joke</u></h2></td> 
    </tr></table> 
<hr> 

  <center><table width="90%" border="0"> 
  <tr><td valign="top"> 

  <form method="post" action="<?php echo $PHP_SELF?>"> 

  Title:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<textarea name="title" rows="1" cols="70"></textarea><br> 

  Content:&nbsp;&nbsp;&nbsp;&nbsp;<textarea name="content" rows="14" cols="70"></textarea><br> 

  Category: <?php include_once("category.php"); ?> 

  <br> 

  <br> 

  <input type="Submit" name="submit" value="Enter information"> 

  </form> 
</td> 
<td valign="top"> 


</td></tr> 
</table></center> 
  <?php 


} // end if 


?>

Thanks - Jeff

jeffafd

Thanks all - I read through another post and was able to put together a form page and then a processing page and it works great.

Thanks for the hard work.