How to fix to get specific data in MySql

Question

I'm new to PHP. I try to build simple page with PHP and MySql, but failed to display the spesific data.

I try this: Get data from MySQL database by specific id in url to display data by "id_pemesanan" not "id" from the database.

But it's failed.

This is my code:

<?php
$id = $_GET['id_pemesanan'];
$mysqli = new mysqli("localhost", "root", "", "mad");
$query = "SELECT * FROM pesanan WHERE id_pemesanan ='". $id."'";
$result = $mysqli->query($query);
$row = $result->fetch_array(MYSQLI_BOTH);
{
echo "<p>$row[asal]</p>";
    }
?>

This is my database table structure:

CREATE TABLE `pesanan` (
  `id` int(11) NOT NULL,
  `id_pemesanan` int(11) NOT NULL,
  `pemesan` text NOT NULL,
  `asal` text NOT NULL,
  `lat` varchar(500) NOT NULL,
  `lng` varchar(500) NOT NULL,
  `tujuan` text NOT NULL,
  `lat_tujuan` varchar(500) NOT NULL,
  `long_tujuan` varchar(500) NOT NULL,
  `jarak` text NOT NULL
) ENGINE=MyISAM

I want display the spesific data using url like: http://localhost/mios/open/lengkap.php?=11772

The "11772" in the url is from "id_pemesanan"

I want the code to display the data. But, the error messages come.

Here the error massage:

Notice: Undefined index: id_pemesanan in 
C:\xampp\htdocs\mios\open\lengkap.php on line 2

You are missing to pass your get parameter on url . See i have answer on this — MD. Jubair Mizan, Dec 24 '18 at 09:24
Have a look at ["SQL Injection"](http://php.net/manual/en/security.database.sql-injection.php). — sticky bit, Dec 24 '18 at 09:24

score 2 · Answer 1 · answered Dec 24 '18 at 09:22

2

Your url must be like following..

http://localhost/mios/open/lengkap.php?id_pemesanan=11772

answered Dec 24 '18 at 09:22

Rakesh P

438
5
19

score 0 · Answer 2 · answered Dec 24 '18 at 09:23

0

You are missing to pass your get parameter on url

http://localhost/mios/open/lengkap.php?id_pemesanan=11772

answered Dec 24 '18 at 09:23

MD. Jubair Mizan

1,539
1
12
20

score 0 · Answer 3 · edited Jun 20 '20 at 09:12

Problem is your request URL is missing parameter id_pemesanan, should like this:

http://localhost/mios/open/lengkap.php?id_pemesanan=11772

See Query string - Wikipedia

Typical URL containing a query string is as follows:

http://example.com/over/there?name=ferret

When a server receives a request for such a page, it may run a program, passing the query string, which in this case is, name=ferret unchanged, to the program. The question mark is used as a separator, and is not part of the query string.

score 0 · Answer 4 · answered Dec 24 '18 at 09:24

0

You should be add query parameter in url, because that error is about index to GET not found query parameter with index id_pemesanan.

http://localhost/mios/open/lengkap.php?id_pemesanan=11772

answered Dec 24 '18 at 09:24

Mauricio Wanderley Martins

8,834
2
10
18

How to fix to get specific data in MySql

4 Answers4