MySQL Problems

cralyn

I have a small php script which allows for the upload of text articles into mysql.

I can enter the articles from within phpMYadmin, but when i use the form on my site it wont work. I can get it to work if i just use 2 or 3 words. As soon as theres a larger amout of tect it doesnt work. Can anyone help me?

Thanks

[deleted]

It helps if you explain a bit more than 'it doens't work'

Like what kind of errors do you get?

cralyn

Ok,

I'l try to give a bit more information:

When i enter the details thru the admin area I enter a title in the title field and the text in the text area. If i use a small phrase the text is saved into the database and i get the message "data entered". when using the same procedure on a longer text say 100 words, i get the same message but when i attempt to vie wthe data from the page setup to view it the article hasnt been saved and doesnt show up.
I go to phpmyadmin and have a look and the database hasnt been updated. I can enter the data directly into the database from phpmyadmin and it works perfectly.
When i use a small phrase everything works fine.

[deleted]

Are you sending the form data through a POST or a GET method? GET has a size limit of around 2000 characters.

cralyn

Hi,
Im Using POST to send the data

[deleted]

Strange. What if you print the submitted data before running the update query?

and what does mysql itself say about the query? does it fail? and if so, what is the error message that mysql_error() gives you?

cralyn

How do i print the data?

Im not getting any error messages at all

[deleted]

How do you print the data?

well, echo or print seems appropriate...

cralyn

can you be a little more specific. im a newbie to php & mysql.

Heres my code.

<?
require("config.php3");
include("connect.inc");
db_connect();
require("split.class.php");

$sellogin="select * from article_admin where article_login=1";
$resultlog=mysql_query($sellogin);

if(mysql_num_rows($resultlog)==0)
{
echo "<META HTTP-EQUIV='REFRESH' CONTENT=\"0; URL='index.htm'\">";
exit;
}

?>

<?
    if ($imageField_x!="")
	{
		$sqlfind="select * from article_main where article_title='$arttitle'";
		$resfind=mysql_query($sqlfind);
		if (mysql_num_rows($resfind)>0)
		{
			$failure=1;
		}
		else
		{
		$createdate=date("Y-m-d");

		$ins="insert into article_main (article_title,article_desc,creation_date) values ('$arttitle','$artdesc','$createdate')";
		mysql_query($ins);
		echo "<META HTTP-EQUIV='REFRESH' CONTENT=\"0; URL='viewarticle.php?added=1&title=$arttitle'\">";

exit;
}
}

?>

<html>
<head>
<title>Add Domain</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">

</style>
<LINK href="images/style.css"
rel=stylesheet type=text/css>

<SCRIPT language=javascript>
function check()
{
if(document.form1.arttitle.value=="")
{
alert("Please enter proper title.");

document.form1.arttitle.focus();
return false;
}

  if (document.form1.artdesc.value.length<2)
         {
          alert("Please enter proper description.");
          document.form1.artdesc.focus();
          return false;
          }

}

		  </script>

</head>

      <table width="75%" border="0" cellspacing="0" cellpadding="5" align="center">
        <tr bgcolor="#990000"> 
          <td class="body" height="35" bgcolor="#FFFFFF" valign="middle"> 
            <div align="center"><b></b> 
              <table width="100%" border="0" cellspacing="0" cellpadding="5" align="center">
                <tr bgcolor="#FFFFFF"> 
                  <td colspan=2 align=left><a href="javascript:history.back()"><font face=arial>back</font></a></td>
				  <td align=right><a href="services.php"><font face=arial>home</font></a></td>
                </tr>
                <tr bgcolor="#CCCCCC"> 
                  <td colspan=3 align=center><b><font color="#000099" size="-1" face="Arial, Helvetica, sans-serif">New Sermon</font></b></td>
                </tr>
                <?
			  if ($inserted=="1")
			  {
				  ?>
                <tr> 
                  <td colspan=3 align=center><font face=arial size=2 color=red><b>Domain 
                    Succesfully Added</b></font></td>
                </tr>
                <?
					  $inserted=0;
			  }
			  ?>
                <?
			  if ($failure=="1")
			  {
				  ?>
                <tr> 
                  <td colspan=3 align=center><font face=arial size=2 color=red><b>Title 
                    Already Exist</b></font></td>
                </tr>
                <?
					  $failure=0;
			  }
			  ?>

                <tr> 
                  <td class="body" width="49%">Sermon Title</td>
                  <td class="body" width="1%">:</td>
                  <td class="body" width="50%"> 
                    <input type="text" size=30 maxlength=40 name="arttitle" value="<?=$arttitle?>"  onChange="javascript:while(''+this.value.charAt(0)==' ')this.value=this.value.substring(1,this.value.length);">
                  </td>
                </tr>

				 <tr> 
                  <td class="body" width="49%">Description</td>
                  <td class="body" width="1%">:</td>
                  <td class="body" width="50%"> 
                   <textarea name=artdesc cols=30 rows=5 onChange="javascript:while(''+this.value.charAt(0)==' ')this.value=this.value.substring(1,this.value.length);" ></textarea>
                  </td>
                </tr>
                <?
				$now=date("M Y");
		    $nowyr=date("Y");
		    $nowmon=date("M");

			$currmonth=date("m");
		    $prevmon=date("m");
            $nowday=date("d");			
		    $prevyr=$nowyr-1;
		    $prevnow=$nowmon." ".$prevyr;
		    $prevdate=$prevyr."-".$prevmon."-".$nowday;			    $nowstart=$nowyr."-04-01";			
		    $prevstart=$prevyr."-04-01"; 
			?>

                <tr> 
                  <td class="body" width="49%">&nbsp;</td>
                  <td class="body" width="1%">&nbsp;</td>
                  <td class="body" width="50%">&nbsp;</td>
                </tr>
                <tr> 
                  <td class="body" colspan="3"> 
                    <div align="center"> 
                      <input type="image" border="0" name="imageField" src="images/submit-button.gif" width="89" height="20">
                    </div>
                  </td>
                </tr>
                <tr> 
                  <td class="body" width="49%">&nbsp;</td>
                  <td class="body" width="1%">&nbsp;</td>
                  <td class="body" width="50%">&nbsp;</td>
                </tr>
              </table>
              <b><font color="#000099"> </font></b></div>
          </td>
        </tr>
        <tr bgcolor="#990000"> 
          <td class="body" height="212" bgcolor="#FFFFFF" valign="middle"> 
            <div align="center"> </div>
          </td>
        </tr>
      </table>

    </form>
  </td>
</tr>

</center>
</table>
</body>
</html>

[deleted]

And what is the column type of thearticle_desc column in the database?

cralyn

the type is text

cralyn

i have also tried mediumtext, longtext, blob, mediumblob and longblob

[deleted]

Try changing the insert lines to from this

<?
$ins="insert into article_main (article_title,article_desc,creation_date) values ('$arttitle','$artdesc','$createdate')";
mysql_query($ins);
?>

to this:

<?
$ins="insert into article_main (article_title,article_desc,creation_date) values ('$arttitle','".addslashes($artdesc)."','$createdate')";
if (!mysql_query($ins))
{
echo 'Query failed:'.$ins.'<BR>'.mysql_error();
exit;
}
?>

that will add proper escape characters for any quotes that may be in the posted text, and it will print an error emssage when the insert query fails, to explain why it failed.