Mysql bind_param php issue

Asked Apr 24 '14 at 05:23

Active Apr 24 '14 at 05:41

Viewed 63 times

I have sql query

$query = "select * from users where username = '".$username."' and password = '".$password."'";

How to use mysql bind_param in this query

Trying this link and don't know how to give two conditions in where.

http://www.ultramegatech.com/2009/07/using-mysql-prepared-statements-in-php/

edited Apr 24 '14 at 05:25

PravinS

asked Apr 24 '14 at 05:23

user3350099

`binding parameters` are not supported by `mysql` you need to use either `mysqli` , `pdo` etc... – Nishant Solanki Apr 24 '14 at 05:29
pls suggest me for mysqli – user3350099 Apr 24 '14 at 05:30
@user3350099 the link you posted in your question refers the same.. you dont need any other suggestion.. just follow it... its for mysqli.. – Nishant Solanki Apr 24 '14 at 05:31
it is working fine but when i am giving two conditions in where it is not working.$stmt->prepare("SELECT username,password FROM users WHERE username=? && password = ?") – user3350099 Apr 24 '14 at 06:07
how does your bind_param() function look? – Fven Apr 24 '14 at 06:20
$stmt->bind_param('ss',$username,$password); – user3350099 Apr 24 '14 at 06:24
any error message with: `if (!$stmt->prepare("SELECT username, password FROM users WHERE username=? && password = ?")) { echo $stmt->error; }` – Fven Apr 24 '14 at 06:33

0 Answers0