Answered MODX + SQL Statement (PHP)

Hey Folks !

I'm using the add-on "Login"
Here's my problem


its working, i get

User1

Now i have built a small sql query as php-snippet and named it getNumbers


which i' calling with

I dont get any print with this !

i have checked if my parameter is correct. When i insert
at the end of my php snippet. its shown correctly.

When i call the snippet with

i get the result i want to have

i don't get it ,.... where is the mistake ?
(hope you could follow this)

when i dump my sql queryy it gets confusing



lead to

object(PDOStatement)#37 (1) { ["queryString"]=> string(70) "SELECT sum(numbers) FROM modx_test where user like 'user1'" } => Empty Reslt

object(PDOStatement)#39 (1) { ["queryString"]=> string(65) "SELECT sum(numbers) FROM modx_test where user like 'user1'" } => 14.28

[ed. note: compiler last edited this post 12 years, 1 month ago.]

It might help some if you could explain the desired result. Is your goal to count the number of users with the same username, include a user ID with the username or what?

so lets say i have a table modx_test with columns: id(pr key), username (var char), numbers (double pr.)
The strange thing here is that i obviously get 2 identicly sql queries that deliver different results.

It strikes me that



Gives me 2 matching strings but it says that they have different charachter counts.

Compare
object(PDOStatement)#37 (1) { ["queryString"]=> string(70) "SELECT sum(numbers) FROM modx_test where user like 'user1'" }
to
object(PDOStatement)#37 (1) { ["queryString"]=> string(65) "SELECT sum(numbers) FROM modx_test where user like 'user1'" }


It seems like, this variable is not transfered in php yet ... I guess the REAL query it is doing, is
"SELECT sum(numbers) FROM modx_test where user like '[[+username]]'"
which surely doesnt deliver results

What version of MODX are you using.

For Evolution, I believe that should be $modx->db->query(), though I doubt if that's your problem.

Also, in Evolution, when a query fails, MODX calls messageQuit(), which hopefully prints a message, then exits, so there's no return at all. That means can't test the return value and do anything in response.

You might also just do SELECT username rather than SELECT sum(numbers), and just get a count of the resulting rows.

Be aware that if 'user1' is the search key, it will never match 'user' in your LIKE query, but 'user' will match 'user1'. [ed. note: BobRay last edited this post 12 years, 1 month ago.]

thanks for advices bob,
I'm running modx revolution 2.3.1
I'm pretty sure now that the sql query arriving on my sql server is

So it has not converted [[+username]] -> 'user1' , that must be the problem

that solved my problems. I thought it would have been parsed before the php procedure is called. But now i got it, thanx

Glad I could help.