connecting to and showing results mysql

davaddavad

I hope it is ok to show this script if not mod delete it please. I just got php installed by my host and mysql. I dont have phpmyadmin or a mysql window. The only way I can connect is thru php. My host gave me the first half of the php page below. I added the select and create table from another script i found. I believe it built the table but I havent found the correct script to show the table to me. any help appreciated Dave

<?
$host="*******";
$dbase="**";
$login="**";
$passwd="****";
$cnx = mysql_connect($host,$login,$passwd);
if (!$cnx) {
print "Error Connecting to MySQL server\n<BR>";
exit(0);
}
else {
mysql_select_db($dbase) or die("Error changing Database");
print "Connected to database!\n<BR>";
}
@mysql_select_db($dbase) or die( "Unable to select database");
$query="CREATE TABLE contacts (id int(6) NOT NULL auto_increment,first varchar(15) NOT NULL,last varchar(15) NOT NULL,phone varchar(20) NOT NULL,mobile varchar(20) NOT NULL,fax varchar(20) NOT NULL,email varchar(30) NOT NULL,web varchar(30) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))";
mysql_query($query);
$query="SELECT FROM contacts";
$result=mysql_query($query);
mysql_close();
?>

Dedix

If you're using windows (and your host allows external connections) you should try mysqlfront. Its very easy to use and has great features.

www.mysqlfront.de

davaddavad

I tried the link but it says it has been discontinued.🙂

Dedix

Originally posted by davaddavad
I tried the link but it says it has been discontinued.🙂

I think you missed out the forum link 😃

so here it is:

http://efux.de/mysqlfront/MySQL-Front_2.5_Setup.exe

davaddavad

I got a connection failed access denied when i tried to connect. I can only access mysql thru php commands. I am the first database on this host they dont have much experience yet and I have little teck support. So do you know the php command I can include in the above code so I can see if I created that table?

Dedix

Your code is right (I have tried to run it on my server) But try this code:

$tbl_list = mysql_list_tables($dbase);
   if (!$tbl_list) {
        print "Could not list tables";
        print 'Mysql said: ' . mysql_error();
        exit;
    }

while ($row = mysql_fetch_row($tbl_list)) {
    print "tablename: $row[0]<br>";
}

davaddavad

<?
$host="";
$dbase="";
$login="";
$passwd="";
$cnx = mysql_connect($host,$login,$passwd);
if (!$cnx) {
print "Error Connecting to MySQL server\n<BR>";
exit(0);
}
else {
mysql_select_db($dbase) or die("Error changing Database");
print "Connected to database!\n<BR>";
}
@mysql_select_db($dbase) or die( "Unable to select database");
$query="CREATE TABLE contacts (id int(6) NOT NULL auto_increment,first varchar(15) NOT NULL,last varchar(15) NOT NULL,phone varchar(20) NOT NULL,mobile varchar(20) NOT NULL,fax varchar(20) NOT NULL,email varchar(30) NOT NULL,web varchar(30) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))";
mysql_query($query);
$query="SELECT * FROM contacts";
$db_list = mysql_list_dbs($link);

while ($row = mysql_fetch_object($db_list)) {
echo $row->Database . "\n";
}
$result=mysql_query($query);
$tbl_list = mysql_list_tables($dbase);
if (!$tbl_list) {
print "Could not list tables";
print 'Mysql said: ' . mysql_error();
exit;
}

while ($row = mysql_fetch_row($tbl_list)) {
    print "tablename: $row[0]<br>";
}

mysql_close();
?>
Ok that is the code i tried and got these messages

Connected to database!

Warning: mysql_list_dbs(): supplied argument is not a valid MySQL-Link resource in d:\jamesdiamond.com\createtable.php on line 19

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in d:\jamesdiamond.com\createtable.php on line 21
tablename: contacts

Dedix

Change this:

$db_list = mysql_list_dbs($link);

to this:

$db_list = mysql_list_dbs($cnx);

Pay more attention when you're coding...

davaddavad

Thank you: Ok cool🙂 output
Connected to database!
camelback jamesdiamond_com mysql veneration_net tablename: contacts

So the output is the 3 databases on the server and my table name correct?
So now I need to add data to the table and show its output correct? Back to the search... 🙂

Dedix

Yeah it's correct 😉

I think you should check out the php manual at php.net site.

Here is a link to mysql functions reference:

http://www.php.net/manual/en/ref.mysql.php

Good luck! 🙂