www.webdeveloper.com
Results 1 to 6 of 6

Thread: How to echo table php+mysql

Hybrid View

  1. #1
    Join Date
    Apr 2014
    Posts
    5

    How to echo table php+mysql

    Hi guys,
    i need echo first 2 rows of my table with connect to mysql database and get it to html table.
    This code echo all items of my table but i need just 2 rows. Please rewrite my code . Or send to me condition which i can use. THX!

    <?php
    $host='xxx';
    $user='xxx';
    $password='xxx';
    $database='xxx';
    // Connects to your Database

    mysql_connect($host, $user, $password) or die(mysql_error());
    mysql_select_db("$database") or die(mysql_error());
    mysql_query('SET NAMES UTF8');
    mysql_query('SET COLLATION_CONNECTION=uft8_slovak_ci');
    $table='culture';
    $query='SELECT * FROM '.$table;/* */
    $result=mysql_query($query) or die(mysql_error($db));



    //tabulka
    echo "<table class='table'>
    <tr>

    <th>názov</th>
    <th>Obrázok</th>
    </tr>";


    /*while ($record=mysql_fetch_array($result)
    echo "<tr>";
    echo "<td>".record['name']."</td>";
    echo "<td><img src=".$record['img']."></td>";
    echo "</tr>";
    };*/

    echo "</table>";
    /* Mysql_close($query);*/
    ?>

  2. #2
    Join Date
    Mar 2005
    Location
    Behind you...
    Posts
    862
    If you want to just return 2 rows of a table you need to change your MySQL query. It would look something like this:
    Code:
    'SELECT * FROM '.$table.' LIMIT 2';
    "Given billions of tries, could a spilled bottle of ink ever fall into the words of Shakespeare?"

  3. #3
    Join Date
    Feb 2014
    Location
    Canada
    Posts
    155
    You should re-write your script using mysqli or PDO functions to connect to your MySQL instead of mysql functions.

    Assuming there's a column in your table that always has unique values that do not repeat, just add that into your SQL statement in a WHERE clause. For example, if it was called Counter and contained only integer values 0, 1, 2, 3... then just change it to "SELECT * FROM MyTable WHERE Counter <= 1;" Change the table and column names accordingly for your table.

  4. #4
    Join Date
    Apr 2014
    Posts
    5
    I tried change my code to connect with mysqli but it dont work, i dont know i have bad connection to database or bad syntax in query or i have bad while condition ... I am really sad. Please rewrite my code and correct my mistakes THX!
    My table with all items look like this : http://www.treetechsolutions.sk/test.../getfromdb.php
    (i need echo only first 2 rows) of this table)

    <?php
    //conection:
    $host='xxx';
    $user='xxx';
    $password='xxx';
    $database='xxx';
    $db = mysqli_connect($host,$user,$password,$database) or die("Error " . mysqli_error($db));

    //consultation:

    $table='culture'; // for examle
    $query='SELECT * FROM '.$table.'WHERE ID <= 2';
    $result=mysqli_query($query) or die(mysqli_error($db));

    //display information:

    while($row = mysqli_fetch_array($result)) {
    echo "<tr>";
    echo "<td>".$row['nazov']."</td>";
    echo "<td><img src=".$row['obr']."></td>";
    echo "</tr>";
    }
    ?>

  5. #5
    Join Date
    Mar 2005
    Location
    Behind you...
    Posts
    862
    You probably just need a space before WHERE in your query.
    Code:
    $query='SELECT * FROM '.$table.' WHERE ID <= 2';
    "Given billions of tries, could a spilled bottle of ink ever fall into the words of Shakespeare?"

  6. #6
    Join Date
    Apr 2014
    Posts
    3
    $db_user = "db user";
    $db_password= "password";
    $db_name="db name";

    $con=mysqli_connect("localhost","$db_user","$db_password","$db_name");

    // Check connection
    if (mysqli_connect_errno())
    {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }

    $result = mysqli_query($con,"SELECT * FROM table" WHERE id='2'");
    while($row = mysqli_fetch_array($result))

    no you can get your things from database using $row[some field]

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles