Form to MySql

mindeekv

I hava simple form (with text areas):

A:
B:
C:

And button Submit

How to make, when i push submit, this form write to mysql?

laserlight

What do you know of processing forms and updating relational databases?

djjjozsi

The form method i fpost, after posting the form, you can reach the textareas with $POST["A"] $POST["B"] $_POST["C"]

(if the textfield's name are A, B , C)

if the user filled out all the textareas, then connect to a database, and run a mysql INSERT command

Here you can find some good examples, and explanations:
http://www.tizag.com/mysqlTutorial/

<?php

if(!empty($_POST['A']) AND !empty($_POST['B']) AND !empty($_POST['C']))
	{
	include("connect_mysql.php"); //include the connection to the database
		$B = mysql_real_escape_string($_POST['B']);   //lets use the escape function to keep your table protected
		$C = mysql_real_escape_string($_POST['C']);
		$A = mysql_real_escape_string($_POST['A']);
		$query = "INSERT INTO abc (id,B, C, A)
VALUES ('','$B','$C','$A')";   //create the sql query for insert

$result=mysql_query($query) or die(mysql_error());  // run this query
	}
	else
		print "Fill all the textareas<br />";
?>

Servyces

This very much depends on the names of your form fields and database tables and fields. But basically it comes down to writing the content of the fields dynamically into a MySQL insert query.

mindeekv

Thanks.

One more question: can you give sample how to must look info.txt file if i am using this metod:

LOAD DATA LOCAL INFILE "info.txt" INTO TABLE abc;

Weedpacket

Probably Comma-Separated Variables (CSV) format. Consult your DBMS's documentation where it discusses the "LOAD DATA" statement.

mindeekv

Whats wrong? I submit form and no info goes to mysql.

<?
mysql_pconnect("lochalhost","user","pass");
mysql_select_db("whatever");

$ip 		= $_POST['ip'];
$portas = $_POST['portas'];
$type  = $_POST['type'];

if($submit)
{
    $result=MYSQL_QUERY("INSERT INTO lgsl (id,ip,q_port,type)"."VALUES ('NULL','$ip', '$portas','$type')");
}
?>


<form action=" <? echo $php_self ?> " method="post">
  <table width="344" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td>Server IP: </td>
      <td><INPUT NAME='ip' TYPE='TEXT' id="ip" SIZE=30 maxlength='100'></td>
    </tr>
    <tr>
      <td>Portas:</td>
      <td><INPUT TYPE='TEXT' NAME='portas' SIZE=30 maxlength='100'></td>
    </tr>
    <tr>
      <td>Game:</td>
      <td><INPUT TYPE='TEXT' value='halflife' NAME='type' SIZE=30 maxlength='100'></td>
    </tr>
    <tr>
      <td> </td>
      <td> </td>
    </tr>
  </table>
    <input type="submit" name="submit" value="submit">
    </p>
</form>

bradgrafelman

Where is $submit ever defined? It looks like you're expecting register_globals to be enabled, which it definitely should not be (and isn't). Try checking the $_POST array (like you did for the other incoming variables).
Don't do a simple if($var) to check if $var is set; if it isn't, you're generating a warning/notice everytime you do that. Instead, use a function such as [man]isset/man or [man]empty/man - that's what these functions were made for.
Again, for the form action, where is $php_self defined? You probably meant $_SERVER['PHP_SELF']. See this manual page for more information about the superglobal arrays: [man]variables.predefined[/man].
Your script is vulnerable to SQL injection attacks. User-supplied data should never be placed directly into a SQL query; instead, you should first sanitize it with a function such as [man]mysql_real_escape_string/man.
If id is an AUTO_INCREMENT column, which I suspect it is, you shouldn't try to specify a value for it in a query - just leave it out of your query altogether.

mindeekv

Can you remake my script?

bradgrafelman

No, I haven't the time. A client currently employs me to write, maintain, and troubleshoot web applications for him/her; PHPBuilder is my way to "volunteer" free help to other PHP developers, not offer free work.

