Member Avatar for theimben

is there a way for me to echo the whole database so it will display all the information held within the database?

  • 2 Contributors
  • 1 Reply
  • 84 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Demiloy
Member Avatar for Demiloy

1. I'm presuming you're using MySQL?

2. What do you mean by "all the information held within the database"? Does that mean all the tables, or all the rows within the tables?

If you means the rows within the tables, it's very simple

// connect to mysql and use relevant database

$query1 = mysql_query("SELECT * FROM table1");

while ($table1 = mysql_fetch_array($query1))
{
//echo all the different columns
}

$query2 = mysql_query("SELECT * FROM table2");

while ($table2 = mysql_fetch_array($query2))
{
//echo all the different columns
}

//continue until there are no more tables left
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.