PHP again... Help..

[Tharindu DR]

Machan How can I take two values from the address bar? and entering them to a SQL query?

Like this...

http://localhost/Eweb/biditem.php?id=1%20+%20table=book_new_item

these two values
id=1

table=book_new_item

I need them here.. Separately

SQL

$table=$_POST['table'];
$ids = $_POST['id'];
mysql_select_db($database_localhost, $localhost);
$query_items = "SELECT * FROM $table WHERE id= '$ids'";

Any1 can help???
Small Problem But I dont No PHP

 

[Tharindu DR]

No one Knows PHP????

 

[TΞΞNSTAR™]

if its .Net u can do this by SqlDataAdapter.. but dont have a much idea about PhP bro..

hope some1 would help u

 

[icreations]

TD meeka dan epa wenawa harida..

 

[Tharindu DR]

TD meeka dan epa wenawa harida..

Anthima Tika Oyeeeeeeeee.......
Poddak hoyapan koo

 

[mldarshana]

Machan How can I take two values from the address bar? and entering them to a SQL query?

Like this...

http://localhost/Eweb/biditem.php?id=1%20+%20table=book_new_item

these two values
id=1

table=book_new_item

I need them here.. Separately

SQL

$table=$_POST['table'];
$ids = $_POST['id'];
mysql_select_db($database_localhost, $localhost);
$query_items = "SELECT * FROM $table WHERE id= '$ids'";

Any1 can help???
Small Problem But I dont No PHP

u have to capture those values

let's say

$id = $_REQUEST['id'];
$table = $_REQUEST['table'];

then u can insert it to DB

mysql_query("insert into TABEL_NAME (id,table) VALUES ('$id','$table')");

hope u got it
cheers

 

[Tharindu DR]

Problem is machan


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id= 5 ?table=camera_new_item' at line 1

Meeke dekama 1 line1 kata gannaawa ne

 

[mldarshana]

Problem is machan


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id= 5 ?table=camera_new_item' at line 1

Meeke dekama 1 line1 kata gannaawa ne

sampurna query ekama dapan balanna

 

[Tharindu DR]

Udaaaw.....

 

[Tharindu DR]

Kawruth naddoo???

 

[icreations]

He he Ane Ban.. Ochcara marenna oona da ookata.. paw Best Of Luck..

 

[Tharindu DR]

He he Ane Ban.. Ochcara marenna oona da ookata.. paw Best Of Luck..

Thanx Bro....
Meeke PHP danna aya adu wela ne Akai Upset1...

 

[kanish1567]

mama hithanne machn umbe error eka thiyenne sql eke.Umba samaharawiat sql quary eke single quation danne nathuwa athi.awlak na ,just follow what i have added.ok let's say like this

$id=$_REQUEST['id'];
$table=$_REQUEST['table'];

$DBconnect=mysqli_connect("servername","username","password");
mysqli_select_db($DBconnect,"DATABASE")
or die("<p> The Database is not available </p>");

$sql="SELECT * FROM WHERE ID='$ID' ";

$SQLresult=@mysqli_query($DBconnect,$sql);

----------------------------------------------------------------
this is the right syntax for selecting records from the table.if u provide me enough details then i can help get u through it machn.Ela site ekak thiyenawa,i learned php from that site.www.w3schools.com.just surf and get knowladge from it.

 

[kanish1567]

sorry machn "id"should be simple

 

[booleanB]

Ek ekea PHP pothak thibba eake ethi