I've given you plenty to go off of in my reply above, including links to the PHP manual which contains explanations and even examples, however.

mindeekv

Ok, i try make by another sample. What form action must by if i do like this sample?:

djjjozsi;10897840 wrote:
The form method i fpost, after posting the form, you can reach the textareas with $POST["A"] $POST["B"] $_POST["C"]

(if the textfield's name are A, B , C)

if the user filled out all the textareas, then connect to a database, and run a mysql INSERT command

Here you can find some good examples, and explanations:
http://www.tizag.com/mysqlTutorial/
<?php

if(!empty($_POST['A']) AND !empty($_POST['B']) AND !empty($_POST['C']))
	{
	include("connect_mysql.php"); //include the connection to the database
		$B = mysql_real_escape_string($_POST['B']);   //lets use the escape function to keep your table protected
		$C = mysql_real_escape_string($_POST['C']);
		$A = mysql_real_escape_string($_POST['A']);
		$query = "INSERT INTO abc (id,B, C, A)
VALUES ('','$B','$C','$A')";   //create the sql query for insert

$result=mysql_query($query) or die(mysql_error());  // run this query
	}
	else
		print "Fill all the textareas<br />";
?>

And how need to look "connect_mysql.php" file?

djjjozsi

What form action must by if i do like this sample?:

<form id="FormName" action="insert_into_db.php" method="post" name="FormName">

And how need to look "connect_mysql.php" file?

connect_mysql.php

<?php

/// For the following details,
/// please contact your server vendor

$hostname='***'; //// specify host, i.e. 'localhost'
$user='****'; //// specify username
$pass='****'; //// specify password
$dbase='****'; //// specify database name
$connection = mysql_connect($hostname , $user , $pass)
or die ("Can't connect to MySQL");
$db = mysql_select_db($dbase , $connection) or die ("Can't select database.");
?>

mindeekv

Thanks 😉 its working!

Ok, how to make that form info auto deleted after 30 days from mysql?

Mark_Cunningham

The Posts above are excellent and answer your question thoroughly.
You seem to be having the same problems I was having when I started so Just remember that the slightest syntax problem will cause an error.

If it helps Ill explain a very easy way of doing it but messy however its important to make mistakes at the beginning and avoid complex explanations as the experience of making the mistakes needs to be covered there are no shortcuts.

[INDENT]<?php

mysql_connect('localhost','your_username','your_password');//PHP my admin

mysql_select_db('your_database_name');//The database from PHP my admin

mysql_query(insert into $table($field1,$field2) values('test1','test2'));//this should work

?>[/INDENT]

Then log into PHP my admin and check that the data has been entered.
add your database connection to a function to reuse.

Once you have done this very simple example the more advanced examples above will make a lot more sense.

Other simple examples.
ziggy-design

mindeekv

I need now this.

mindeekv;10898054 wrote:
Thanks 😉 its working!

Ok, how to make that form info auto deleted after 30 days from mysql?

djjjozsi

Make a field into your table 4 example: date_time , its type should be DATE-TIME

When you insert into the database womething, use NOW() on this field to automatically insert the currend date/taime:
INSERT EXAMPLE:

INSERT INTO `shortener` (
`id` ,
`activation_code` ,
`date_time` ,
`url` ,
`label`
)
VALUES (
NULL , '1', NOW( ) , '2', '3'
);

if you can select,

SELECT * FROM `shortener` WHERE datediff(NOW(),`date_time`)>30;

You can DELETE:

DELETE FROM `shortener` WHERE datediff(NOW(),`date_time`)>30;

mindeekv

djjjozsi;10898103 wrote:
if you can select,
SELECT * FROM `shortener` WHERE datediff(NOW(),`date_time`)>30;
You can DELETE:
DELETE FROM `shortener` WHERE datediff(NOW(),`date_time`)>30;

And this script delete info after 30 days? 😕