Jump to content
xisto Community
Sign in to follow this  
bdweb

Can Any One Help Me In Php Mysql

Recommended Posts

T1 and t2 is the name of a two text field Like I created a form in that forum I create a two text field given the name t1 and t2 and a submit button and save it as test.htm Now I want to get the value of t1 and t2 and put it in the MYSQL database through PHP script.Or I want to search the database with the value of t1 and t2 through PHP scriptCan any one give me the solution in a simple way it will be great help for meThanks in adv

Share this post


Link to post
Share on other sites

If what you need to do is get the values from the 2 textfields and store them in 2 string variables to be used later, then maybe I can help you.

It's probably the same as the code in a typical guestbook

put this under your body tag in your test.html

<form method="post" action="getString.php">	<input type="text" name="t1">  	<input type="text" name="t2">	<input type="submit" value="Get String" name="submit"></form>


create a file called getString.php This file will get the values of your testfields (from test.html) and then assigns them to your variables (stringT1 and stringT2) and then insert them to the TABLE_NAME in your database.
<?php  //create short variable names  $stringT1 = $HTTP_POST_VARS['t1'];  $stringT2 = $HTTP_POST_VARS['t2'];  $DOCUMENT_ROOT = $HTTP_SERVER_VARS['DOCUMENT_ROOT'];?><html><body><?php @ $db = mysql_pconnect('localhost', 'your user', 'your password');  //Connect to your databaseif (!$db){echo 'Error: Could not connect to database.  Please try again later.';exit;}mysql_select_db('database name');  $query = "insert into TABLE_NAME(field1,field2) values ('".$stringT1."', '".$stringT2."')"; $result = mysql_query($query);  	if ($result)  echo 'Success!'; ?></body></html>


getString.php inserts or adds the values of the textfields in the database but if you want to use those values to search in the database, all you need to do is replace the sql query with a select statement like this:
$query = "Select * in TABLE_NAME where field1=".$stringT1; 

Hope this helped.

Notice from BuffaloHELP:
Merged instead of deleting as requested.

Share this post


Link to post
Share on other sites

getString.php inserts or adds the values of the textfields in the database but if you want to use those values to search in the database, all you need to do is replace the sql query with a select statement like this:

$query = "Select * in TABLE_NAME where field1=".$stringT1;
I think to search you'd better use:
$query = "Select * in TABLE_NAME where field1 LIKE '%".$stringT1."%'";
The LIKE method is better for search queries since it isn't case sensitive. Ofcourse if you want it to be casesensitive use "=" and if you want to search exactly for a string don't use the "%".

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.