php - Populating HTML Table with Data from mysql Gives Empty Table Cells -


i want populate table data mysql database php, table cells remain empty when code executed, , don't receive errors

below code: 

<?php $host = "localhost"; // host name  $username = ""; // mysql username  $password = ""; // mysql password  $db_name = "test"; // database name  $tbl_name = "test_mysql"; // table name  $server_name = "localhost";  // create connection $con = new mysqli($server_name, $username, $password, $db_name, 3306); if($con->connect_error){     die("connection failed: ".$con->connect_error); }  // check connection if($con->connect_error){     die("connection failed: ".$conn->connect_error); }  $sql = "select * $tbl_name"; $result = $con->query($sql); ?> <table width="400" border="0" cellspacing="1" cellpadding="0">     <tr>         <td>             <table width="400" border="1" cellspacing="0" cellpadding="3">                 <tr>                     <td colspan="4"><strong>list data mysql</strong></td>                 </tr>                 <tr>                     <td align="center"><strong>name</strong></td>                     <td align="center"><strong>lastname</strong></td>                     <td align="center"><strong>email</strong></td>                     <td align="center"><strong>update</strong></td>                 </tr>                 <?php                 if($result->num_rows > 0){                     // output data of each row                     while($row = $result->fetch_assoc()){ ?>                         <tr>                             <td><? echo $rows['name']; ?></td>                             <td><? echo $rows['lastname']; ?></td>                             <td><? echo $rows['email']; ?></td>                             <td align="center"><a href="update.php?id=<? echo $rows['id']; ?>">update</a></td>                         </tr>                         <?php                     }                 }                 ?>             </table>         </td>     </tr> </table> <?php $con->close(); ?>

i think missing code, appreciate can give me!

try this...

<?php $host = "localhost"; // host name  $username = ""; // mysql username  $password = ""; // mysql password  $db_name = "test"; // database name  $tbl_name = "test_mysql"; // table name  $server_name = "localhost";  // create connection $con = new mysqli($server_name, $username, $password, $db_name, 3306); if($con->connect_error){    die("connection failed: ".$con->connect_error); }  // check connection if($con->connect_error){  die("connection failed: ".$conn->connect_error); }  $sql = "select * $tbl_name"; $result = $con->query($sql); ?> <table width="400" border="0" cellspacing="1" cellpadding="0"> <tr>     <td>         <table width="400" border="1" cellspacing="0" cellpadding="3">             <tr>                 <td colspan="4"><strong>list data mysql</strong></td>             </tr>             <tr>                 <td align="center"><strong>name</strong></td>                 <td align="center"><strong>lastname</strong></td>                 <td align="center"><strong>email</strong></td>                 <td align="center"><strong>update</strong></td>             </tr>             <?php             if($result->num_rows > 0){                 // output data of each row                 while($rows = $result->fetch_assoc()){ ?>                     <tr>                         <td><?php echo $rows['name']; ?></td>                         <td><?php echo $rows['lastname']; ?></td>                         <td><?php echo $rows['email']; ?></td>                         <td align="center"><a href="update.php?id=<?php echo $rows['id']; ?>">update</a></td>                     </tr>                     <?php                 }             }             ?>         </table>     </td> </tr> </table> <?php $con->close(); ?>

Comments

Post a Comment

Popular posts from this blog

searchKeyword not working in AngularJS filter -

i writing app using angularjs on front end. want search through table word/field; 1 search box everything. according article here: http://hello-angularjs.appspot.com/searchtable can use filter: searchkeyword this. this code, , not working expected. <label>search: <input ng-model="searchkeyword"></label> <table ng-repeat="post in posts | orderby: sort | filter: searchkeyword"> <tr> <td> {{index(post)}} </td> <td> {{post.title}} </td> <td> {{post.author}} </td> <td> {{post.content}} </td> <td> {{post.date | date: "d/m/yyyy"}} </td> </tr> </table> what should do? thank you try this: controller $scope.posts = [ {title:'title one', author:'author one', content: 'content one'}, {title:'title two', author:'author two', content: 'cont...
Read more

sequelize.js - Sequelize: sort by enum cases -

i have model ( article ) field (the name type ) of type enum('source', 'translated') , return 1 article ordered type field. source articles should returned before translated articles. like: article.findone(order: [ { type: [ 'source', 'translated' ] } ]); unfortunately there appears no built-in solution sorting enums. instead have sort by case , couldn't find documentation on how sequelize. what conventional approach here? sorting case hard in sequelize, sort field (the second answer in linked post) should possible: order: sequelize.fn('field', sequelize.col('type'), 'source', 'translated') it's supported mysql far know though
Read more

user interface - how to replace an ongoing process of image capture from another process call over the same ImageLabel in python's GUI TKinter -

i trying use following code create interactive gui changes color-space(hsv, rbg, grayscale etc) on event of button click. display opencv video in tkinter using multiprocessing being new python having problems multiprocessing , attempts on making gui change it's color space on button clicks hangs entire system. on it's implementation highly appreciated. thankyou. below code: import cv2 pil import image,imagetk import tkinter tk import numpy np multiprocessing import process , queue def quit_it(root,process): root.destroy() process.terminate() def black_andwhite(root,process): process.terminate p=process(target=capture_image, args=(5,queue, )) p.start() root.after(0, func=lambda: update_all(root, image_label, queue)) def update_image(image_label, queue): frame = queue.get() = image.fromarray(frame) b = imagetk.photoimage(image=a) image_label.configure(image=b) image_label._image_cache = b root.update() def update_all(root...
Read more