Php

murugaperumal.s · #1 (**permalink**) 01-12-10, 06:17 PM

Hai friend,

I need your help. i am beginer of php. In my question "how to store the information php form to database mysql.

ruteckycs · #2 (**permalink**) 01-12-10, 08:27 PM

Thats a fairly general question ... however here is a good MYSQL / PHP tutorial. I suggest you read it and try the sample codes.
MySQL Tutorial - Introduction

murugaperumal.s · #3 (**permalink**) 01-13-10, 11:46 AM

I tried in this code. But in this showing error notice "undefined index: submit". Please give a solution for in this.

<html>
<body>
<form method="post" action="edit.php">
<b>username:</b>
<input type="text" name="username" size="40">
<br>
<b>phone:</b>
<input type="text" name="phone" size="10">
<br>
<input type="submit" name="submit" value="sign!">
<input type="startover" name="restart" value="tryagain">
</form>
</body>
</html>
<?php
/* dbconnect.php as a database connection file */
include("dbconnect.php");
if($_REQUEST["submit"] == "submit")
{
$query="insert into test(username,phone) values ('".$_REQUEST['username"]
."','".$_REQUEST['phone"]."')";
mysql_query($query)
}
?>

End User · #4 (**permalink**) 01-13-10, 01:53 PM

Quote:

Originally Posted by murugaperumal.s

I tried in this code. But in this showing error notice "undefined index: submit". Please give a solution for in this.

You can ignore this error for the moment, it just means that you didn't initialize the variable REQUEST['submit'].

This code should NOT be used in a web-facing environment, as it doesn't screen or sanitze any of the input variables pulled from the REQUEST[] array. If you run this code as-is, your site or server will very likely be hacked.

murugaperumal.s · #5 (**permalink**) 01-14-10, 11:54 AM

I cann't store the information form to database. I need the solution for this. In my request How to store the value Form to the Database (HTML FORM TO MYSQL)?
I am working in WAMP.

<html>
<body>
<form method="post" action="edit.php">
<b>username:</b>
<input type="text" name="username" size="40">
<br>
<b>phone:</b>
<input type="text" name="phone" size="10">
<br>
<input type="submit" name="submit" value="sign!">
<input type="startover" name="restart" value="tryagain">
</form>
</body>
</html>
<?php
/* dbconnect.php as a database connection file */
include("dbconnect.php");
if(isset($_REQUEST["submit"]) && submit== "sign!")
{
$query="insert into test(username,phone) values ('".$_REQUEST['username"]
."','".$_REQUEST['phone"]."')";
mysql_query($query);
}
?>

End User · #6 (**permalink**) 01-14-10, 12:38 PM

Quote:

Originally Posted by murugaperumal.s

I cann't store the information form to database.

You have to give us more information than "I cann't store the information form to database". For example:

What error messages are you seeing?
Is the submitted information making it into the query?
Is anything being stored?
Are you sure you're establishing a database connection?

murugaperumal.s · #7 (**permalink**) 01-14-10, 12:47 PM

I enter the username and phone information in form. It cann't store in the database. After going to see the database it will empty. It wouldn't show any error. I need good solution for this.

murugaperumal.s · #8 (**permalink**) 01-14-10, 12:57 PM

Thanks for kind reply
I did mistake in your 2nd Question. I didn't grant the submit permission into the Query.

ruteckycs · #9 (**permalink**) 01-14-10, 02:37 PM

Add

or die(mysql_error());

to the end of you quarry and see if you get an error report.

Jcbones · #10 (**permalink**) 01-14-10, 05:01 PM

PHP Code:


			
<html>
<body>
<form method="post" action="">
<b>username:</b>
<input type="text" name="username" size="40">
<br>
<b>phone:</b>
<input type="text" name="phone" size="10">
<br>
<input type="submit" name="submit" value="sign!">
<input type="startover" name="restart" value="tryagain">
</form>
</body>
</html>
<?php
/* dbconnect.php as a database connection file */
include("dbconnect.php");
$submitArray = array('sign!');
$submit = (isset($_POST['submit'])) ? $_POST['submit'] : NULL;
if(isset($submit) && in_array($submit,$submitArray))
{
$user = (isset($_POST['username'])) ? mysql_real_escape_string($_POST['username']) : NULL;
$phone = (isset($_POST['phone'])) ? mysql_real_escape_string($_POST['phone']) : NULL;
    if($user != NULL && $phone != NULL) {
        $query="INSERT INTO `test`(`username`,`phone`) VALUES ('$user','$phone')";
        mysql_query($query) or die(mysql_error());
    }
    else {
        echo 'You must fill in both the Username, and the Phone Number!';
    }
}
?>