Tukur Dan-Asabe asked 2 years ago
I want to use php variable as table for the phpGrid as code shown below:
$getRange=$_POST[‘game’];
……
……
$g->select_command = “select * from $getRange ” ;
$g->table = ” $getRange “;
……
……
it keeps given errors as follows:
Couldn’t execute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE 1=1 LIMIT 1 OFFSET 0’ at line 1 – select * from WHERE 1=1 LIMIT 1 OFFSET 0
oliver answered 8 months ago
I recommend you check this page for the academic options available. This solution will surely appeal to all students.
Nihat answered 2 months ago
The right syntax is below;
$getRange=$_POST[‘game’];
$g->select_command = “select * from “. $getRange;
$g->table = $getRange;
it is working fine…
Jon Mills answered 2 months ago
To resolve the SQL syntax error occurring in your PHPGrid implementation, you need to ensure that the `$getRange` variable holds a valid table name before utilizing it in constructing the SQL query. This can be achieved by first verifying that `$getRange` is not empty and conforms to the pattern of a valid table name, beginning with a letter or underscore followed by letters, digits, or underscores. Upon validation, proceed to construct the `select_command` and `table` properties of your PHPGrid object using the table name stored in `$getRange`. However, if `$getRange` is found to be empty or does not meet the criteria for a valid table name, handle this scenario appropriately, such as displaying an error message or employing a default table name as a fallback. By ensuring the integrity of the `$getRange` variable as a valid table name, you can mitigate SQL syntax errors and facilitate the proper execution of your SQL query within PHPGrid. Moreover you can use this website for such assignment question which has different PHD assistance teachers.
