can create database but not tables

saltedm8 · #1 (**permalink**) 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 (**permalink**) 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 (**permalink**) Sep 16th, 2007, 00:34

and you have to query it:

PHP: Select all


mysql_query($sql);

saltedm8 · #4 (**permalink**) 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 (**permalink**) Sep 16th, 2007, 10:52

instead of

'CREATE TABLE `form` (

try

CREATE TABLE `form` (

saltedm8 · #6 (**permalink**) 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 (**permalink**) Sep 16th, 2007, 11:18

line 15 I think is this

`blog_mes` TEXT NOT NULL ) ;'

TRY `blog_mes` TEXT NOT NULL );

saltedm8 · #8 (**permalink**) 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 (**permalink**) Sep 16th, 2007, 11:43

you have an excessive amount of uneeded apostrophes

saltedm8 · #10 (**permalink**) 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 (**permalink**) Sep 16th, 2007, 12:04

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

saltedm8 · #12 (**permalink**) 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 (**permalink**) 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 (**permalink**) Sep 16th, 2007, 15:57

that did it, thank you very much

very

alexgeek · #15 (**permalink**) Sep 16th, 2007, 15:58

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

saltedm8 · #16 (**permalink**) Sep 16th, 2007, 16:00

how to insert data you mean ?

this ?
SELECT * FROM `form` WHERE 1

or INSERT INTO ?

alexgeek · #17 (**permalink**) Sep 16th, 2007, 16:04

Quote:

Originally Posted by saltedm8

how to insert data you mean ?

this ?
SELECT * FROM `form` WHERE 1

or INSERT INTO ?

that would be to select data,
and you don't need 'form' just form

saltedm8 · #18 (**permalink**) Sep 16th, 2007, 16:08

ok, how would i insert data to 'blog_mes' for example from a form

alexgeek · #19 (**permalink**) Sep 16th, 2007, 16:18

PHP: Select all


 $sql="insert into form (title, date, subject, blog_mes)
VALUES ($title, $date, $subject, $blog_mes)";
   
  
mysql_query($sql) or die (mysql_error());

Same as before
just change the query,
obviously you need to define $title, $date etc.

saltedm8 · #20 (**permalink**) Sep 16th, 2007, 16:24

this is my form, if it helps - ,

Code: Select all

<?
if ($_POST['submit'];) {
  $blog = $_POST['saltyblog'];
  $title = $_POST['title'];
  $subject = $_POST['subject'];
  $blog_mes = $_POST['blog_mes'];
  $sql="insert into form (title, date, subject, blog_mes)
VALUES ($title, $date, $subject, $blog_mes)";
mysql_query($sql) or die (mysql_error());
}
?>
<div align="center">
  <form action="<? $_SERVER['PHP_SELF'] ?>" method="post">
    <p><input name="title" type="text" value="TITLE" size="100">
    </p>
    <table width="600" height="39" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td width="270"><input name="date" type="text" value="DATE" size="45"></td>
        <td width="58">&nbsp;</td>
        <td width="136">
          <label></label>
          <div align="center"><strong>SUBJECT:</strong></div></td>
        <td width="136"><select name="DROP" id="DROP">
          <option>website design tips</option>
                        </select></td>
      </tr>
    </table>
    <label></label>
    <p>
      <textarea name="blog" cols="100" rows="15">BLOG MESSAGE</textarea>
        </p>
    <table width="632" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="494">&nbsp;</td>
        <td width="138"><div align="right">
          <input type="submit" name="submit" value="SUBMIT BLOG">
        </div></td>
      </tr>
    </table>
    </form>
</div>
</body>
</html>

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[SOLVED] create 2 tables	saltedm8	PHP Forum	4	Oct 8th, 2007 12:53
CREATE DATABASE name' from config.php	saltedm8	PHP Forum	10	Sep 21st, 2007 18:41
Displaying MySQL database tables on a page	vandiermen	PHP Forum	3	Jun 30th, 2007 21:58
two tables in one database, different result	ntgcmlfu	Classic ASP	5	Apr 20th, 2006 23:59
newbie simple create database to record web page input	jfb130	Databases	3	Aug 28th, 2005 16:37

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