Salut. Doresc sa fac un site builder cu tehnologia drag and Drop. Codul generat in html as dori sa l salvez in mysql. Am functia Java script pentru asta.
cmdms.add('save-db', {
run: function (em, sender) {
sender.set('active', true); //get full HTML structure after design
var InnerHtml = editor.getHtml() + '<style>' + editor.getCss() + '</style>';
$.post("save.php", {html: InnerHtml},
function (result) {
//action after save success
});
},
});
si in save.php am :
<?php
require "login/dbconf.php";
$dbconn = mysqli_connect( $host, $username, $password, $db_name );
if (isset($_POST['html'])) {
$created = time();
$sql2 = "INSERT INTO `members` SET `templates` (html,created) VALUES ( '". $_POST['html'] ."','" . $created."');";
$query2 = mysqli_query( $dbconn, $sql2 );
}
?>
E corecta sintaxa de la $sql2? ce fac gresit?
In tabelul members am o coloana numita "tamplates"