How to use RevCMS SQL engine?

[NSA]

Hello,

I was wondering, how do I use RevCMS to make SQL queries?
Not sure how to do this.

Thanks in advance.

 

[vRory]

check class.engine.php should tell you a few things.

 

[Weasel]

$engine->query("query here");

 

[NSA]

Whenever I try and use it, this happens:

 

[Weasel]

That has nothing to do with the RevCMS MySQL Engine.

 

[NSA]

It has something to do with it.
The page only goes like that once hitting the submit button on the form using the engine.

 

[Weasel]

It has something to do with it.
The page only goes like that once hitting the submit button on the form using the engine.

Could you post the code of the page?

 

[NSA]

<?php
function sendApp() {
$username = $engine->secure($_POST['username']);
$age = $engine->secure($_POST['age']);
$real_name = $engine->secure($_POST['real_name']);
$why_you = $engine->secure($_POST['why_you']);
$past_exp = $engine->secure($_POST['past_exp']);
$different = $engine->secure($_POST['different']);
$engine->query("INSERT INTO jobs (username,age,why_you,past_exp,different,real_name) VALUES ('" . $username . "','$age','$why_you','$past_exp','$different','$real_name')");
}
$username = $_POST['username'];
$real_name = $_POST['real_name'];
$why_you = $_POST['why_you'];
$past_exp = $_POST['past_exp'];
$different = $_POST['different'];
if(isset($username) && isset($real_name) && isset($why_you) && isset($past_exp) && isset($different)){
    sendApp();
}else{
    echo "error";
}
?>

P.S. I am aware I could've declared the variables and sent them through to the function.

 

[Weasel]

Try to add global $engine; below sendApp() {

 

[NSA]

Managed to get it working using the code below.

<?php
global $engine;
function sendApp() {
global $engine;
$username = $engine->secure($_POST['username']);
$age = $engine->secure($_POST['age']);
$real_name = $engine->secure($_POST['real_name']);
$why_you = $engine->secure($_POST['why_you']);
$past_exp = $engine->secure($_POST['past_exp']);
$different = $engine->secure($_POST['different']);
$engine->query("INSERT INTO jobs (username,age,why_you,past_exp,different,real_name) VALUES ('" . $username . "','$age','$why_you','$past_exp','$different','$real_name')");
}
$username = $_POST['username'];
$real_name = $_POST['real_name'];
$why_you = $_POST['why_you'];
$past_exp = $_POST['past_exp'];
$different = $_POST['different'];
if(isset($username) && isset($real_name) && isset($why_you) && isset($past_exp) && isset($different)){
    sendApp();
}else{
    echo "error";
}
?>

 

[Weasel]

Managed to get it working using the code below.

<?php
global $engine;
function sendApp() {
global $engine;
$username = $engine->secure($_POST['username']);
$age = $engine->secure($_POST['age']);
$real_name = $engine->secure($_POST['real_name']);
$why_you = $engine->secure($_POST['why_you']);
$past_exp = $engine->secure($_POST['past_exp']);
$different = $engine->secure($_POST['different']);
$engine->query("INSERT INTO jobs (username,age,why_you,past_exp,different,real_name) VALUES ('" . $username . "','$age','$why_you','$past_exp','$different','$real_name')");
}
$username = $_POST['username'];
$real_name = $_POST['real_name'];
$why_you = $_POST['why_you'];
$past_exp = $_POST['past_exp'];
$different = $_POST['different'];
if(isset($username) && isset($real_name) && isset($why_you) && isset($past_exp) && isset($different)){
    sendApp();
}else{
    echo "error";
}
?>

You can remove "global $engine; at the top.