Exemple #1
0
function minql_query($query, $connection, $variables = array())
{
    return mysql_query(minql_compile($query, $variables), $connection);
}
Exemple #2
0
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with MinQl. If not, see <http://www.gnu.org/licenses/>.*/
require '../php/minql.php';
//Simple SELECT Query
$query = minql_compile("* <- abc");
echo $query;
echo "\n";
//Variable SELECT Query
$query = minql_compile("&f1,&f2,&f3 <- abc", array("a", "b", "c"));
echo $query;
echo "\n";
//Insert Query
$query = minql_compile("&f1,&f2,&f3 -> abc", array(10, 20, 30));
echo $query;
echo "\n";
//Create Query
$query = minql_compile("abcd -> a:int,b:text,c:text,d:int");
echo $query;
echo "\n";
//Update Query
$query = minql_compile("&f1=&f1+10 -> abc | &f1>20", array("a"));
echo $query;
echo "\n";
//Delete Query
$query = minql_compile("abc # a > 20");
echo $query;
echo "\n";