₦airaland Forum

Hello friend I need some help on How i can  Execute sql query from a link as in :

 
<a>Edit</a>

Where the link will point to PHP file and at end echo[/b]some stuff out
please attach some cash of code to your answer to help me much while i keep Goooogling

What i really want to do is display row of result like below

Name | ID |
==================
Shola |256 | Edit
John | 128 |Edi

Here Edit will be a link [b]<a>Edit</a> to a PHP page
Where the result will be handle by html form, Which Am sure i can handle
Regards

You can pass querystring to your php file. For example you <a href="http://example.com/phpfile.php?q=shola">click here to get shola's id</a>

in the php file you do

$query_from_a = $_REQUEST['q'];

$sqlquery= "SELECT ID FROM table_name WHERE Name='".$query_from_a."'";

http://goodmuyis.com/profile?get=lols

Use the $_GET array!!

dell_net:
You can pass querystring to your php file. For example you <a href="http://example.com/phpfile.php?q=shola">click here to get shola's id</a>

in the php file you do

$query_from_a = $_REQUEST['q'];

$sqlquery= "SELECT ID FROM table_name WHERE Name='".$query_from_a."'";

Mobinga:
http://goodmuyis.com/profile?get=lols

Use the $_GET array!!

Thank You guys for the help all work well my Own code below

<a href='updateEntry.php?edit=$getReport[studentID]
, 
$request = $_REQUEST['edit'];

$sql = mysql_query("SELECT *FROM student, accomodation, class, guardian,passport WHERE student.studentID=$request\n"
    . "AND accomodation.accomodationID=$request\n"
    . "AND class.classID=$request\n"
    . "AND guardian.guardianID=$request\n"
    . "AND passport.passportID=$request\n"
    . "LIMIT 1"; 

Be careful, always use mysqli_real_escape_string(); to escape your data.

Somebody can just do this goodmuyis.com/mysql.php?q=DROP%20DB;

Mobinga:
Be careful, always use mysqli_real_escape_string(); to escape your data.

Somebody can just do this goodmuyis.com/mysql.php?q=DROP%20DB;

Yea thank you i won't play with that, even thought i don;t care much about the project

<a href='updateEntry.php?edit=$getReport[studentID] ?

where did you get with it?

dell_net:
<a href='updateEntry.php?edit=$getReport[studentID] ?

where did you get with it?

The above is from my project Code file although written badly

---

Pls Guys is OK to do SQL Query(MySQL) like this from PHP although i have not tried it "

$search = $_POST['search'];

$sql = "SELECT FROM one, two, three WHERE one.ID=$search OR two.ID=$search or three.ID=$search"

GoodMuyis:
The above is from my project Code file although written badly

---

Pls Guys is OK to do SQL Query(MySQL) like this from PHP although i have not tried it "

$search = $_POST['search'];

$sql = "SELECT FROM one, two, three WHERE one.ID=$search OR two.ID=$search or three.ID=$search"

Be wary of security issues if you are deploying it to the internet.