AxoloteShop_backup/buscar-prod.php at main · danzosr/AxoloteShop_backup · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
<?php

	include ('database.php');

	$search = $_POST['search'];

	if (!empty($search)) {
		$query = "SELECT * FROM producto WHERE nombre LIKE '$search%'";
		$result = mysqli_query($connection, $query);
		if (!$result) {
			die('Query error'.mysqli_error($connection));
		}

		$json = array();
		while ($row = mysqli_fetch_array($result)) {
			$json[] = array(
				'id' => $row['id'],
				'nombre' => $row['nombre'],
				'foto' => $row['foto'],
				'descripcion' => $row['descripcion'],
				'precio' => $row['precio'],
				'inventario' => $row['inventario']
			);
		}
		$jsonstring = json_encode($json);
		echo $jsonstring;
	}else{
		$query = "SELECT * FROM producto";
		$result = mysqli_query($connection, $query);

		$json = array();
		while ($row = mysqli_fetch_array($result)) {
			$json[] = array(
				'id' => $row['id'],
				'nombre' => $row['nombre'],
				'foto' => $row['foto'],
				'descripcion' => $row['descripcion'],
				'precio' => $row['precio'],
				'inventario' => $row['inventario']
			);
		}
		$jsonstring = json_encode($json);
		echo $jsonstring;
	}


?>