Announcements | Last Post | |
---|---|---|
SoC Curricula | 09/30/2017 01:08PM | |
Demarcation or scoping of examinations and assessment | 02/13/2017 07:59AM | |
School of Computing Short Learning Programmes | 11/24/2014 08:37AM | |
Unisa contact information | 07/28/2011 01:28PM |
Re: Lesson 6 August 15, 2010 01:48PM |
Registered: 13 years ago Posts: 35 Rating: 0 |
Re: Lesson 6 August 15, 2010 02:02PM |
Registered: 13 years ago Posts: 35 Rating: 0 |
Re: Lesson 6 August 16, 2010 10:57AM |
Registered: 13 years ago Posts: 5 Rating: 0 |
Re: Lesson 6 August 16, 2010 10:58AM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Lesson 6 August 16, 2010 11:03AM |
Registered: 13 years ago Posts: 5 Rating: 0 |
Re: Lesson 6 August 21, 2010 02:16PM |
Registered: 14 years ago Posts: 58 Rating: 0 |
Language: PHP<?php $title = "Database Connection" ; include ("header.php") ; //This code adds a connection to the MySQL server $link = mysql_connect("localhost","alessio","password") ; //This code displays a list of available databases echo "<h3>The following databases are available:</h3>" ; $result = mysql_list_dbs() ; while ($row = mysql_fetch_row($result)) { echo $row[0], "<p>" ; } //This code selects a db and lists the tables vontained within echo "<h3>The following tables are in bookstore_db:</h3>" ; mysql_select_db("bookstore_db") ; $result = mysql_list_tables("bookstore_db") ; while ($row = mysql_fetch_row($result)) { echo $row[0], "<p>" ; include ("footer.php") ; ?>
Language: PHPwhile ($row = mysql_fetch_row($result)) { echo $row[0], "<p>" ;
Re: Lesson 6 August 21, 2010 04:46PM |
Registered: 13 years ago Posts: 35 Rating: 0 |
Re: Lesson 6 August 25, 2010 12:25PM |
Registered: 14 years ago Posts: 58 Rating: 0 |
Re: Lesson 6 August 25, 2010 03:26PM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Lesson 6 August 31, 2010 12:41PM |
Registered: 13 years ago Posts: 64 Rating: 0 |
Re: Lesson 6 August 31, 2010 02:11PM |
Registered: 14 years ago Posts: 34 Rating: 0 |
Re: Lesson 6 August 31, 2010 02:42PM |
Registered: 13 years ago Posts: 64 Rating: 0 |
Re: Lesson 6 August 31, 2010 02:59PM |
Registered: 14 years ago Posts: 34 Rating: 0 |
Re: Lesson 6 August 31, 2010 04:06PM |
Registered: 13 years ago Posts: 64 Rating: 0 |
Re: Lesson 6 September 01, 2010 03:22PM |
Registered: 14 years ago Posts: 58 Rating: 0 |
Re: Lesson 6 September 02, 2010 07:33AM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Lesson 6 September 02, 2010 11:56AM |
Registered: 14 years ago Posts: 58 Rating: 0 |
Re: Lesson 6 September 02, 2010 04:34PM |
Registered: 13 years ago Posts: 64 Rating: 0 |
Re: Lesson 6 September 02, 2010 08:42PM |
Registered: 13 years ago Posts: 19 Rating: 0 |
Re: Lesson 6 September 03, 2010 07:22AM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Lesson 6 September 03, 2010 01:50PM |
Registered: 14 years ago Posts: 58 Rating: 0 |
Re: Lesson 6 September 03, 2010 05:38PM |
Registered: 13 years ago Posts: 64 Rating: 0 |
toLanguage: PHP$result = mysql_list_tables("bookstore_db")
but i'm getting an error "Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given".Language: PHP$result = mysql_query("SELECT * FROM bookstore_db");
Re: Lesson 6 September 05, 2010 03:38PM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Lesson 6 September 06, 2010 04:54PM |
Registered: 13 years ago Posts: 64 Rating: 0 |
Language: PHP<?php $title = "Database Connection"; include "header.php"; //This code creates a connection to the MySQL server $link_id = mysql_connect("localhost", "root", ""); if($link_id) echo "Connected to the MySQL server successfully<br>"; else die ("Connection to the MySQL server unsuccessful"); //This code displays a list of available databases echo "<h3>The following databases are available</h3>"; $result = mysql_list_dbs(); while ($row = mysql_fetch_row($result)) { echo $row[0], "<p>"; } //This code selects a db and lists the tables contained within echo "<h3>The following tables are in bookstore</h3>"; mysql_select_db("bookstore_db"); //$result = mysql_list_tables("bookstore_db"); $result = mysql_query("SELECT * FROM bookstore_db"); while ($row = mysql_fetch_row($result)) { echo $row[0], "<p>"; } include "footer.php"; ?>
Re: Lesson 6 September 07, 2010 07:19AM |
Registered: 13 years ago Posts: 28 Rating: 0 |
Language: PHP$result = mysql_query("SHOW TABLES FROM bookstore_db");
Re: Lesson 6 September 07, 2010 06:40PM |
Registered: 14 years ago Posts: 58 Rating: 0 |
and it worked without a problem.Language: PHP$result = mysql_list_tables("bookstore_db") ;
Re: Lesson 6 September 07, 2010 10:00PM |
Registered: 13 years ago Posts: 7 Rating: 0 |
Re: Lesson 6 September 09, 2010 11:18AM |
Registered: 13 years ago Posts: 64 Rating: 0 |
Re: Lesson 6 September 14, 2010 11:22AM |
Registered: 14 years ago Posts: 34 Rating: 0 |