CODEWITHSUNDEEP
phpjquerymysql
karthik
karthik

Reputation: 110

jquery window location not work inside php echo?

jquery window location is not work inside the php echo statement, is there any wrong in my code?

this is my code:

<?php
include "connection/db_connection.php";
$error=''; 
if(isset($_POST['submit']))

{ 
$sno=$_POST['sno'];
$name=$_POST['name'];
$country=$_POST['s2'];
$username=$_POST['username'];
$email=$_POST['email'];
$password=$_POST['pwfield'];
$address=$_POST['address'];
$city=$_POST['city'];
$state=$_POST['state']; 

$sql2="select email from login_warehouse WHERE email='".$email."' AND sno!='".$sno."'";
$result2=mysql_query($sql2);
if(mysql_fetch_array($result2)>= 1) 
{

    $error= "Entered E-Mail ID Already in Exists!<br/>";
}
else
{
    $sql=mysql_query("update `login_warehouse` set name='".$name."', username='".$username."', password='".$password."', email='".$email."',address='".$address."',city='".$city."',state='".$state."', country='".$country."' where sno='".$sno."'");
    if($sql)
    {
        echo '<script>
        $(window).load(function () {
        window.setTimeout(function () {
        window.location.href = "edit_userprofile.php";
        }, 900)
        }); 
        </script>';
       $error='Admin details updated successfully!';            
  }
else
{

$error="Customer Already Exists";
}       
}
}
?>

what i wrote wrong in echo statement? or any other way is there to reload the page if the condition is true.

Upvotes: 0

Views: 1071

Answers (5)

karthik
karthik

Reputation: 110

<script type="text/javascript" src="https://code.jquery.com/jquery-2.1.1.min.js"></script>
<?php
include "connection/db_connection.php";
$error=''; 
if(isset($_POST['submit']))

{ 
$sno=$_POST['sno'];
$name=$_POST['name'];
$country=$_POST['s2'];
$username=$_POST['username'];
$email=$_POST['email'];
$password=$_POST['pwfield'];
$address=$_POST['address'];
$city=$_POST['city'];
$state=$_POST['state']; 

$sql2="select email from login_warehouse WHERE email='".$email."' AND     sno!='".$sno."'";
$result2=mysql_query($sql2);
if(mysql_fetch_array($result2)>= 1) 
{

$error= "Entered E-Mail ID Already in Exists!<br/>";
}
else
{
$sql=mysql_query("update `login_warehouse` set name='".$name."', username='".$username."', password='".$password."', email='".$email."',address='".$address."',city='".$city."',state='".$state."', country='".$country."' where sno='".$sno."'");
if($sql)
{
    echo '<script>
    $(window).load(function () {
    window.setTimeout(function () {
    window.location.href = "edit_userprofile.php";
    }, 900)
    }); 
    </script>';
   $error='Admin details updated successfully!';            
  }
else
{

$error="Customer Already Exists";
}       
}
}
?>

Upvotes: 0

varad mayee
varad mayee

Reputation: 619

You can use PHP header() to redirect to page you want like below:

if($sql)
{
    header("location:edit_userprofile.php");
}

Upvotes: 0

Pratik Joshi
Pratik Joshi

Reputation: 11693

If you really want to use jQuery/javascript , make sure you include jQuery library before Any jQuery code . If your posted code is the Starting code Before HTML , make sure you include js library first.

I would say if you use jquery to redirect , you will need DOM to be loaded (it will take a few seconds), window to be loaded , if you use php header() you will get redirected Instantly.

Upvotes: 0

Domain
Domain

Reputation: 11808

Since you are using jQuery code, you must include the jQuery library file before the jQuery code executes.

Upvotes: 0

Hearaman
Hearaman

Reputation: 8726

There is no error in your Javascript. Check where your query is executing successfully.

Why don't you use PHP's header() to redirect the page.

if($sql)
{
   header("location:edit_userprofile.php");

Upvotes: 1

Related Questions