Jump to content

problem with script:unable to find error

cool_techie

By cool_techie
in PHP Coding Help

 Share

Recommended Posts

cool_techie Member

cool_techie

Posted
Posted

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>

<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>

</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>

 

 

Link to comment
Share on other sites
cool_techie Member

cool_techie

Posted
  • Author
Posted

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";
  ?>

Link to comment
Share on other sites
BlueSkyIS Newbie

BlueSkyIS

Posted
Posted

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.";

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.