[PDO]collect data from database


[PDO]collect data from database



I was follow this Guide



to collect Questions from database
after I reach the last question it keep repeat the same last question instead of displaying massage
here is my code


//////// Collected from databse ///////
$question_id=$question_id+1;

$no_questions = $dbo->query("select count(question) from questions
left join servey_question on questions.question_id = servey_question.question_id where servey_id = 'serv01' ")->fetchColumn();



if($question_id > $no_questions){

$next='F'; // Flag is set to display thank you message

}else{

$next='T'; // Flag is set to display next question




$count=$dbo->prepare("select * from questions where question_id=$question_id");

if($count->execute()){

$row = $count->fetch(PDO::FETCH_OBJ);


}
}
$main= array("data"=>array("q1"=>"$row->question","opt1"=>"$row->opt1","opt2"=>"$row->opt2","opt3"=>"$row->opt3","opt4"=>"$row->opt4","opt5"=>"$row->opt5","opt6"=>"$row->opt6","question_id"=>"$question_id","category_id"=>"$row->category_id"),"next"=>"$next"); //Here the error appear


// end of collection from database //////


echo json_encode($main);



in this line the Error appear:


$main= array("data"=>array("q1"=>"$row->question","opt1"=>"$row->opt1","opt2"=>"$row->opt2","opt3"=>"$row->opt3","opt4"=>"$row->opt4","opt5"=>"$row->opt5","opt6"=>"$row->opt6","question_id"=>"$question_id","category_id"=>"$row->category_id"),"next"=>"$next");



display this massage



Notice: Undefined variable: row in C:xampphtdocssurveysurvey0examck.php on line 212

Notice: Trying to get property of non-object in C:xampphtdocssurveysurvey0examck.php on line 212



I try to do this but it's only show me the first question then massage with out move to other questions


$main=array('data'=>array($row),'next'=>$next); //diaplay first question and then thank you massage



so can you please tell me what is goes wrong..please





You define $row inside a condition, and attempt to access it outside it after - so if the condition fails (as it seemingly does), $row is never defined. Move $main and the print of json_encode() inside the condition.
– Qirel
Jun 30 at 9:51



$row


$row


$main


json_encode()





@Qirel it's stop reporting error but still repeat the last question ans it's suppose to display massage
– lobna
Jun 30 at 10:05





if($count->execute()){ fails, which is why you got the error in the first place. Figure out why by enabling error-reporting, and checking for errors coming from PDO.
– Qirel
Jun 30 at 10:15


if($count->execute()){





There is no point using a prepared statement if you aren't parameterizing. That is a misuse of prepared statement.
– user3783243
Jun 30 at 11:18









By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

-

Popular posts from this blog

How to input without newline? (Python)

How to input without newline? (Python) I am trying to create a simple file editor in Python via the console (called PyCons). Here is my current program: def PyCons(f): file = open(f, "r") appe = open(f, "a") print("n=====nPyCons Editor, v1.2nPython 3.6.1n") global i i = 0 for line in file: i += 1 print(" {}| ".format(i) + line, end='') for k in range(10000000000000): print("n {}| ".format(i+1), end='') inp = input("") if inp == "@PyCons.save()": print("n=====") break else: i += 1 appe.write("n" + inp) I used the end method to make sure that the existing code in the file was printed properly in its line format, but the input function does not have an end attribute. So, when I go to enter code in the editor: end input end PyCons("magic.html") ... ===== PyCons Editor, v1.2 Python 3.6.1 1| <p>Hello!...
Read more

C++ thread error: no type named ‘type’ MINGW

C++ thread error: no type named ‘type’ MINGW I'm currently doing a project for my operational systems class and I have to make a program to find prime numbers to run in threads. So I did this: #include <iostream> #include <cmath> #include <thread> #define THREADNUMBER 100 using namespace std; int CONTADOR = 0; int CONTADORTHREADEXECUTADA = 0; int primeRange(int v1, int v2) { int a, limit; bool isprime; for (int i = v1; i <= v2; i++) { if (i % 2 != 0 && i % 3 != 0) { isprime = true; limit = i / 2; if(i == 1) isprime =false; limit = (int)sqrt(i); //General case for(a=2; a <= limit; a++){ if(i % i == 0 && i != 2){ isprime = false; break; } } if (isprime) { CONTADOR++; } } } CONTADORTHREADEXECUTADA++; return 1; } int main(int argc, char *argv[ ] ) { int number1 = atoi(argv[1]); int num...
Read more

Analog for TagView in flutter

Image
Analog for TagView in flutter I want to have UI like this: With native Android it can be done with libraries like https://github.com/whilu/AndroidTagView, how can it be done with flutter? 2 Answers 2 you can make the same UI by combining the Wrap and Chip widget as @wasyl montioned . but this is a full example about what you need Wrap Chip Notes : spacing deleteIcon avatar Chip Shape new Column( crossAxisAlignment: CrossAxisAlignment.stretch, children: <Widget>[ new Wrap( children: <Widget>[ Chip( label: new Text("Java"), onDeleted: () {}, labelPadding: EdgeInsets.all(2.0), deleteIcon: Icon(Icons.clear), ), Chip( label: new Text("C++"), onDeleted: () {}, labelPadding: EdgeInse...
Read more