php - Trying to display SQL data in html table -


so have file supposed run sql query , return data , populate html table reason not returning data, in sql in database query return data not on website.

  <?php               //run query             $sql = "select id, topic_id, name, surveyid, questionid, longdesc, text, first_name , last_name , email                     polling_results 'topic_id' = '147796'                      order 'id, displayorder'";             $result = mysql_query($sql);             //fetch results             while ($row = mysql_fetch_array($result))             {                 //display results                 echo '<br /><table class="table table-bordered table-condensed">';                 echo '<thead><tr>';                 echo '<th>name</th>';                 echo '<th>email</th>';                 echo '<th>question text</th>';                 echo '<th>answer</th>';                 echo '</tr></thead>';                 echo '<tbody><tr>';                 echo "<td>".$row['first_name']."</td>";                 echo "<td>".$row['email']."</td>";                 echo "<td>".$row['longdesc']."</td>";                 echo "<td>".$row['text']."</td>";                 echo '</tr></tbody></table>';             }     ?>

got working, thank guys/gals.

you need change code below : because of mysql_* deprecated php 5.6 , onwards should use mysqli_* .

create db connection follows :

    <?php     // create connection     $db_conn = mysqli_connect ( $servername, $username, $password, $dbname );     // check connection     if (! $db_conn)     {         die ( "connection failed: " . mysqli_connect_error () );     } ?>

and code :

<?php               //run query             $sql = "select id, topic_id, name, surveyid, questionid, longdesc, text, first_name , last_name , email                     polling_results 'topic_id' = '147796'                      order 'id, displayorder'";             $result = mysqli_query($db_conn,$sql);              // creating table format               echo '<br /><table class="table table-bordered table-condensed">';                 echo '<thead><tr>';                 echo '<th>name</th>';                 echo '<th>email</th>';                 echo '<th>question text</th>';                 echo '<th>answer</th>';                 echo '</tr></thead>';                 echo '<tbody>';               //fetch results             while ($row = mysqli_fetch_array($result,mysqli_assoc))             {                 //display results                <tr>';                 echo "<td>".$row['first_name']."</td>";                 echo "<td>".$row['email']."</td>";                 echo "<td>".$row['longdesc']."</td>";                 echo "<td>".$row['text']."</td>";                 echo '</tr>';             }              echo '</tbody></table>';             // display data end.     ?>

if issue face please let me know.


Comments

Post a Comment

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

i've set bento/ubuntu-16.04 vagrant box using php 5.6, , getting following error quite few times when try , run shell script: "uncaught reflection exception: class domdocument not exist". i've tried adding following top of script (not together), each no success: "sudo apt-get install php5.6-xml", "sudo apt-get install php5-xml", "sudo apt-get install php-dom" i've tried resetting server "sudo service apache2 restart". does have suggestions?
Read more

vue.js - Create hooks for automated testing -

Image
qa guys complained can't automate frontend testing. because our html looks same outside. lazy hack did this <template> <div :role="$options.name"> ... </div> </template> <script> export default { name: 'vmcomponentname' } </script> which takes name script , applies html. in browser get: <div role="vmcomponentname"> ... </div> line :role="$options.name" goes in every component. is there dry er solutions? please share. additional details i'll explain in details looking for. imagine have vmusercreate form creates user. test case can create user . to automatically test without role, have use following selector: .wrapper > .wrapper > .wrapper > .submit-button the test extremely brittle (will break lot). if use roles can use [role="vmusercreateform"] .submit-button selector. many folds less brittle. so basically, i'm ...
Read more

Add new key value to json node in java -

i have json file : { "id":1, "name":"abc", "addressdetails": { "city":"newyork" } } i wanted add 1 more key-value ("pincode" : "414141") node 'addressdetails'. i tried using : objectmapper mapper = new objectmapper(); jsonnode root = mapper.readtree(new file("d://test.json")); objectnode node = mapper.createobjectnode(); node.with("addressdetails").put("pincode", "414141"); but it's not getting added, there way can ? you can try you should modify file path objectmapper mapper = new objectmapper(); objectnode nodes = mapper.readvalue(new file("d:\\test.txt"), objectnode.class); nodes.with("addressdetails").put("pincode", "414141"); mapper.writer().writevalue(new file("d:\\test.txt"), nodes);
Read more