 Html Form!, Using MySQL?! |
|
|
|
|
  |
  May 24 2008, 10:08 AM
Post
#1
|
|
|
Super Member  Group: [HOSTED] Posts: 397 Joined: 9-February 08 Member No.: 57,615  |
Hey, I need your help again!
I need some good working tutorial how I can update my SQL through HTML form. I did use some tutorials online found with the help of google; but they do not work properly; I mean there are still small mistakes. I need to have a good tutorial to follow. It should be based on security and more things. It has to be done in proper way... |
 |
 
|
|
Jun 10 2008, 06:02 PM
Post
#2
|
|
|
Super Member Group: [HOSTED] Posts: 397 Joined: 9-February 08 Member No.: 57,615 |
Please, post any replies to help me?!
|
|
|
|
|
Jun 10 2008, 11:00 PM
Post
#3
|
|
|
Super Member Group: [HOSTED] Posts: 217 Joined: 12-May 08 From: Istanbul, Turkey Member No.: 62,045 |
It is too hard to run a SQL query from a Html form. For example: You sent a query via GET method
http : // yoursite.com/myquery.php?q=SELECT+*+from ... You cannot run the query which is being hold by $_GET['q']. Because I tried this before. But there is one file minisql php script, maybe you can analyze it and extract some codes or use directly it. Use this file phpminiadmin.php Home page http://sourceforge.net/projects/phpminiadmin/ Download page http://sourceforge.net/project/showfiles.php?group_id=181023 (check the last version here and download) |
|
|
|
|
Jun 11 2008, 11:53 AM
Post
#4
|
|
|
Super Member Group: [HOSTED] Posts: 397 Joined: 9-February 08 Member No.: 57,615 |
Any more replies? This forum is intended to help people as well as to teach them!!!
|
|
|
|
|
Jun 27 2008, 08:25 PM
Post
#5
|
|
|
Newbie [Level 3] Group: [HOSTED] Posts: 40 Joined: 26-June 08 Member No.: 64,213 |
U want to execute queries through a FORM right? this is exatly what u need
 CODE <?php mysql_connect($server, $user, $pass); mysql_select_db($db); if(isset($_GET['query'])){ if(mysql_query(stripslashes($_GET['query']))){ echo "Executed!"; } else { die("Mysql Error!: " . mysql_error()); } } ?> <form method='GET'> <input type='text' name='query' value='SELECT * FROM table1' /> <input type='submit' /> </form> This is not realy a secure afcourse, but its not hard to secure. Good luck, have fun  - optiplex This post has been edited by optiplex: Jun 27 2008, 08:26 PM |
|
|
|
|
Similar Topics
|
Lo-Fi Version | Time is now: 12th October 2008 - 05:21 PM |