$start_year = $date[0]; $end_year = $start_year + $fim; if ($start_year < 1905) { echo "<script>alert('Data de início inválida!');</script>"; } else { if ($end_year - $start_year > 99) { echo "<script>alert('Duração de convênio inválida!');</script>"; } else { $end_date = ''; $end_date .= $end_year; $end_date .= '-'; $end_date .= $date[1]; $end_date .= '-'; $end_date .= $date[2]; $sql = "SELECT numero FROM convenio WHERE id_empresa = {$id};"; $line = querySql($c, $sql, "getline"); $numero_convenio = $line["numero"]; $numero_convenio = explode('/', $numero_convenio); $numero_empresa = $numero_convenio[0]; $novo_convenio = ''; $novo_convenio .= $numero_conv; $novo_convenio .= '/'; $novo_convenio .= $year % 100; mysql_close($c); include "conection.php"; $sql = "insert into convenio(numero, id_empresa, data_inicio,data_fim) values('{$novo_convenio}','{$id}','{$inicio}','{$end_date}')"; $res = mysql_query($sql); mysql_close($c); } } }
die; } if ($cnpj[12] != $d1 || $cnpj[13] != $d2 || !preg_match('/(^[\\d]{14}$)/', $cnpj)) { echo "<script>alert('CNPJ Inválido!')</script>"; die; } // VALIDAÇÃO CNPJ FIM // Expressão regular do CNPJ ou CPF: ([0-9]{2}[\.]?[0-9]{3}[\.]?[0-9]{3}[\/]?[0-9]{4}[-]?[0-9]{2})|([0-9]{3}[\.]?[0-9]{3}[\.]?[0-9]{3}[-]?[0-9]{2}) include 'dbfunctions.php'; $c = beginConection($acesso); $sql = "select *\n\t\t\t from empresa\n\t\t\t where(nome='{$name}' or cnpj='{$code}')"; if (querySql($c, $sql, "find") == false) { $sql = "insert into empresa(nome, cnpj) values('{$name}','{$code}')"; if (querySql($c, $sql, "create") == true) { $numeroConvenio = $comp . "/" . $end; $sql = "select id from empresa where(nome='{$name}' and cnpj='{$code}')"; $line = querySql($c, $sql, "getline"); $idEmpresa = $line["id"]; $sql = "insert into convenio(numero, id_empresa) values('{$numeroConvenio}','{$idEmpresa}')"; if (querySql($c, $sql, "create") == true) { $result = "\n\t\t\t\t\t<div class='alert'>\n\t\t\t\t\t\t<a style='color: white' href='company_search.php?company={$cnpj}'>\n\t\t\t\t\t\t\t<div class='stdSearchResult' style='background-color: #333333'>\n\t\t\t\t\t\t\t\t<font color='white'><br>\n\t\t\t\t\t\t\t\t\tEmpresa cadastrada e conveniada com sucesso.<br>Clique aqui para visualizar seus dados.\n\t\t\t\t\t\t\t\t</font>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</a>\n\t\t\t\t\t</div>"; } } } else { $result = "\n\t\t\t<div class='alert'>\n\t\t\t\t<a style='color: white' href='company_search.php?company={$cnpj}'>\n\t\t\t\t\t<div class='stdSearchResult' style='background-color: #333333'>\n\t\t\t\t\t\t<font color='white'><br>\n\t\t\t\t\t\t\tEmpresa já cadastrada.<br>Clique aqui para editar seus dados ou renovar convênio.\n\t\t\t\t\t\t</font>\n\t\t\t\t\t</div>\n\t\t\t\t</a>\n\t\t\t</div>"; } } mysql_close($c); echo $result; ?> </html>
function queryAllExercisePlan($userid) { $uid = intval($userid); $sql = "select * from `exercise_plan` where userid=" . $uid; $ary = array(); $res = querySql($sql); if ($res) { while ($row = mysql_fetch_array($res, MYSQL_ASSOC)) { array_push($ary, $row); } } return $ary; }
$id = isset($_GET['id']) ? $_GET['id'] : 1; $id = (int) $id; function querySql($sel, $from, $where, $alt) { $SQL = "SELECT {$sel} FROM {$from} WHERE `id` = " . $where; $date = mysqli_query($SQL); $count = mysqli_affected_rows(); if ($count === 1) { $inf = mysqli_fetch_array($data); $ansDate = $inf[0]; } else { $ansDate = $alt; } return $ansDate; } $str = querySql('title', 'page', $id, 'title'); function title() { $str = 'title'; return $str; } function menu() { $shablon = file_get_contents('menu.tpl'); return $shablon; } function info() { $textData = 'info'; return $textData; }