Unknown Error :( in simple create table script

**kalkidaemon** · 04-13-2011 09:01 PM

Hi, I was making create table script where, first user need to login to their database, and than after login to database, script will automatically create table user for him. I made this But I could not find what is error? Before than this, I am new to PHP & MYSQL, If I have done blunder which is possible, or if i have done some small mistakes forgive me and guide me
Thanks.

Below is code.

PHP Code:


<?php

$dbhost=$_POST['dbhost'];

$dbuser=$_POST['dbuser'];

$dbpass=$_POST['dbpass'];

$con=mysql_connect($dbhost,$dbuser,$dbpass);

or die("Please Verify database hostname, username and password");

$select_db=mysql_select_db("woh", $con);

or die("could not select database");

$install=create table user(uid int not null auto_increment, uname varchar(40) not null, email varchar(50) not null, password varchar(32) not null, primary key (uid));

$install_query=mysql_query($install, $con);

$insert_user=insert into table user values(1, '$admin', '$email', '$pass');

$user_query=mysql_query($insert_query, $con);

$show_user=SELECT * from user;

$show_user_query=mysql_query($show_user_query, $con);



mysql_close($con);

?>



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><!-- start: index -->

<html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml">

<head>

<title>Install Krokite Social Script</title>

<link rel="stylesheet" type="text/css" href="/krokitesocial/css/install.css" />

<head>

<body>

<div id="content">

<table border="0" cellspacing="0" cellpadding="0">

<tr><td>Installation Process</td></tr>

<form method="post" action="install.php">

<tr><td>Enter Hostname:</td></tr>

<input type="text" name="dbhost" value="dbhost">

<tr><td>Enter Database User name: </td></tr>

<input type="text" name="dbuser">

<tr><td>Enter Database Password: </td> </tr>

<input type="password" name="dbpass">

</form>

</html>

**mikeroq** · 04-14-2011 08:17 PM

Best I can do without more information, I don't know where you are getting the $admin, $email and $pass variables from.

PHP Code:


<?php
function clean ($string){
$string = addslashes($string);
$string = htmlspecialchars($string);
$string = strip_tags($string);
return $string;
} 
if (isset($_POST['process'])
    {
        $dbhost = $_POST['dbhost'];
        $dbuser = $_POST['dbuser'];
        $dbpass = $_POST['dbpass'];
        if (!$dbhost || !$dbuser || !$dbpass)
            {
                echo "Form values missing";
            }
        else 
            {
                $sql = mysql_connect($dbhost,$dbuser,$dbpass) or die(mysql_error());
                mysql_select_db("woh", $sql) or die(mysql_error());
                $install = "CREATE TABLE `user` (
                `uid` int NOT NULL auto_increment, 
                `uname` varchar(40) NOT NULL, 
                `email` varchar(50) NOT NULL, 
                `password` varchar(32) NOT NULL, 
                PRIMARY KEY (uid)
                ) ENGINE=MyISAM";
                $create_table = mysql_query($install, $sql);
                if ($create_table == FALSE)
                    {
                        echo "MySQL error creating table:".mysql_error();
                    }
                else 
                    {
                        // variables clean them to stop sql injection and html code
                        $admin = clean($admin);
                        $email = clean($email);
                        
                        // always encrypt passwords!
                        $pass = sha1($pass);
                        
                        $user = "INSERT INTO `user` (`uid`, `uname`, `email`, `password`) VALUES ('1', '$admin', '$email', '$pass')";
                        $insert_user = mysql_query($user, $sql);
                        if ($insert_user == FALSE)
                            {
                                echo "MySQL error inserting admin user".mysql_error();
                            }
                        else 
                            {
                                echo "DB created and user inserted successfully.";
                            }
                    }
                mysql_close($sql);
            }
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><!-- start: index -->
<html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml">
<head>
    <title>Install Krokite Social Script</title>
    <link rel="stylesheet" type="text/css" href="/krokitesocial/css/install.css" />
</head>
<body>
<div id="content">
    <form method="post" action="install.php">
    <table border="0" cellspacing="0" cellpadding="0">
        <tr>
            <td>Installation Process</td>
        </tr>
        <tr>
            <td>Enter Hostname:</td>
            <td><input type="text" name="dbhost" value="dbhost" /></td>
        </tr>
        <tr>
            <td>Enter Database User name:</td>
            <td><input type="text" name="dbuser"></td>
        </tr>
        <tr>
            <td>Enter Database Password:</td>
            <td><input type="password" name="dbpass"></td>
        </tr>
        <tr>
            <td colspan="2"><input type="submit" name='process' value='Next' /></td>
        </tr>
    </table>
    </form>
</html>

**kalkidaemon** · 04-22-2011 09:09 AM

Not working either in my localhost.. It leaves white blank screen.

**mikeroq** · 04-22-2011 09:07 PM

Post the whole file contents of the file you are using that is providing the blank page please.

**kalkidaemon** · 04-24-2011 10:00 AM

[/php]
<?php
function clean ($string){
$string = addslashes($string);
$string = htmlspecialchars($string);
$string = strip_tags($string);
return $string;
}
if (isset($_POST['process'])
{
$dbhost = $_POST['dbhost'];
$dbuser = $_POST['dbuser'];
$dbpass = $_POST['dbpass'];
if (!$dbhost || !$dbuser || !$dbpass)
{
echo "Form values missing";
}
else
{
$sql = mysql_connect($dbhost,$dbuser,$dbpass) or die(mysql_error());
mysql_select_db("woh", $sql) or die(mysql_error());
$install = "CREATE TABLE `user` (
`uid` int NOT NULL auto_increment,
`uname` varchar(40) NOT NULL,
`email` varchar(50) NOT NULL,
`password` varchar(32) NOT NULL,
PRIMARY KEY (uid)
) ENGINE=MyISAM";
$create_table = mysql_query($install, $sql);
if ($create_table == FALSE)
{
echo "MySQL error creating table:".mysql_error();
}
else
{
// variables clean them to stop sql injection and html code
$admin = clean($admin);
$email = clean($email);

// always encrypt passwords!
$pass = sha1($pass);

$user = "INSERT INTO `user` (`uid`, `uname`, `email`, `password`) VALUES ('1', '$admin', '$email', '$pass')";
$insert_user = mysql_query($user, $sql);
if ($insert_user == FALSE)
{
echo "MySQL error inserting admin user".mysql_error();
}
else
{
echo "DB created and user inserted successfully.";
}
}
mysql_close($sql);
}
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Install Krokite Social Script</title>
<link rel="stylesheet" type="text/css" href="/krokitesocial/css/install.css" />
</head>
<body>
<div id="content">
<form method="post" action="install.php">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td>Installation Process</td>
</tr>
<tr>
<td>Enter Hostname:</td>
<td><input type="text" name="dbhost" value="dbhost" /></td>
</tr>
<tr>
<td>Enter Database User name:</td>
<td><input type="text" name="dbuser"></td>
</tr>
<tr>
<td>Enter Database Password:</td>
<td><input type="password" name="dbpass"></td>
</tr>
<tr>
<td colspan="2"><input type="submit" name='process' value='Next' /></td>
</tr>
</table>
</form>
</html>
[/php]

Thread: Unknown Error :( in simple create table script

Thread Tools

Display

Unknown Error :( in simple create table script

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions