General |  Social Media |  Miscellaneous
Login
srcraft blog logo
  • Business
  • News
  • Shopping
  • Travel
  • Disease
  • Pets
  • Life
  • Health
  • Technology
  • Category
  • Contact Us
Latest Blog : 
☛ Upbringing: Don't cry or regret later ☛ True Story of Beggar: Punishment for the deeds done by us ☛ India: The Story of a Joint Family ☛ AI Driven Analytics | Life Sciences Data Analytics | WhizAI ☛ The Story of Gurukul: Test of intelligence ☛ The Problem Solving Skills ☛ Eternal law that never changes ☛ After all, why does Mahadev apply ashes on the body? ☛ Kitchen Worktops Buy now | Grey Worktops on sale ☛ Black Kitchen Worktops on Sale in UK 
Home > Innovation & Technology > PHP

How to get mysql record without refresh page in php


How to retrieve data from a database without reloading the page. We can use Ajax for retrieving data from a database without page reload. The data will be retrieved on javascript event. We will code in three part for getting records from a database without page reload.

First part:

We will code in <head> </head> section for calling function and sending data to PHP file by AJAX.

 

In HEAD section:

<!--get records without refresh page START-->

<!—Call JS file from googleapis-->

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script>

        <script type="text/javascript">

            function fetchRecords(searchItem, srvalue){

                $.ajax({

                    url: 'check-price.php?searchItem='+searchItem, //call storeemdata.php to store form data

                    success: function(html) {

                        var ajaxShow = document.getElementById(srvalue);

                        ajaxShow.innerHTML = html;

                    }

                });

            }

</script>

<!--get records without refresh page END-->

 

Second part:

We will send search keyword by input tag in html <form> </form> by POST method. Look below and we will display output by id like <div id="displayrecord"></div>

 

In BODY section:

<form method="post">

    Check item price:

        <input type="text" name="searchItem" id="searchItem" onkeyup="fetchRecords(this.value, 'displayrecord')">

</form>

<div id="displayrecord"></div>

 

Third part:

We will code in PHP for getting records by searchable keyword. For this, we will connect database, after that we will get records by below mention code.

 

In PHP code:

<?php

if($_SERVER['SERVER_NAME'] == 'localhost')

{

$connection = mysqli_connect('localhost','root','','db_name') or die('Error connecting to MySQL server.');

}

else

{

$connection = mysqli_connect('localhost','user_name','password','db_name') or die('Error connecting to MySQL server.');

}

$searchItem = $_GET['searchItem'];

 

if (isset($searchItem)) {

$query = "SELECT * FROM table_name WHERE columnone = '$searchItem' OR columntow = '$searchItem' GROUP BY columnone ";

           

    $result = mysqli_query($connection, $query);

    echo '<table border="1px solid black;" width="100%">';

            echo '<tr>';

            echo '<th width="50%">Item Name</th>';

            echo '<th width="20%">SKU Code</th>';

            echo '<th width="10%">MRP</th>';

            echo '<th width="10%">Dicount Price</th>';

            echo '<th width="10%">Discount</th>';

            echo '</tr>';

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

                        $discount = (($row->price-$row-> special_price)/$row-> price)*100;

        echo '<tr>'

            .'<td width="50%">'.$row->itemname.'</td>'

                                    .'<td width="20%" align="center">'.$row->sku.'</td>'

                                    .'<td width="10%" align="center">'.$row->price.'</td>'

            .'<td width="10%" align="center"><font color="red"><b>'.$row->special_price.'</b></font></td>'

                                    .'<td width="10%" align="center">'.round($discount).'%</td>'

            .'</tr>';

    }

    echo '</table>';

}

mysqli_close($connection); // Connection Closed

?>   

Written By: Charles Miller Published in PHP


Search

Publish your passions on srcraftblog.com

Latest Post

☛ Upbringing: Don't cry or regret later

☛ True Story of Beggar: Punishment for the deeds done by us

☛ India: The Story of a Joint Family

☛ AI Driven Analytics | Life Sciences Data Analytics | WhizAI

☛ The Story of Gurukul: Test of intelligence

☛ The Problem Solving Skills

☛ Eternal law that never changes

☛ After all, why does Mahadev apply ashes on the body?

☛ How to get an e-pass for curfew in Delhi, know the complete process in 6 easy steps

☛ 10 TIPS TO QUICKLY CLEAN YOUR JEWELLERY


We are accepting well-written informative Guest Posts on srcraftblog.com

Innovation & Technology

Artificial Intelligent blogs
Cryptocurrency blogs
Digital India blogs
Data science blogs
Neuroscience blogs
Programming blogs

Physical science

Physics blogs
Chemistry blogs
Earth science blogs
Geology blogs
Oceanography blogs
Meteorology blogs

Industry

Business blogs
Economy blogs
Freelancing blogs
Leadership blogs
Productivity blogs
Work blogs

Society

Basic income blogs
Education blogs
Environment blogs
Media blogs
Philosophy blogs
Women blogs
About us |  Write for us |  Terms and conditions |  Contact us

© 2022 SRCRAFT INIDA