DBSQL

how to use function Query($query,$data=array()) ?

The Query function is very easy to use, ex:

$db->Query('SELECT * FROM my_table WHERE MyField = ?',array($valueOfField));

This is used to prevent SQL Injection. You can use ? in the Query to substitue it for the data passed through the array.

Can you help me because I am very hopeless in php but I want to use your Class because I see it very good.


I have this table rslangue(idLangue,Langue) and 4 data.

This is my script:

<?php
require_once ('dbsql.class.php');
$conn=new DBSQL('mysql','localhost','root','','dbomef');
$sql_stat="select * from rslangue";
$valueOfField="Francais";
$conn->Query('SELECT * FROM rslangue WHERE Langue = ?',array($valueOfField));
?>

and I have this error on navigator:

Notice: Undefined offset: 1 in G:\EasyPHP 2.0b1\www\model\dbsql.class.php on line 211


How to display all data in my table rslangue

Try with this code:

<?php
require_once ('dbsql.class.php');
$conn=new DBSQL('mysql','localhost','root','','dbomef');
$conn->Query('SELECT * FROM rslangue WHERE Langue = ?',array('Francais'));
?>