Phpmyadmin running SQL-php Tutorial

Source: Internet
Author: User
Phpmyadmin running SQL problems this post is finally edited in phpmyadmin by huoshi5151 from 2012-12-0921: 58: 13. no matter how the SQL statement conditions are written, click "run" and always SELECT & nbsp; * & nbsp; FROM & nbsp; 'test' & nbsp; WHERE & nbsp; 1 & nbsp; LIMIT & nbsp; 0 & phpmyadmin SQL running problems

This post was last edited by huoshi5151 at 21:58:13, January 9 ,.

In phpmyadmin, no matter how SQL statement conditions are written, after clicking execute
SELECT * 
FROM `test`
WHERE 1
LIMIT 0 , 30

For example, the SQL statement I entered is
SELECT `name` FROM `test` WHERE `id`=2

After the result is clicked
SELECT * 
FROM `test`
WHERE 1
LIMIT 0 , 30
Output

------ Solution --------------------
What is the relationship between them?
------ Solution --------------------
The problem with the phpmyadmin version should be that you can try it with the latest version, but you cannot change the SQL management tool. isn't it okay to execute statements in PHP?
------ Solution --------------------
Right? what do you think is the right result?
------ Solution --------------------
Reference:
Reference: The problem with phpmyadmin is that you can try another version, but you cannot change the SQL management tool. isn't it okay to execute statements in PHP?
Php execution also seems to be a problem
PHP code? 123456789 <[email protected] _ connect ("localhost", "root", "123456") or die ("link failed"); mys ......


[Email protected] _ connect ("localhost", "root", "123456") or die ("link failed ");
Mysql_select_db ("test", $ conn );

$ SQL = "SELECT * FROM 'test '";
$ Row = mysql_fetch_array ($ SQL );

Var_dump ($ row );

?>

Mark the result as follows:

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.