problem with script:unable to find error

cool_techie · February 17, 2011

I have a php script wihich updates data in mysql db named 'trial' and table named 'tab'

I am using jquery and ajax to update the db. but the script is not working.

edit-profile.php

<code>

<?php

session_start();

$img=$_SESSION['img'];

?>

<html>

<head>

</script>

$(function(){

$('#submit').click(function(){

$('#load').append('<img src="ajax-loader.gif" id="loading" alt="image" />');

var about= $('#about').val();

var contact= $('#contact').val();

var present= $('#present').val();

var inter= $('#inter').val();

var high= $('#high').val();

var books= $('#books').val();

var sports= $('#sports').val();

var pastime= $('#pastime').val();

var interest= $('#interest').val();

console.log (about);

$.ajax({

url:'update-profile.php',

type:'POST',

data: 'contact=' + contact + '&about=' + about + '&present=' + present + '&inter=' + inter + '&high=' + high + '&books=' + books + '&sports=' + sports + '&pastime=' + pastime + '&interest=' +interest,

success: function(result){

$('#response').remove();

$('#load').append('<p id="response">' + result + '</p>');

$('#loading').fadeOut(500,function(){

$(this).remove();

});

}

});

return false;

});

</script>

</head>

<body>

<p><a href="#">cinemas</a></p>

</div>

<?php

{

if(isset($_SESSION['name'])){

echo "<p id=\"welcome\">";

echo "Welcome ".$_SESSION['name'];

echo " ";

echo "<a href=\"logout.php\">";

echo "Logout";

echo "</a>";

echo "</p>";

}

}?>

</div>

<ul>

<?php

{

if(isset($_SESSION['name'])){

echo "<a href=\"index1.php\">Home</a></li>";

}

else{

echo "<a href=\"index.html\">Home</a></li>";}}

?>

<li><a href="shows.php">Shows</a></li>

<li><a href="umovies.php">Upcoming Movies</a></li>

<li><a href="#">Reviews</a></li>

<li><a href="#">Book Tickets</a></li>

<li><a href="contact.html">Contact</a></li>

</ul>

</div>

<h2>My Profile <a href="edit-profile.php">Edit Profile</h2></a>

</div>

<p style="color:white"><a href="upload.php">Change photo</a><br/>

<img src=<?php echo $_SESSION['img'] ?> width='120px' height='140px' class='left' alt='image' />

<strong>Contact:-</strong><input type="text" name="contact" id="contact" value="<?php echo $_SESSION['contact']; ?>" /><br/>

About:-<textarea name="about" id="about" rows="5" cols="38" ><?php echo $_SESSION['about']; ?> </textarea><br/>

</p>

</div>

<p style="color:white">Education:<br/>

<strong>Present:-</strong> <input type="text" id="present" name="present" size="25" value="<?php echo $_SESSION['present']; ?>" /> <br/>

<strong>Inter:- </strong><input type="text" id="inter" name="inter" size="25"value="<?php echo $_SESSION['inter']; ?>" /><br/>

<strong>High School:-</strong><input type="text" id="high" name="high" size="25" value="<?php echo $_SESSION['high']; ?>" /><br/>

<strong>Favourite Books:-</strong><input type="text" id="books" name="books" size="30" value="<?php echo $_SESSION['books']; ?>" /><br/>

<strong>Favourite Sport:-</strong><input type="text" id="sports" name="sports" size="30" value="<?php echo $_SESSION['sports']; ?>" /><br/>

<strong>Pastimes:-</strong><input type="text" name="pastime" id="pastime" size="25" value="<?php echo $_SESSION['pastime']; ?>" /><br/>

<strong>Interests:-</strong><input type="text" name="interest" id="interest" size="25" value="<?php echo $_SESSION['interests']; ?>" /><br/><br/>

</form>

</div>

•

Design by <a href="#/">Pulkit</a>

</p>

<a href="http://validator.w3.org/check/referer" class="xhtml" title="This page validates as XHTML">Valid <abbr title="eXtensible HyperText Markup Language">XHTML</abbr></a>

•

<a href="http://jigsaw.w3.org/css-validator/check/referer" class="css" title="This page validates as CSS">Valid <abbr title="Cascading Style Sheets">CSS</abbr></a>

</p>

</div>

</body>

</html>

</code>

update-profile.php

<code>

<?php

session_start();

$connection=mysql_connect("localhost","root","");

mysql_select_db("TRIAL",$connection);

if(mysql_query("UPDATE tab SET about='$_POST[about]',contact='$_POST[contact]',present='$_POST[present]',inter='$_POST[inter]',high='$_POST[high]',books='$_POST[books]',sports='$_POST[sports]',pastime='$_POST[pastime]',interests='$_POST[interest]' WHERE name='$_SESSION[name]'")){

echo "Successfully uploaded the data.<a href='index.php'>Click here</a> to return back.";

}

else

echo "Unable to upload";

?>

</code>

Pikachu2000 · February 17, 2011

When posting code, please enclose it within the forum's

 . . .

BBCode tags.

kenrbnsn · February 17, 2011

Please tell us why you think the script is not working? What is it supposed to do? What is it doing? Are you getting any errors? We're not mind readers.

Ken

cool_techie · February 17, 2011

It had to update the user information in the database but it shows unable to upload when i remove the jquery there but shows no message when i use jquery.

cool_techie · February 17, 2011

I have a php script wihich updates data in mysql db named 'trial' and table named 'tab'

I am using jquery and ajax to update the db. but the script is not working.

edit-profile.php


<?php
session_start();
$img=$_SESSION['img'];
?>
<html>
<head>
<title>Tgmc</title>


<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta name="keywords" content="" />
<meta name="description" content="" />
<link href="default.css" rel="stylesheet" type="text/css" media="screen" />
<script type="text/javascript" src="jquery-1.5.min.js">
</script>
<script type="text/javascript">
  $(function(){
      $('#submit').click(function(){
     $('#load').append('<img src="ajax-loader.gif" id="loading" alt="image" />');
     var about= $('#about').val();
	 var contact= $('#contact').val();
	 var present= $('#present').val();
	 var inter= $('#inter').val();
	 var high= $('#high').val();
	 var books= $('#books').val();
	 var sports= $('#sports').val();
	 var pastime= $('#pastime').val();
	 var interest= $('#interest').val();
	 console.log (about);

  $.ajax({
        url:'update-profile.php',
		type:'POST',
		data: 'contact=' + contact + '&about=' + about + '&present=' + present + '&inter=' + inter + '&high=' + high + '&books=' + books + '&sports=' + sports + '&pastime=' + pastime + '&interest=' +interest,
		success: function(result){
		    $('#response').remove();
		    $('#load').append('<p id="response">' + result + '</p>');
		    $('#loading').fadeOut(500,function(){
		    $(this).remove();
		      });
	        }
    
	});
	return false;
  
  });
   
   });
  
</script>

</head>
<body>
<!-- start header -->
<div id="wrapper">
<div id="header">
<div id="logo">
	<h1><a href="#">ABC</a></h1>
	<p><a href="#">cinemas</a></p>
</div>
        
<?php
{
if(isset($_SESSION['name'])){
echo "<p id=\"welcome\">";
echo "Welcome ".$_SESSION['name'];
echo "                 ";
echo "<a href=\"logout.php\">";
echo "Logout";
echo "</a>";
echo "</p>";
}
}?>



</div>
</div>
<!-- end header -->
<!-- star menu -->
<div id="menu">
<ul>
	<li class="current_page_item">
	 <?php
           {
            if(isset($_SESSION['name'])){
		echo "<a href=\"index1.php\">Home</a></li>";
		}
		else{
		echo "<a href=\"index.html\">Home</a></li>";}}
		?>
	<li><a href="shows.php">Shows</a></li>
	<li><a href="umovies.php">Upcoming Movies</a></li>
	<li><a href="#">Reviews</a></li>
                <li><a href="#">Book Tickets</a></li>
	<li><a href="contact.html">Contact</a></li>
</ul>
</div>
<!-- end menu -->
<!-- start page -->
<div id="page">
<!-- start ads -->

<!-- end ads -->
<!-- start content -->
<div id="content">
	<div class="post">
		<div class="title">

			<h2>My Profile            <a href="edit-profile.php">Edit Profile</h2></a>
		</div>
		<div class="entry">
		<form action="update-profile.php" method="post">


			<p style="color:white"><a href="upload.php">Change photo</a><br/>

            <img src=<?php echo $_SESSION['img'] ?> width='120px' height='140px' class='left' alt='image' />
		 <strong>Contact:-</strong><input type="text" name="contact" id="contact" value="<?php echo $_SESSION['contact']; ?>" /><br/>
		 About:-<textarea  name="about" id="about" rows="5" cols="38" ><?php echo $_SESSION['about']; ?> </textarea><br/>
		</p>

		</div>


            <p style="color:white">Education:<br/>
               <strong>Present:-</strong>      <input type="text" id="present" name="present" size="25" value="<?php echo $_SESSION['present']; ?>" /> <br/>
               <strong>Inter:-          </strong><input type="text" id="inter" name="inter" size="25"value="<?php echo $_SESSION['inter']; ?>" /><br/>
                <strong>High School:-</strong><input type="text" id="high" name="high" size="25" value="<?php echo $_SESSION['high']; ?>" /><br/>
                <br><br>
                 <strong>Favourite Books:-</strong><input type="text" id="books" name="books" size="30" value="<?php echo $_SESSION['books']; ?>" /><br/>
                 <strong>Favourite Sport:-</strong><input type="text" id="sports" name="sports" size="30" value="<?php echo $_SESSION['sports']; ?>" /><br/>
                 <br/><br/>
                 <strong>Pastimes:-</strong><input type="text" name="pastime" id="pastime" size="25" value="<?php echo $_SESSION['pastime']; ?>" /><br/>
                 <strong>Interests:-</strong><input type="text" name="interest" id="interest" size="25" value="<?php echo $_SESSION['interests']; ?>" /><br/><br/>
			 <input type="submit" id="submit" value="Update" />
			 <div id="load></div>
			 </form>



	</div>


<!-- end page -->
<!-- start footer -->
<div id="footer">
<p class="legal">
	©2010ABC Cinemas. All Rights Reserved.
	  •  
	Design by <a href="#/">Pulkit</a>
	    
	 </p>
<p class="links">
	<a href="http://validator.w3.org/check/referer" class="xhtml" title="This page validates as XHTML">Valid <abbr title="eXtensible HyperText Markup Language">XHTML</abbr></a>
	 • 
	<a href="http://jigsaw.w3.org/css-validator/check/referer" class="css" title="This page validates as CSS">Valid <abbr title="Cascading Style Sheets">CSS</abbr></a>
</p>
</div>
</div>
<!-- end footer -->
</body>
</html>

update-profile.php


<?php
session_start();
$connection=mysql_connect("localhost","root","");
mysql_select_db("TRIAL",$connection);

if(mysql_query("UPDATE tab SET about='$_POST[about]',contact='$_POST[contact]',present='$_POST[present]',inter='$_POST[inter]',high='$_POST[high]',books='$_POST[books]',sports='$_POST[sports]',pastime='$_POST[pastime]',interests='$_POST[interest]' WHERE name='$_SESSION[name]'")){
  echo "Successfully uploaded the data.<a href='index.php'>Click here</a> to return back.";
  }
  else
  echo "Unable to upload";
  ?>

BlueSkyIS · February 17, 2011

your query is probably failing. you should check.

$sql = "UPDATE tab SET about='$_POST[about]',contact='$_POST[contact]',present='$_POST[present]',inter='$_POST[inter]',high='$_POST[high]',books='$_POST[books]',sports='$_POST[sports]',pastime='$_POST[pastime]',interests='$_POST[interest]' WHERE name='$_SESSION[name]'";

mysql_query($sql) or die(mysql_error() . " IN $sql");

echo "Successfully uploaded the data.<a href='index.php'>Click here</a> to return back.";

Sign In

problem with script:unable to find error

Recommended Posts

cool_techie

Link to comment

Share on other sites

Pikachu2000

Link to comment

Share on other sites

kenrbnsn

Link to comment

Share on other sites

cool_techie

Link to comment

Share on other sites

cool_techie

Link to comment

Share on other sites

BlueSkyIS

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information