// #php — 2008-06-03
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
00:37:02 Quit: optimus ([email protected]) Quit: Sleep? Oh boy! That's where I'm a viking!
03:26:26 Join: fildo ([email protected]) to #php
03:28:06 Join: drexen ([email protected]) to #php
03:28:11 Mode: (by ChanOP) +v drexen
03:29:26 Nick: drexen is now known as drexen[out]
04:56:35 Nick: drexen[out] is now known as drexen[smoke]
05:00:51 Nick: drexen[smoke] is now known as drexen
05:30:37 Quit: Lukian ([email protected]) Ping timeout: 121 seconds
05:59:12 Nick: drexen is now known as drexen[out]
06:46:48 Join: smythe ([email protected]) to #php
06:46:51 Mode: (by ChanOP) +o smythe
11:22:54 Nick: drexen[out] is now known as drexen
12:40:05 Nick: drexen is now known as drexen[smoke]
13:07:23 Nick: drexen[smoke] is now known as drexen[out]
14:38:47 Nick: drexen[out] is now known as drexen
15:14:06 Nick: drexen is now known as drexen[out]
15:19:18 Join: Loserbait ([email protected]) to #php
15:20:08 Quit: drexen[out] ([email protected]) Ping timeout: 121 seconds
15:22:41 Quit: teranoid ([email protected]) Ping timeout: 151 seconds
15:23:22 Quit: smythe ([email protected]) Quit:
15:33:37 Join: Lukian ([email protected]) to #php
16:06:14 Quit: Loserbait ([email protected]) Connection reset by peer
16:06:21 Join: Loserbait ([email protected]) to #php
16:08:04 Join: XIO ([email protected]) to #php
16:11:19 Quit: Loserbait ([email protected]) Ping timeout: 121 seconds
17:16:36 Join: teza19 ([email protected]) to #php
17:16:53 <teza19> $sql = "select f_name, l_name from auth_users where username = '$_POST[username]' AND password = password('$_POST[password]')";
17:17:03 <teza19> that returns 0 rows. Why is that? everything is ok.
17:17:16 <teza19> even when i try to hard-code it through phpMyAdmin it returns 0 rows.
17:27:06 <XIO> What happens when you go: SELECT f_name, l_name FROM auth_users WHERE username = $_POST['username']";
17:33:38 <teza19> it works
17:35:59 <XIO> It's the apostrophe, methinks
17:36:24 <XIO> You made it '$_POST[username]' . I reckon you need to make it: $_POST['username']
17:36:35 <teza19> username works.
17:37:08 <teza19> with the apostrophes
17:38:14 <XIO> In that case, methinks you shouldn't call a function inside a query. Make a line: $passwordResult = password($_POST['password']); and in the query: password = $passwordResult
17:39:04 <teza19> it shouldn't make a difference.. hrmm
17:39:23 <XIO> Then there's something wrong with the function. Well, we've worked out that it's not the username =]
17:41:21 <teza19> doesnt work if i called it with: $pwResult
17:42:38 <XIO> Hmm... Well I'm at a loss... I can only imagine that there's something wrong with the code for the password. What's the function password() do?
17:42:52 <teza19> encrypts it
17:45:10 <XIO> Then it's just not finding any fields matching the encrypted result. Hmm...
17:45:31 <teza19> this code USED to work when i ran it ages ago
17:45:38 <teza19> sometime last yr
18:07:05 Join: Disco ([email protected]) to #php
18:22:27 Quit: teza19 ([email protected]) Quit:
19:37:19 Quit: Disco ([email protected]) Quit:
20:46:17 Join: schnoodles ([email protected]) to #php
21:15:59 Join: optimus ([email protected]) to #php
23:16:52 Join: schnootop ([email protected]) to #php
23:49:34 Join: MadDog ([email protected]) to #php
23:49:37 Part: MadDog ([email protected]) from #php
23:49:54 Quit: schnootop ([email protected]) Quit: Leaving
23:53:22 Join: schnootop ([email protected]) to #php
Search this day's buffer: