Skip to content

ErcanOPAK.com

  • ASP.Net WebForms
  • ASP.Net MVC
  • C#
  • SQL
  • MySQL
  • PHP
  • Devexpress
  • Reportviewer
  • About
MySQL / PHP

Repeater Function in PHP

- 05.05.19 | 22.11.19 - ErcanOPAK

You need to do a while loop to pull each rowset. mysql_fetch_array() will only pull one row at a time.

Consider this solution:

<?php
$dbhost = 'xxxx';
$dbuser = 'xxxx';
$dbpass = 'xxxx';
$dbname = 'xxxx';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

mysql_select_db($dbname, $conn);
$result = mysql_query("SELECT * FROM mytable", $conn);

<table>

while ($row = mysql_fetch_array($result)) {
    echo '<tr align="center"><td>' . htmlspecialchars($row['Picturedata']) . '</td></tr>';
}
?>

</table>

Related posts:

How to solve "PHP Update Required" warning on WordPress

How to connect MySQL Database with PHP

Navigate to a Div using a button in HTML

How to show a button with condition in PHP

Post Views: 112

Post navigation

How do you connect to multiple MySQL databases on a single webpage?
How to set Tooltip for a particular Devexpress Gridview Column

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

November 2025
M T W T F S S
 12
3456789
10111213141516
17181920212223
24252627282930
« Oct    

Most Viewed Posts

  • Get the User Name and Domain Name from an Email Address in SQL (914)
  • Get the First and Last Word from a String or Sentence in SQL (794)
  • How to select distinct rows in a datatable in C# (767)
  • How to add default value for Entity Framework migrations for DateTime and Bool (763)
  • How to make theater mode the default for Youtube (558)
  • Add Constraint to SQL Table to ensure email contains @ (556)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (527)
  • Average of all values in a column that are not zero in SQL (502)
  • Find numbers with more than two decimal places in SQL (417)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (411)

Recent Posts

  • How to get public ip address using Windows PowerShell
  • How to Reset Taskbar in Windows 11
  • Essential Steps to Take After Windows 11 Updates
  • How to list all tables referencing a table by Foreign Key in MS SQL
  • How to format date in Javascript
  • How to generate a random number for each row in T-SQL
  • How to solve ‘Microsoft.TeamFoundation.Git.Contracts.GitCheckoutConflictException’ problem
  • Why nautical mile equals 1852 mt
  • How to Find Day Name From Date in SQL Server
  • How to make pagination in MS SQL Server

Most Viewed Posts

  • Get the User Name and Domain Name from an Email Address in SQL (914)
  • Get the First and Last Word from a String or Sentence in SQL (794)
  • How to select distinct rows in a datatable in C# (767)
  • How to add default value for Entity Framework migrations for DateTime and Bool (763)
  • How to make theater mode the default for Youtube (558)

Recent Posts

  • How to get public ip address using Windows PowerShell
  • How to Reset Taskbar in Windows 11
  • Essential Steps to Take After Windows 11 Updates
  • How to list all tables referencing a table by Foreign Key in MS SQL
  • How to format date in Javascript

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter
© 2025 ErcanOPAK.com | Built with Xblog Plus free WordPress theme by wpthemespace.com