I've got a problem with data I get from my query. Doesnt matter how many records match to the SELECT I use, it always return me 0 value.
<html>
<body>
<link rel="stylesheet" href="mystyle.css">
<meta charset="utf-8">
<head>
<title>Lottery</title>
</head>
<?php
if(isset($_POST['submit'])){
$value = $_POST['Value'];
echo "Chosen value : " .$value;
}
?>
<div class="results">
<p>Counter: <? echo "".$value ?></p>
<p>Place: <? echo "".$value ?>: </p>
<p>Best match<? echo "".$value ?> :</p>
</div>
<?
$servername = "localhost";
$username = "lottery_root";
$password = "xyz";
$database = "lottery";
$conn = mysqli_connect($servername, $username, $password, $database) or die(mysqli_error($conn));
$result = mysqli_query($conn, "Select count(*) from lottery where first='$_POST[value]' or second='$_POST[value]'; ");
if (!$result) echo mysqli_error($conn);
$row = mysqli_fetch_row($result);
print_r($row);
?>
</body>
</html>
This is what I get each time " Array ( [0] => 0 ) " If I use different SELECT, for example SELECT * FROM lottery; it prints one column.
$_POST['Value'] is different than $_POST['value']
Its case sensitive, you have to use exact name of input field, as you have it named in the form.
I would say you haven't escaped your characters properly. The following line should be changed:
$result = mysqli_query($conn, "Select count(*) from lottery where first='$_POST[value]' or second='$_POST[value]'; ");
It should be:
$result = mysqli_query($conn, "Select count(*) from lottery where first='".$_POST['value']."' or second='$_POST[value]'; ");
Escaping is done by ending the quotes, either double or single and putting a dot for concatenation in the string. To go through with the statement again a dot is needed for concatenation and opening the quotes again.
In the first statement you actually query with the text "$_POST[value]" in the second statement you retrieve the value of the variable "$_POST['value']".
Also indeed watch out for case sensitivity in your POST. You once use "Value" and the other time "value", one of both is not correct.
Use a simple debug approach - Just try to print your query and see if you are getting correct values for $_POST[value] :
echo "Select count(*) from lottery where first='$_POST[value]' or second='$_POST[value]'; ";