Select Syntax from a Get variable

Question

I want to select a value from the database with variables I get from $_GET, but it doesn't show any results. Could any one help me find what is wrong with my code?

here is my first page how i get the value to GET:

<?php
            if($result->num_rows > 0) {
               while($row = $result->fetch_assoc()) {
        ?>
                 <tr>
                    <td><a href="file.php?subject=<?= $row['subject'] ?>"><?= $row['subject'] ?></a></td>
                    <td><?= $row['location'] ?></td>
                    <td><?= $row['geo'] ?></td>
                    <td><?= $row['date'] ?></td>
                    <td><?= $row['piority'] ?></td>
                 </tr>
        <?php
               }
            }
        ?>

and here is my second page that i want to get data from database with subject variable from first page:

<?php
$varPage = $_GET['subject'];
                $servername = "localhost";
                $username = "bayansh_user";
                $password = "u)nHf,Accmo)";
                $dbname = "bayansh_bmc";
                $conn = new mysqli($servername, $username, $password, $dbname);
                // Check connection
                if ($conn->connect_error) {
                     die("Connection failed: " . $conn->connect_error);
                } 
                $result = mysqli_query($conn,"SELECT `date` FROM `editor` WHERE subject = '.$varPage.'");

while($row = mysqli_fetch_array($result))

?>

and now i want to write the date here is my code:

<p style="font-family:B Zar; direction:rtl; font-size:165%;"> <?= $row['date'] ?> </p>

but it writes nothing. Is there anything wrong with my code?

Your query should be like this: `... WHERE subject = '".$varPage."'");` — Rajdeep Paul, Dec 04 '16 at 15:46

Poiz · Answer 1 · 2016-12-04T16:32:00.373

1

There seems to be an oversight on your part with regards to your SQL. You have an extra-dot, which likely was a Typo. Try addressing that part and your code would most likely work as you expected. Some Guys here have suggested working with Prepared Statement (which is quite necessary) in which case this Snippet would use PDO as opposed to MySQLi... although the principles are not so extremely different.

    <?php

            $varPage     = $_GET['subject'];
            $servername  = "localhost";
            $username    = "bayansh_user";
            $password    = "u)nHf,Accmo)";
            $dbname      = "bayansh_bmc";
            $dbh         = null;

            // USING PDO INSTEAD::
            $dsn         = 'mysql:host=' . $servername . ';dbname=' . $dbname;  
            try {
                $dbh     = new PDO($dsn, $username, $password);
                $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            } catch (PDOException $e) {
                throw new Exception($e->getMessage());
            }

            // USING PREPARED STATEMENT... NOTICE "=:SBJ"
            $sql         = "SELECT `date` FROM `editor` WHERE subject=:SBJ";
            // USING PREPARED STATEMENT CONTINUED: NOTICE "$dbh->prepare()"
            $stmt        = $dbh->prepare($sql);
            // PASSING VALUES: NOTICE "['SBJ'=>$varPage]"
            $stmt->execute( array('SBJ'=>$varPage) );
            $resultSet   = $stmt->fetchAll(PDO::FETCH_OBJ);

            // LOOP THROUGH THE RESULT-SET AND DO SOME THINGS WITH THE DATA...
            foreach($resultSet as $intKey=>$objData){
                var_dump($objData->date);  //<== DUMP SOME DATA TO THE STREAM
            }

edited Dec 04 '16 at 16:32

answered Dec 04 '16 at 16:10

Poiz

7,611
2
15
17

it gives an error: Fatal error: Uncaught exception 'Exception' with message 'SQLSTATE[42000] [1044] Access denied for user 'bayansh_user'@'localhost' to database 'dbname'' in /home2/bh/public_html/IS/file.php:15 Stack trace: #0 {main} thrown in /home2/bh/public_html/IS/file.php on line 15 – Farhad paikan Dec 04 '16 at 16:19
it gives an error: Fatal error: Uncaught exception 'Exception' with message 'SQLSTATE[42000] [1044] Access denied for user 'bayansh_user'@'localhost' to database 'dbname'' in /home2/bh/public_html/IS/file.php:15 Stack trace: #0 {main} thrown in /home2/bh/public_html/IS/file.php on line 15 – Farhad paikan Dec 04 '16 at 16:20
@Farhadpaikan Sorry.... The Dollar Symbol was lacking in the `$dbname` Variable.... Before, it read: `dbname` rather than `$dbname` .... You might re-check it one more time (*if you will*).... however, ***also make sure that the Username, Password and DB-Name are all Correct on your end...*** – Poiz Dec 04 '16 at 16:34
it works but it give null result, i mean it didnt write anything and one think i need to mention that subject column has arabic character value, does it has any effect???? – Farhad paikan Dec 04 '16 at 16:42
@Farhadpaikan You are not writing... *You are rather reading.* **SELECT** is a Read Operation.... Anyways, so long as you have the right Character Set, Language shouldn't be a Problem ;-) – Poiz Dec 04 '16 at 16:57
Sorry i thought it is like ADO.net , in SQL command if you want to read a arabic character from a textbox you need to add N at the start of Value like N'"+ textboxt.Text +"' without N it doesnt read the Arabic Character – Farhad paikan Dec 04 '16 at 17:06
Any way why i cant get the value from date where my subject is $varPage , it return a NULL value, i mean it doesnt write anything : / – Farhad paikan Dec 04 '16 at 17:07

score 0 · Answer 2 · answered Dec 04 '16 at 16:10

0

You should use the following code

$result = mysqli_query($conn,"SELECT `date` FROM `editor` WHERE subject = '".$varPage."'");

answered Dec 04 '16 at 16:10

Farrukh Afzaal Kurd

44
3

i tried but it return a NULL value, i mean it didnt write anything – Farhad paikan Dec 04 '16 at 17:25
Check for following errors (if available) in your code: – Farrukh Afzaal Kurd Dec 07 '16 at 11:00
1) write var_dump($_REQUEST) or var_dump($_GET) on your second page to check values of all variables that are being send to your second page via your first page. – Farrukh Afzaal Kurd Dec 07 '16 at 11:05
2) Check whether you have placed your code which is creating link on first page inside a form tag or not. Only those variables will be sent to your second page which are placed inside a form on your first page. – Farrukh Afzaal Kurd Dec 07 '16 at 11:07
yes echo the Value in second page and it pass to the value to second page corectly – Farhad paikan Dec 09 '16 at 17:31

Select Syntax from a Get variable

2 Answers2