function set_active($con, $table, $bool, $id, $idd)
{
$sql = 'UPDATE ' . $table . ' SET is_active=' . $bool . ' WHERE ' . $id . '=' . $idd;
if (!mysqli_query($con, $sql)) {
echo errorphp($con);
}
mysqli_query($con, $sql);
}
$learn_more = trim($_POST['learn_more']);
$learn_more = mysqli_real_escape_string($con, $learn_more);
if ($learn_more == '') {
$learn_more = 'Няма добавено описание.';
}
if (mb_strlen($about_uni) > 2500 or mb_strlen($learn_more) > 2500) {
$_SESSION['last_savedu']['about_uni'] = $about_uni;
$_SESSION['last_savedu']['learn_more'] = $learn_more;
header('location: /unidescript.php');
return;
} else {
$sql = 'UPDATE users SET about_uni="' . $about_uni . '", learn_more="' . $learn_more . '" WHERE user_id=' . $_SESSION["id"];
if (mysqli_query($con, $sql)) {
header('location: /inhome.php');
} else {
echo errorphp($con);
}
}
}
/* DELETES */
if (isset($_POST['impd_del'])) {
deleted($con, 'imp_dates', 'dates_id', 'imp_dates.php');
}
if (isset($_POST['impn_del'])) {
deleted($con, 'imp_notes', 'note_id', 'imp_notes.php');
}
if (isset($_POST['del'])) {
deleted($con, 'spec_list', 'spec_id', 'inhome.php');
}
/* * ******************************GETS* */
/* if(isset($_POST['is_active_x'])){
function add_note($con)
{
$stm = $con->prepare("select COUNT(*) FROM imp_notes where user_id=" . $_SESSION["id"]);
$stm->execute();
$res = $stm->get_result();
$row = $res->fetch_assoc();
if ($row["COUNT(*)"] < 10) {
$sql = 'INSERT INTO imp_notes (user_id, note_txt) VALUES (' . $_SESSION["id"] . ', "Добави описание на бележката")';
if (mysqli_query($con, $sql)) {
header('location:/imp_notes.php');
} else {
echo errorphp($con);
}
} else {
echo '<div style="color:#fff;">Достигнахте позволения максимум за бележки. Изтрийте стара бележка, за да добавите нова.</div>';
}
}
