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:

mysql_connect() in PHP 7
How to show a button with condition in PHP
How do you connect to multiple MySQL databases on a single webpage?
Navigate to a Div using a button in HTML
How to connect MySQL Database with PHP
Post Views: 110

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 *

May 2022
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
« Apr    

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (331)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (220)
  • How to solve “Response.Redirect cannot be called in a Page callback” for DevExpress Components (190)
  • Find numbers with more than two decimal places in SQL (190)
  • Confirm before process with ASPxButton in Devexpress (189)
  • ASPxGridView – Disable CheckBox based on condition in GridViewCommandColumn (189)
  • How to make some specific word(s) Bold or Underline in ReportViewer (189)
  • Devexpress ASPxGridview Column Grouping in Code (176)
  • Add Constraint to SQL Table to ensure email contains @ (174)
  • Tense Changes When Using Reported Speech (167)

Recent Posts

  • How to put text inside MVC Razor code block
  • How to solve 0xc0000135 application errors after Windows 11 Update
  • How to get the integrity value for a jquery version of script reference in a web page
  • How to get session value in Javascript
  • How to get value from resx file in C#
  • How to lock the ciritical code part in C#
  • How to make theater mode the default for Youtube
  • How to turn off YouTube annotations and cards
  • How to hide Youtube chat windows permanently
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server

Recent Posts

  • How to put text inside MVC Razor code block
  • How to solve 0xc0000135 application errors after Windows 11 Update
  • How to get the integrity value for a jquery version of script reference in a web page
  • How to get session value in Javascript
  • How to get value from resx file in C#

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (331)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (220)
  • How to solve “Response.Redirect cannot be called in a Page callback” for DevExpress Components (190)
  • Find numbers with more than two decimal places in SQL (190)
  • Confirm before process with ASPxButton in Devexpress (189)

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter

powered by XBlog Plus WordPress Theme