[SOLVED] Database Connection PHP Still Doesn't Work, Please Help!!!

HelloWorld · #1 (**permalink**) 08-03-2007, 10:02 PM

Here's all the code that I have and some screen shot that I have the database from phpMyAdmin:

admin/index.php

PHP Code:

  
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Admin Login</title>
</head>
<body>
<?php
include 'config.php';
?>
<form action="<?php echo ($_SERVER['PHP_SELF']); ?>" method="get">
<!-- not yet implemented -->
</form>
</body>
</html>

admin/config.php

PHP Code:

  <?php
$username = 'username';         // MySQL username
$password = 'password';         // MySQL password
$host = 'localhost';        // MySQL host

$db = 'webtest';            // Database name

$link = mysql_connect($host,$username,$password) or die(mysql_error());

mysql_select_db($db);        // Select database

// MySQL Query
$query = 'CREATE TABLE mycms ('.
         'id INT NOT NULL AUTO_INCREMENT KEY'.
         'username VARCHAR(10) NOT NULL, '.
         'password VARCHAR(10) NOT NULL)'; 
         
$result = mysql_query($query);
?>

webtest database from phpMyAdmin
*attached*

TeraTask · #2 (**permalink**) 08-04-2007, 12:54 AM

What's the error message? Let me encourage you again to never, never, never, never, never ever post for help with something without sharing the error message. Even if they seem totally unhelpful, they can point out things to a trained coder.

HelloWorld · #3 (**permalink**) 08-04-2007, 01:15 AM

Quote:

Originally Posted by TeraTask

What's the error message? Let me encourage you again to never, never, never, never, never ever post for help with something without sharing the error message. Even if they seem totally unhelpful, they can point out things to a trained coder.

LOL, that's because there's no error message...
If there's an error message, I could have Google it and say something about it

so it's basically just return me a blank page (since I didn't put anything on index.php)

TeraTask · #4 (**permalink**) 08-04-2007, 01:18 AM

OK. Well, that's important too! Run this and tell me what the output is:

PHP Code:

 
 <?php
$username = 'username';         // MySQL username
$password = 'password';         // MySQL password
$host = 'localhost';        // MySQL host

$db = 'webtest';            // Database name

$link = mysql_connect($host,$username,$password);
echo __line__.") ".mysql_error()."<br />";
mysql_select_db($db);        // Select database
 echo __line__.") ".mysql_error()."<br />";
// MySQL Query
$query = 'CREATE TABLE mycms ('.
         'id INT NOT NULL AUTO_INCREMENT KEY'.
         'username VARCHAR(10) NOT NULL, '.
         'password VARCHAR(10) NOT NULL)'; 
         
$result = mysql_query($query);
echo __line__.") ".mysql_error()."<br />";
?>

</div>

HelloWorld · #5 (**permalink**) 08-04-2007, 01:45 AM

wow, that's really helpful.. thanx a lot TeraTask. but why doesn't it get detected with the the code that I had:

Code:

or die(mysql_error()

Here's the output:

Code:

 9) 
11) 
19) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'KEYusername VARCHAR(10) NOT NULL, password VARCHAR(10) NOT NULL)' at line 1

TeraTask · #6 (**permalink**) 08-04-2007, 01:52 AM

It doesn't show up b/c the error is in your mysql_query statement, not in the connection. After each mysql_xxx() statement, you should check for an error. or die(); isn't a very friendly check either.

Try replacing the create table with this:

Code:

CREATE TABLE `mycms` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `username` varchar(10) NOT NULL,
  `password` varchar(10) NOT NULL,
  PRIMARY KEY  (`id`)
)

Also, take note that I have made the primary key primary and unsigned. These are good things for almost every primary key.

So, how did I get this code to generate the table? I created the table in phpmyadmin and then chose export the table structure - all the code perfectly generated for me with virtually no effort.

OK. Time for me to finally go to bed. gl!

HelloWorld · #7 (**permalink**) 08-04-2007, 01:59 AM

For some reason the webtest database still doesn't show me any tables:

PHP Code:

  // MySQL Query
$query = 'CREATE TABLE mycms ('.
         'id INT NOT NULL AUTO_INCREMENT KEY'.
         'username VARCHAR(10) NOT NULL, '.
         'password VARCHAR(10) NOT NULL, '.
         'PRIMARY KEY  (id))';

that's what I got for the $query

TeraTask · #8 (**permalink**) 08-04-2007, 02:33 AM

Look very closely at the code I put up there against your own code. You didn't copy-and-paste.

P.S. It's not necessary to break a string up into a bunch of pieces as you're doing. Just put single quotes around it and let it span as many lines as you want.

HelloWorld · #9 (**permalink**) 08-04-2007, 08:16 AM

Quote:

Originally Posted by TeraTask

Look very closely at the code I put up there against your own code. You didn't copy-and-paste.

P.S. It's not necessary to break a string up into a bunch of pieces as you're doing. Just put single quotes around it and let it span as many lines as you want.

Works beautiful, I shouldn't have cared about "." dots... I thought I'd have to put those to send queries from PHP lol... Thanx a lot TeraTask

PHP Code:

  $query = 'CREATE TABLE `mycms` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `username` varchar(10) NOT NULL,
  `password` varchar(10) NOT NULL,
  PRIMARY KEY  (`id`)
)';