$_GET in query mysql in condicion where

[bertrc]

I have two files index.php and cocoa_type_chocolate.php

I have 1 links is dark chocolate.

I want one query when I press one link 

index.php

<a href='cocoa_type_chocolate.php?type_chocolate=dark'>Dark</a>

cocoa_type_chocolate.php

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); $mysqli = mysqli_connect("localhost", "root", "*****", "cocoa"); $query = "SELECT chocolate.id_chocolate,chocolate.name_chocolate,type_chocolate.id_type_chocolate, type_chocolate.type_chocolate ,type_chocolate.id_chocolate FROM chocolate INNER JOIN type_chocolate ON chocolate.id_chocolate =type_chocolate.id_type_chocolate WHERE type_chocolate='dark'"; $result = mysqli_query($mysqli, $query); /* numeric array */ while ($row = mysqli_fetch_array($result, MYSQLI_BOTH)) { printf("%s %s %s %s %s\n", $row["id_chocolate"], $row["name_chocolate"], $row["id_type_chocolate"],$row["type_chocolate"],$row["id_chocolate"]);?> <br> <?php } ?>

 

Edited November 20, 2022 by bertrc

[Barand]

Please stop posting your code on a single line. It's ****ing annoying.

[mac_gyver]

the new-line/end-of-line setting in your programming editor is set to a non-standard setting. changing it to any of the other choices would be an improvement and allow the forum software to display your code properly.

[bertrc]

 have two files index.php and cocoa_type_chocolate.php

I have 1 links is dark chocolate.

I want one query when I press one link 

index.php

<a href='cocoa_type_chocolate.php?type_chocolate=dark'>Dark</a>

cocoa_type_chocolate.php

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

$mysqli = mysqli_connect("localhost", "root", "*****", "cocoa");

$query = "SELECT chocolate.id_chocolate,chocolate.name_chocolate,type_chocolate.id_type_chocolate, type_chocolate.type_chocolate ,type_chocolate.id_chocolate

FROM chocolate INNER JOIN type_chocolate ON chocolate.id_chocolate =type_chocolate.id_type_chocolate

WHERE type_chocolate='dark'";

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

/* numeric array */

while ($row = mysqli_fetch_array($result, MYSQLI_BOTH))

{ printf("%s %s %s %s %s\n", $row["id_chocolate"], $row["name_chocolate"], $row["id_type_chocolate"],$row["type_chocolate"],$row["id_chocolate"]);?> <br> <?php } ?>

 

Edited 13 hours ago by bertrc

[bertrc]

 I have two files index.php and cocoa_type_chocolate.php.

I have 1 links is dark chocolate.

I want one query when I press one link. 

I want to change  the condition where, to change between 3 chocolates milk, dark, and white.

in the condicion where I should use get.

but I have problem with the url and where condicion.

index.php

<a href='cocoa_type_chocolate.php?type_chocolate=dark'>Dark</a>

cocoa_type_chocolate.php

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

$mysqli = mysqli_connect("localhost", "root", "*****", "cocoa");

$query = "SELECT chocolate.id_chocolate,chocolate.name_chocolate,type_chocolate.id_type_chocolate, type_chocolate.type_chocolate ,type_chocolate.id_chocolate

FROM chocolate

INNER JOIN

type_chocolate

ON chocolate.id_chocolate =type_chocolate.id_type_chocolate

WHERE type_chocolate='dark'";

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

/* numeric array */

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

printf("%s %s %s %s %s\n", $row["id_chocolate"], $row["name_chocolate"], $row["id_type_chocolate"],$row["type_chocolate"],$row["id_chocolate"]);

?> <br> <?php } ?>

 

[bertrc]

It is working

thank you

index.php

<a href='cocoa_type_chocolate.php?type_chocolate=dark'>Dark</a>

<a href='cocoa_type_chocolate.php?type_chocolate=milk'>Milk</a>

<a href='cocoa_type_chocolate.php?type_chocolate=white'>White</a>

cocoa_type_chocolate.php

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

$mysqli = mysqli_connect("localhost", "root", "*****", "cocoa");

$query = "SELECT chocolate.id_chocolate,chocolate.name_chocolate,type_chocolate.id_type_chocolate, type_chocolate.type_chocolate ,type_chocolate.id_chocolate

FROM chocolate

INNER JOIN

type_chocolate

ON chocolate.id_chocolate =type_chocolate.id_type_chocolate

WHERE type_chocolate='$_GET[type_chocolate]'";

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

/* numeric array */

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

printf("%s %s %s %s %s\n", $row["id_chocolate"], $row["name_chocolate"], $row["id_type_chocolate"],$row["type_chocolate"],$row["id_chocolate"]);

?>

<br>

<?php } ?>

 

Edited November 21, 2022 by bertrc