function insertlabelset() { global $dbprefix, $connect, $clang, $labelsoutput; // $labelsoutput.= $_POST['languageids']; For debug purposes if (isset($_POST['languageids'])) { $postlanguageids=sanitize_languagecodeS($_POST['languageids']); } if (isset($_POST['label_name'])) { $postlabel_name=sanitize_labelname($_POST['label_name']); } $postlabel_name = db_quoteall($postlabel_name,true); $postlanguageids = db_quoteall($postlanguageids,true); $query = "INSERT INTO ".db_table_name('labelsets')." (label_name,languages) VALUES ({$postlabel_name},{$postlanguageids})"; if (!$result = $connect->Execute($query)) { safe_die("Inserting the label set failed:<br />".$query."<br />".$connect->ErrorMsg()); } else { return $connect->Insert_ID(db_table_name_nq('labelsets'),"lid"); } }
function insertlabelset() { //global $labelsoutput; // $labelsoutput.= $_POST['languageids']; For debug purposes $clang = Yii::app()->lang; if (!empty($_POST['languageids'])) { $postlanguageids = sanitize_languagecodeS($_POST['languageids']); } if (!empty($_POST['label_name'])) { $postlabel_name = sanitize_labelname($_POST['label_name']); } //postlabel_name = dbQuoteAll($postlabel_name,true); //$postlanguageids = dbQuoteAll($postlanguageids,true); $data = array('label_name' => $postlabel_name, 'languages' => $postlanguageids); //$query = "INSERT INTO ".db_table_name('labelsets')." (label_name,languages) VALUES ({$postlabel_name},{$postlanguageids})"; $result = Labelsets::model()->insertRecords($data); if (!$result) { safeDie("Inserting the label set failed:<br />" . $query . "<br />"); } else { return $result; } }