Insert custom mysql with viewer_functions

3 posts by 2 authors in: Forums > CMS Builder
Last Post: March 17, 2023   (RSS)

By AlanAlonso - March 16, 2023

Is there a shortcut using viewer_functions to insert custom mysql to the cmsb database, to avoid using this?

$conexion = mysqli_connect("localhost","user","pass","database");
if(!$conexion){
	die('No se puede conectar '.mysql_error());
	}
if (mysqli_query($conexion, $output )) {
    header("Location: alumnos.php");
die();
} else {
    echo mysqli_error($conexion);
}
mysqli_close ($conexion);

By Dave - March 17, 2023

Hi Alan, 

We have a few internal functions you can use.  Here are some options: 

$colsToValues = [
  'title' => 'test title',
  'content' => 'test content',
];

$newRecordNum = mysql_insert($tableName, $colsToValues);

Or you can get the mySQL object directly with mysqli() like this: 

$result = mysqli()->query($query);
if (!$result) { dieAsCaller("MySQL Error: ". htmlencode(mysqli()->error) . "\n"); }

Hope that helps!  Let me know any questions.

Dave Edis - Senior Developer

interactivetools.com

By AlanAlonso - March 17, 2023

Thank you Dave

The mysqli object working like a charm y will check mysql_escape() function.

ob_start();
include 'calificaciones_save_post.php';
$output = ob_get_clean();
if (mysqli()->query($output)) {
    header("Location: alumnos.php");
die();
} else {
    dieAsCaller("MySQL Error: ". htmlencode(mysqli()->error) . "\n");
}