[RESOLVED] Adding details to my database

MitchEvans

I want to be able to add details from my web page to my database but not sure how to do this?

The page where the details are entered:

<FORM action="thescript.php" method="post">
<P>
<LABEL for="operational_type">New Requirement Type: </LABEL>
<INPUT type="text" name="operational_type"><BR>
<INPUT type="submit" value="Add New Type">
</P>
</FORM>

The page they are sent to (thescript.php):

$some_string= mysql_real_escape_string ($_POST['operational_type']);

$res= mysql_query ("INSERT INTO require (rtid,require_txt) VALUES ('1','$some_string')");

Any ideas? Pleeeeeease.

shamly

It should be possible with da code you have shown.

void_function

You already asked this, and received help, and marked the thread resolved.

http://phpbuilder.com/board/showthread.php?t=10331108

So...... where is the problem now? You've got everything you need. Your code that you wrote above should work. Except, don't set tid explicitely if it is a primary_key with autoincrement.

MitchEvans

thescript.php just opens and is a blank screen as it should be, but then when I go to see if its added to the database it hasn't. I don't understand why, my first id is an autoincrement and unique.
So where is my problem? Sorry about this but I can't see any problems, was hoping fresh eyes might help.
some_string is echoing fine on thescript.php,

So is the problem here somewhere:

$res= mysql_query ("INSERT INTO 'survey' ('id','rtid','requirement_txt') VALUES ('','1','$some_string')");

shamly

Try this ...

$res= mysql_query ("INSERT INTO 'survey' ('id','rtid','requirement_txt') VALUES ('','1','" . $some_string . "')");

also make sure you have error reporting set and display errors On.

void_function

First, do not put anything into autoincrement field. Second, change it from unique to primary_key. Third, add this after your query in PHP:

if (!$res) echo mysql_error ();

And tell us what you see.

shamly

Ohh ya .. forgot abt the auto increemnt thing ...

$res= mysql_query ("INSERT INTO 'survey' ('rtid','requirement_txt') VALUES ('''1','" . $some_string . "')");

assuming id is the auto incrementing id remove it from the query.

MitchEvans

Ok when I have this:

$res= mysql_query ("INSERT INTO 'survey' ('rtid','requirement_txt') VALUES ('1','$some_string')");

I get this error:

MySQL server version for the right syntax to use near ''survey' ('rtid','requirement_txt') VALUES ('1','testing')' at l

void_function

Ah, yes, the backticks issue. Either remove the '' quotes around survey, or use `` (Alt-7).

MitchEvans

I have removed the " but left the brackets, I get no error now but still no data adds to my database.
I tried this code:

$res= mysql_query (INSERT INTO 'survey' ('rtid','requirement_txt') VALUES ('1','$some_string'));

void_function

No, not the double quotes around query string, but single quotes around survey:

$res= mysql_query ("INSERT INTO survey ('rtid','requirement_txt') VALUES ('1','$some_string')");

MitchEvans

I get this error now with your amended code:

right syntax to use near ''rtid','requirement_txt') VALUES ('1','testing')' at line 1testing

void_function

Remove single quotes around rtid and requirement_txt.

MitchEvans

It's working!!!!!!!!! Yeahhhhhhhhhhhhh!

I needed to take the single quotes from around the fieldnames aswell.

Thankyou so much for your help, you are a php saint!

void_function

I'm having a problem reading singlequotes from backticks on this monitor.... Good to hear it's solved, though.

MitchEvans

I don't suppose you know how to put an If statement on my thescript.php so that I can just have one script for all the different types to be added.

Example:

If Post name = Operational then
$some_string= mysql_real_escape_string ($_POST['operational_type']);
// Insert into the database
$res= mysql_query ("INSERT INTO survey (rtid,requirement_txt) VALUES ('1','$some_string')");

elseif Post name= Financial then

$some_string= mysql_real_escape_string ($_POST['financial_type']);
// Insert into the database
$res= mysql_query ("INSERT INTO survey (rtid,requirement_txt) VALUES ('2','$some_string')");

void_function

For example:

The form:

<form action="thescript.php" method="post">
<p>
<label for="some_data">New Requirement Type: </label>
<input type="text" name="some_data"><br>
<input type="radio" name="type" value="1"> Operational Type<br>
<input type="radio" name="type" value="2"> Financial Type<br>
<input type="submit" value="Add New Type">
</p>
</form>

In the form processing script:


$some_string= mysql_real_escape_string ($_POST['some_data']); 
$type= (int) $_POST['type'];

// Insert into the database 
$res= mysql_query ("INSERT INTO survey (rtid,requirement_txt) VALUES ($type,'$some_string')");