Why php code is not working?

Question

I want to display a database table in my .php web page. I use the following code:

<?php
        include('../dbconnect.php');
        $det= SELECT * FROM user ;
        $result=mysqli_query($con,$det);
         mysqli_close($con);

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

            echo '<table style="width: 100%">
                <tr>';
                    echo "<td>".$row['name']."</td>";
                    $del=$row['uid'];
                    echo '<td><a href=functions/deleteuser.php?id=' .$del.'>Delete</a></td>
                </tr>
            </table>';

         }
    ?>

But, when I include this code, the whole web page appears as blank. Without this code, the page works fine. What is wrong with this code?

whats in your dbconnect.php? Can you provide the code in it?? — Mad Angle, Aug 04 '14 at 07:07
You're missing quotes around your query, and at the end of your second echo line. — Robby Cornelissen, Aug 04 '14 at 07:07
Enable error reporting or check your log files for the error. — h2ooooooo, Aug 04 '14 at 07:10
I don't need a logfile to see that the op has no idea how code is written. — Realitätsverlust, Aug 04 '14 at 07:11

score 5 · Accepted Answer · edited Apr 05 '22 at 11:44

5

It should be like this

$det = 'SELECT * FROM user';

edited Apr 05 '22 at 11:44

naitsirch

5,968
4
41
54

answered Aug 04 '14 at 07:07

CodeSlayer

1,295
1
12
34

1

@codeSlayer i have a doubt even if it is used in that way mysqli_close($con); is used before fetching the data whether it works – NaveenThally Aug 04 '14 at 07:18
i don't know why it is still works, but i saw same example in net that uses the same code. – CodeSlayer Aug 18 '14 at 08:22

score 4 · Answer 2 · answered Aug 04 '14 at 07:08

4

The query should be used in double/single quotes. Like this.

$det = 'SELECT * FROM user' ;

answered Aug 04 '14 at 07:08

Mad Angle

2,290
1
14
31

score 3 · Answer 3 · answered Aug 04 '14 at 07:08

3

query not quoted try this

$det= "SELECT * FROM `user`";

answered Aug 04 '14 at 07:08

Satish Sharma

9,475
6
27
51

score -4 · Answer 4 · edited Apr 03 '22 at 22:13

-4

mysqli_close($con); should be at the bottom after your while loop. Try doing this.

edited Apr 03 '22 at 22:13

ths

3,084
1
14
24

answered Aug 04 '14 at 07:09

Snehal Nagdeote

35
4

wrong...quotes missing in sql..values is there in `$det` ..btw i dint downvote!! ;) – NoobEditor Aug 04 '14 at 07:10

Why php code is not working?

4 Answers4