how to pass data from one html page to second in php?

Question

I have created a page for updation of record. I want to pass the id of student from one page to another. I am trying to send it through window.location but it is not working. In ajax I tried to navigate to other page but didn't succeed in that too. How can i pass the data and receive on other page without showing in query string? ajax code is

var id = $(this).data('username');
            $.ajax({


        var id = $(this).data('username');
        $.ajax({type: "POST",
        cache: false,
        data: id,
        url: "Update.php",
        success: function(dto)
        {
            //but I do not require this return call I just
           // want to pass the data to update.php
        }
    });

    //this is the code where the button is being clicked
    <table class="table table-condensed" >

        <thead style="background-color:#665851" align="center">
        `<tr>
            <td style="color:white">Roll No</td>
            <td style="color:white">Name</td>
            <td style="color:white">Department</td>
            <td style="color:white">Click To Update</td>
        </tr>

        </thead>
        <tbody style="background-color:whitesmoke;  border:initial" id="tblBody" align="center">

<?php


                $database="firstdatabase"; //database name
     $con = mysqli_connect("localhost","root" ,"");//for wamp 3rd field is balnk
     if (!$con)
     {     die('Could not connect: ' . mysql_error());
     }

     mysqli_select_db($con,$database );
    $state = "SELECT rollno ,name, dept FROM student ;";

     $result = mysqli_query($con,$state);   
      $output = 1;
      $outputDisplay = "";
      $noRows = mysqli_affected_rows($result);
     if($result)
    {

        $num = mysqli_affected_rows($con);
                //$row = mysqli_fetch_array($result,MYSQLI_NUM);

        while ($row = mysqli_fetch_array($result)) 
        {

        $r = $row['rollno'];
        $n = $row['name'];
        $d = $row['dept'];
        $outputDisplay .= "<tr><td>".$r."</td><td>".$n."</td><td>".$d."</td><td align='right'>
        <button type='button' name='theButton' value='Detail' class='btn' id='theButton' data-username='$r'> <img src='edit.jpg'/></button>
        </td>
        </tr>";
        }
    }
    else
    {
        $outputDisplay .= "<br /><font color =red> MYSql Error No: ".mysqli_errno();
        $outputDisplay .= "<br /> My SQl Error: ".mysqli_error();


    }



    ?>
    <?php 
     print $outputDisplay;
    ?>
        </tbody>
    </table>

Do you want the user to navigate to a new page? Ajax is used to communicate with the server when you don't want to change pages. — BeetleJuice, Jul 13 '16 at 06:23
Why are not using forms , if you need to send only id to other page and also change page to php then use form — Mandeep Singh, Jul 13 '16 at 06:23
I want to get the id on btn click send it to server get the result and show it on another page #BeetleJuice — Nabeel_Afzal, Jul 13 '16 at 06:31
See http://stackoverflow.com/questions/36146595/can-we-refer-to-javascript-variables-across-webpages-in-a-browser-session — guest271314, Jul 13 '16 at 06:40

guest271314 · Accepted Answer · 2016-07-13T06:56:27.957

1

If both pages are at same domain you can use localStorage, storage event to pass data between html documents

At second page

window.addEventListener("storage", function(e) {
  // do stuff at `storage` event
  var id = localStorage.getItem("id");
});

at first page

// do stuff, set `localStorage.id`
localStorage.setItem("id", "abc");

edited Jul 13 '16 at 06:56

answered Jul 13 '16 at 06:49

guest271314

1
15
104
177

score 0 · Answer 2 · answered Jul 13 '16 at 06:10

0

When you use window.location then your page go to another page. ajax work on active page. You can not use.

answered Jul 13 '16 at 06:10

Suman

401
5
15

This should be a comment. – Alok Patel Jul 13 '16 at 06:12

score 0 · Answer 3 · answered Jul 13 '16 at 06:24

0

Generally you can use sessions for this $_SESSION variable to store it into the session, or you can pass that value via get parameter. And afterwards get that parameter with $_GET

Or $_POST parameter if you want to submit form.

answered Jul 13 '16 at 06:24

Marko Krstic

1,417
1
11
13

score 0 · Answer 4 · answered Jul 13 '16 at 06:28

you can try using cookies

Set the cookie
    <?php
    setcookie("name","value",time()+$int);
    /*name is your cookie's name
    value is cookie's value
    $int is time of cookie expires*/
    ?> 
Get the coockie

    <?php
    echo $_COOKIE["your cookie name"];
    ?>

score 0 · Answer 5 · answered Jul 13 '16 at 06:32

Populate a <form method="post" [...]> in the first page with the information needed; you can change their aspect with CSS as desired.

When the <form> is send you only need a PHP script/page that uses $_POST to fill the new page.

Easier than AJAX if you try to navigate from the first page to the second.

score 0 · Answer 6 · answered Jul 13 '16 at 06:46

If you already have a form and wanna post that to an update script, you could just add the student id as an hidden form element example:

<input type="hidden" name="student_id" value="<?php echo $student_id; ?>">

Else if you want to redirect from another page to the update page, with a student id, the best way will probably be a $_GET variable. So the URL would look something like this: http://domain.com/update.php?student_id=1

And then your update.php will include a simple check like this.

if(!empty($_GET['student_id'])) {
    $student_id = $_GET['student_id'];
    // Ready to update
} else {
    // Throw 404 error, or redirect to an create page
}

how to pass data from one html page to second in php?

6 Answers6

Linked