Can we use COUNT query with prepared statement?

|
2019-12-17 05:36:46
While displaying the result
2019-12-17 05:37:47
As soon as timer ends
Without refreshing the page result would come.
IlNoNamell 2019-12-17 05:40:52
2019-12-17 05:37:47
As soon as timer ends
Without refreshing the page result would come.

Send a Ajax request to a php which takes user answers in json format and evaluate it and returns a json format

2019-12-17 05:41:17
IlNoNamell 2019-12-17 05:40:52
Send a Ajax request to a php which takes user answers in json format and evaluate it and returns a json format

Oky

2019-12-17 05:41:23
2019-12-17 05:36:36
Like
UserID questions ID userANS
1. 1. animal
1. 2. Bird
1. 3. Animal

So I’m getting only last result

What about this?

2019-12-17 05:41:36
Which query i should use to display all data
IlNoNamell 2019-12-17 05:43:26
2019-12-17 05:41:36
Which query i should use to display all data

Data from ?

2019-12-17 05:43:39
Database
IlNoNamell 2019-12-17 05:45:20
Use mysql query and loop through the result
2019-12-17 05:46:15
2019-12-17 05:36:36
Like
UserID questions ID userANS
1. 1. animal
1. 2. Bird
1. 3. Animal

So I’m getting only last result

As I said I’m getting only last result user enters

IlNoNamell 2019-12-17 05:47:25
2019-12-17 05:46:15
As I said I’m getting only last result user enters

Are you saving the user answers to db ?

2019-12-17 05:47:32
Yes
IlNoNamell 2019-12-17 05:48:23
Are you sure all the data you save are in db ?

Did you check manually?

2019-12-17 09:44:30
My task is done till fetching correct data affer quiz ends

Here is screenshot

2019-12-17 09:44:46
luv_php-11519.jpg

2019-12-17 09:45:12
Now
How do i increment score for every correct answer user inputs
2019-12-17 09:45:24
If correct then +10
2019-12-17 09:46:08
2019-12-17 09:44:46

And as you see, question id 3 is repeated twice,

How to avoid that?
For unique question only

rohit267 2019-12-17 10:59:22
2019-12-17 09:46:08
And as you see, question id 3 is repeated twice,

How to avoid that?
For unique question only

distinct clause

rohit267 2019-12-17 10:59:51
make sure you use where clause with user id
rohit267 2019-12-17 11:01:15
2019-12-17 09:45:12
Now
How do i increment score for every correct answer user inputs

compare the answer with given answer, if correct, score = score+ 10

2019-12-17 11:01:46
rohit267 2019-12-17 10:59:51
make sure you use where clause with user id

Oky

2019-12-17 11:01:53
rohit267 2019-12-17 11:01:15
compare the answer with given answer, if correct, score = score+ 10

Oky
Let’s try

rohit267 2019-12-17 11:02:04
store the score in the score table with user id
rohit267 2019-12-17 11:02:20
show the score
2019-12-17 11:02:21
rohit267 2019-12-17 11:02:04
store the score in the score table with user id

Oky

2019-12-17 11:02:29
rohit267 2019-12-17 11:02:20
show the score

Yes

2019-12-17 13:30:13
I am looking for someone who can achieve “SecureCLI” in VxWorks5.5.

Some requirement:
– Experienced in VxWorks RTOS, SSH and basic networking
– Experienced in C language (NOT C++)
– Able to use Makefile and Tornado2.2 to develop the function
– Responsible person / team
– Good at teamwork
– Time-conscious person / team
– Live in UTC +6 ~ +11

Project Background: Our product only have a serial port for physical access and a management port that can access the console via Telnet. We want to add a SSH function in order to control the product in a secure connection rather than Telnet.

Sonali Yadav 2019-12-17 14:13:17
Hello everyone
I am a php developer
And working on laravel,cake,ci
Or knowledge of ionic and angular 4
Having experience of 2.5 year
Looking for a job at Delhi location
2019-12-17 14:28:29
You have one date then how to calculate last date of that month in JavaScript
2019-12-17 14:29:05
Any one know please help me
Kadakenishant 2019-12-17 14:37:26
PHP Creator Rasmus Lerdorf Shares Lessons Learned from the Last 25 Years – The New Stack
https://thenewstack.io/php-creator-rasmus-lerdorf-shares-lessons-learned-from-the-last-25-years/

PHP Creator Rasmus Lerdorf Shares Lessons Learned from the Last 25 YearsThe New Stack
This year’s annual phpDay Italian PHP conference in Verona ended with a surprisingly reflective talk from the original creator of PHP. As the closing speaker, 50-year-old Rasmus Lerdorf looked back over the web backend programming language’s last 25 years, and offered some lessons learned from the evolution of a humble hypertext preprocessor into a major…
rohit267 2019-12-17 14:42:56
2019-12-17 14:28:29
You have one date then how to calculate last date of that month in JavaScript

use date.js

Dipanshu Varshney 2019-12-17 14:48:49
Thank u
2019-12-17 16:20:13
Can we use COUNT query with prepared statement??
2019-12-17 16:23:48
luv_php-11547.jpg

2019-12-17 16:23:52
Any mistake in this code?
2019-12-17 16:24:14
Please guide
Mayank_theDevloper 2019-12-17 16:25:53
which error comming ?
2019-12-17 16:26:44
Fatal error
2019-12-17 16:27:02
luv_php-11552.jpg

2019-12-17 16:33:25
2019-12-17 16:27:02

Any??

Mayank_theDevloper 2019-12-17 16:35:58
I think you need to check your query bcz error point to your query please debug line one by one
2019-12-17 16:41:09
I have checked, query is oky
Mayank_theDevloper 2019-12-17 16:44:44
ok add this line top of file
<?php
error_reporting(E_ALL);
ini_set(‘display_errors’, 1);
Mayank_theDevloper 2019-12-17 16:44:51
and check
essam_1987 2019-12-17 19:30:53
How i can get real ip address from clients how entered to my page?
essam_1987 2019-12-17 19:30:59
And computer name
sakshampatni 2019-12-17 19:44:16
Why do you want to collect ip’s
Hijamacupping 2019-12-17 19:46:25
Any PHP developer from Mumbai ?
|