How to create listview in a web page? - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

How to create listview in a web page?

nicolemorfsnicolemorfs Posts: 1Member
This is my first time to make a web page . I'm using PHP and Mysql database. I've already connected the database, and creating the table. Here's the code:

Database Connection:


[code]
1 <?php
2 mysql_connect("localhost", "root") or die(mysql_error());
3 echo "Connected to MySQL<br />";
4 ?>
[/code]

Creating Table:

[code]
01 <?php
02
03 mysql_connect("localhost", "root") or die(mysql_error());
04 mysql_select_db("Stud_Info") or die(mysql_error());
05
06 mysql_query("CREATE TABLE Student_Info(
07 id INT NOT NULL AUTO_INCREMENT,
08 PRIMARY KEY(id),
09 name VARCHAR(30),
10 age INT)")
11 or die(mysql_error());
12
13 echo "Table Created!";
14
15 ?>


I want the information will show to the web page by using list view or data grid . But my problem is code of that. I try to find many codes but i didn't make it ..

Can you share me some of your codes or just guide me on how to do it. please......

it is my Pleasure ... Thanks... :D

[/code]









______________________________________________________________


[link=http://www.meetzeplumbing.com]Plumber Columbia SC[/link]
[link=http://www.meetzeplumbing.com]Lexington SC Plumber[/link]

Comments

  • pseudocoderpseudocoder Posts: 691Member ✭✭✭


    One thing you might try is using a scrolling div within a table

    [code]
    IDNameAge





    <?php
    $res = mysql_query("select * from Student_Info");
    if(mysql_num_rows($res) > 0) {
    while($row = mysql_fetch_assoc($res)) {
    echo "" .
    "" .
    "" .
    "";
    }
    }
    ?>
    " . $row['id'] . "" . $row['name'] . "" . $row['age'] . "

    [/code]

    It's super late for me, but hopefully it's valid code... my eyeballs are blurry. :D I didn't do any formatting of the table(s), but maybe something like that.



Sign In or Register to comment.