|
|
|
Show all tables in a database. Good start to allowing users to choose tables that need editing
| <?
$sql = "show tables";
$result = connect($sql);
while ($rows = mysql_fetch_array($result))
{
echo $rows[0]."<br>";
}
function connect($sql)
{
$username = "root";
$pwd = "rum31nt";
$host = "localhost";
$dbname = "test";
//echo "commnecing connection to local db<br>";
if (!($conn=mysql_connect($host, $username, $pwd))) {
printf("error connecting to DB");
exit();
}
$db2=mysql_select_db($dbname,$conn);
$result = mysql_query($sql);
if ($result){
return $result;
}else{
$error = mysql_error();
echo "Can't complete query because $error";
die();
}
}
?> | |
|
|
| email new items in db
Categories : PHP, Email, Databases, MySQL, Beginner Guides | | | Specify your connection settings and create a link to a MySQL database.
Categories : PHP, PHP Classes, Databases, MySQL, Beginner Guides | | | Convert a File database into MySQL
Categories : PHP, Filesystem, Databases, MySQL, Beginner Guides | | | Newbie Notes #4 - Trapping dumb MySQL query errors
Categories : PHP, Databases, MySQL, Debugging, Beginner Guides | | | mySQL/PHP/search with multientry
form and table output with colored rows
Categories : PHP, Beginner Guides, MySQL, HTML and PHP, Databases | | | This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server.
Categories : Databases, MySQL, Complete Programs, PHP, Databases | | | for each record, do this to the first record, and do that to any subsequent record
Categories : PHP, Databases, MySQL, Beginner Guides | | | How to Insert a Date Format Into MySQL from PHP
Categories : PHP, Databases, MySQL, Date Time, Beginner Guides | | | bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager
Categories : MySQL, PHP, MySQL, Complete Programs, Databases | | | Newbie Notes #10 - Generating drop downs
Categories : PHP, MySQL, HTML, Beginner Guides, Databases | | | Making a simple Hit-Log using PHP and MySql
Categories : PHP, Log Files, Beginner Guides, Databases, MySQL | | | Cut your MySQL Connections to 1 line of code
Categories : PHP, Beginner Guides, Databases, MySQL | | | Accepts a database & hostname from a user and then HTTP username and password. Uses this to connect to a MySQL database. Produces a form based on the tables it finds there to allow the user to do SELECTs, INSERTs, and DELETEs.
Categories : Databases, PHP, MySQL, Complete Programs | | | phpAds, a complete banner and ad management system with detailled tracking and stats.
Categories : MySQL, Complete Programs, Ecommerce, PHP, Databases | | | Point and Click Interface ala MS Access for creating SQL statements.
Categories : MySQL, Complete Programs, General SQL, PHP, Databases | |
|
|
|
