can create database but not tables

saltedm8 · #1 Sep 15th, 2007, 20:57

i am trying to create a database with tables via injection, but i am having problems, it will create the database, but not the tables, can you see what is wrong here , thank you

Code: Select all

<?
$link = mysql_connect('localhost', 'root', '');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
$db  = 'CREATE DATABASE saltyblog';
$result = mysql_query($db);
mysql_select_db('saltyblog') or die('Cannot select database');
// Create a MySQL table in the selected database
$sql = 'CREATE TABLE `FORM` ('
        . ' `title` TEXT NOT NULL, '
        . ' `date` DATE NOT NULL, '
        . ' `subject` VARCHAR(30) NOT NULL, '
        . ' `blog message` TEXT NOT NULL'
        . ' )'; 
mysql_close($link);
?>

alexgeek · #2 Sep 16th, 2007, 00:32

Quote:

Originally Posted by saltedm8

i am trying to create a database with tables via injection, but i am having problems, it will create the database, but not the tables, can you see what is wrong here , thank you

Code: Select all

<?
$link = mysql_connect('localhost', 'root', '');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
$db  = 'CREATE DATABASE saltyblog';
$result = mysql_query($db);
mysql_select_db('saltyblog') or die('Cannot select database');
// Create a MySQL table in the selected database
$sql = 'CREATE TABLE `FORM` ('
        . ' `title` TEXT NOT NULL, '
        . ' `date` DATE NOT NULL, '
        . ' `subject` VARCHAR(30) NOT NULL, '
        . ' `blog message` TEXT NOT NULL'
        . ' )'; 
mysql_close($link);
?>

PHP: Select all


$sql = "CREATE TABLE FORM (
        title TEXT NOT NULL,
        date DATE NOT NULL,
        subject VARCHAR(30) NOT NULL,
        blog message` TEXT NOT NULL
        )";

that's it i think

alexgeek · #3 Sep 16th, 2007, 00:34

and you have to query it:

PHP: Select all


mysql_query($sql);

saltedm8 · #4 Sep 16th, 2007, 10:39

very weird, its still not working, i must be missing something somewhere, but i am getting no errors

Code: Select all

<?php
$link = mysql_connect('localhost', 'root', '');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
$db  = 'CREATE DATABASE saltyblog';
$result = mysql_query($db);
$sql = mysql_select_db('saltyblog') or die('Cannot select database');
// Create a MySQL table in the selected database
mysql_query($sql);  
    $sql='CREATE TABLE `form` (
        `title` TEXT NOT NULL 
        `date` VARCHAR(25) NOT NULL 
        `subject` VARCHAR(30) NOT NULL 
        `blog_mes` TEXT NOT NULL ) ;' 
 
 
?>

dab42pat · #5 Sep 16th, 2007, 10:52

instead of

'CREATE TABLE `form` (

try

CREATE TABLE `form` (

saltedm8 · #6 Sep 16th, 2007, 10:54

Parse error: parse error in c:\program files\easyphp1-8\www\new folder (2)\input.php on line 15

dab42pat · #7 Sep 16th, 2007, 11:18

line 15 I think is this

`blog_mes` TEXT NOT NULL ) ;'

TRY `blog_mes` TEXT NOT NULL );

saltedm8 · #8 Sep 16th, 2007, 11:29

nope, still the same - i think line 15 is this

Code: Select all

    $sql=CREATE TABLE `form` (

- as soon as you took out the hyphen, i got the error, - before i was getting no errors, it was just not creating the tables

alexgeek · #9 Sep 16th, 2007, 11:43

you have an excessive amount of uneeded apostrophes

saltedm8 · #10 Sep 16th, 2007, 11:48

so which do i need, and which dont i need ? , i took this the 'create table' bit straight from the database

i have tryed this

Code: Select all

mysql_query($sql);  
    $sql='CREATE TABLE form (
        title TEXT NOT NULL 
        date VARCHAR(25) NOT NULL 
        subject VARCHAR(30) NOT NULL 
        blog_mes TEXT NOT NULL ) ';

but still no luck

alexgeek · #11 Sep 16th, 2007, 12:04

for one thing you need $sql to be before the query

saltedm8 · #12 Sep 16th, 2007, 12:10

no error, but still no tables

Code: Select all

 $sql='CREATE TABLE form (
        title TEXT NOT NULL 
        date VARCHAR(25) NOT NULL 
        subject VARCHAR(30) NOT NULL 
        blog_mes TEXT NOT NULL ) ';
   
  
mysql_query($sql);

alexgeek · #13 Sep 16th, 2007, 13:59

Quote:

Originally Posted by saltedm8

no error, but still no tables

Code: Select all

 $sql='CREATE TABLE form (
        title TEXT NOT NULL 
        date VARCHAR(25) NOT NULL 
        subject VARCHAR(30) NOT NULL 
        blog_mes TEXT NOT NULL ) ';
   
  
mysql_query($sql);

no commas in there, try this one:

Code: Select all

 $sql="CREATE TABLE form (
        title TEXT NOT NULL,
        date VARCHAR(25) NOT NULL, 
        subject VARCHAR(30) NOT NULL, 
        blog_mes TEXT NOT NULL ) ";
   
  
mysql_query($sql) or die (mysql_error());

saltedm8 · #14 Sep 16th, 2007, 15:57

that did it, thank you very much

very

alexgeek · #15 Sep 16th, 2007, 15:58

you're welcome
you know how to put data aswell?

saltedm8 · #16 Sep 16th, 2007, 16:00

how to insert data you mean ?

this ?
SELECT * FROM `form` WHERE 1

or INSERT INTO ?

alexgeek · #17 Sep 16th, 2007, 16:04

Quote:

Originally Posted by saltedm8

		Webforumz.com > Main Forums > Program Your Website > Databases
can create database but not tables