Help me please.

bohra_sankalp

Insert query is not firing.

<?php
 // session_start();
  include("config.php");
  //if(isset($_SESSION["code"])){
  $_SESSION["code"] = rand(1000, 9999);
  //}

  if($_REQUEST["Submit"]!="")// on clicking of submit button
{	
	$err="";	
	if($_REQUEST["title"]=="")
		$err= ". Title field can't be left Empty.<br>"; 
	if($_REQUEST["roman"]||$_REQUEST["hindi"]=="")
		$err = ". Either of field is necessary.<br>";
	if($_REQUEST["poet"]=="")
		$err= ". poetfield can't be left Empty.<br>"; 	
if($err=="")
	{	
	$title=$_REQUEST["title"];
	$roman=$_REQUEST["roman"];
	$hindi=$_REQUEST["hindi"];
	$poet=$_REQUEST["poet"];
	$category=$_REQUEST["category"];

$sql = "INSERT into tbl_songlist_info(song_title,lyrics_roman,lyrics_hindi,poet_name,song_type) values('$title','$roman','$hindi','$poet','$category') ";
$result=mysql_query($sql);
	header("Location: thanks.php");


}
}	

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>

</head>
<body>
<form action="<?=$_SERVER['PHP_SELF'];?> " method="post" id="ghazal">

  <table width="461" border="0" align="center" cellpadding="1" cellspacing="2">
    <tr>
      <td width="86">Title :</td>
      <td><input name="title" type="text" id="title" size="57" onkeyup="valid(this)" onblur="valid(this)">
        <?=$err;?></tr>
    <tr> <td width="86">search :</td>
	<td><input name"search" type="text" id="title" alt="Search Criteria" onkeyup="searchSuggest();" autocomplete="off"/>
        <div id="layer1"></div></td>
    </tr>
    <tr>
      <td valign="top">Roman :</td>
      <td><textarea name="roman" id="roman" cols="55" rows="5" onkeyup="valid(this)" onblur="valid(this)"></textarea><?=$err;?></td>
    </tr>
    <tr>
      <td valign="top">Hindi :</td>
      <td><textarea name="hindi" id="hindi" cols="55" rows="5"></textarea></td>
    </tr>
    <tr>
      <td>Poet :</td>
      <td width="365"><input name="poet" type="text" id="poet" size="57"  onchange="capitalizeMe(this)"/><?=$err;?></td>
    </tr>
    <tr>
      <td>Category:</td>
      <td><select name="category" id="category">
          <option value="Ghazal or Nazm">Ghazal or Nazm</option>
          <option value="Other">Other</option>
        </select></td>
    </tr>
    <tr>
      <td><div align="left">Code:</div></td>
      <td><input name="code" type="text" id="code" size="4" maxlength="4" />

    <iframe src="captcha.php" width="75" height="25" scrolling="No" frameborder="0"></iframe></td>
</tr>
<tr>
  <td><div align="right"></div></td>
  <td><input type="submit" name="submit" id="submit" value="Submit" />
    <input type="submit" name="reset" id="reset" value="Clear" /></td>
</tr>
  </table>
</form>
</body>
</html>

bradgrafelman

Is [man]mysql_query/man returning FALSE and, if so, what is the error string returned by the MySQL server? Did you check the contents of the variables used in the if() statements to verify that they are as expected?

bohra_sankalp

As I am new to PHP, let me know how to check values of variables. As everything is depending on err variable. I haev already printed value of it.

Secondly same page is recalling without any error msg. Even Err variable value is also not printing.

vividona

Always use die(mysql_error()) to know what is going on

you can modify your code to be like this:

$result = mysql_query("INSERT into tbl_songlist_info(`song_title`, `lyrics_roman`, `lyrics_hindi`, `poet_name`, `song_type`) values('$title','$roman','$hindi','$poet','$category')") or die(mysql_error());