function acessaBD($comando, $tabela, $campos = '', $criterios = '') { //, $mysql_host, $mysql_user_name, $mysql_password, $mysql_db_name) { mysqlConnection(); //$mysql_host,$mysql_user_name,$mysql_password,$mysql_db_name); //Acessa BD //Configura query para UTF-8 mysql_query("SET NAMES 'utf8'"); mysql_query('SET character_set_connection=utf8'); mysql_query('SET character_set_client=utf8'); mysql_query('SET character_set_results=utf8'); switch ($comando) { case 'SELECT': //Retorna o array com o recordset da query $query = $comando . ' ' . $campos . ' FROM ' . $tabela . ' WHERE ' . $criterios; $rs = mysql_query($query) or die(mysql_error()); if (mysql_num_rows($rs) < 1) { return 0; } else { $row = mysql_fetch_array($rs) or die(mysql_error()); } return $row; break; case 'UPDATE': //Retorna 1 ou 2 $query = $comando . ' ' . $tabela . ' SET ' . $campos . ' WHERE ' . $criterios; if (mysql_query($query) or die(mysql_error())) { return 1; } else { return 2; } //Erro no UPDATE break; case 'INSERT': $query = $comando . ' INTO ' . $tabela . ' VALUES ' . $campos; if (mysql_query($query) or die(mysql_error())) { return 1; } else { return 0; } break; case 'DELETE': $numero = array(); $query = $comando . ' FROM ' . $tabela . ' WHERE ' . $criterios; mysql_query($query); if (!mysql_affected_rows()) { return 0; } else { return $numero[mysql_affected_rows()]; } break; } }
<?php session_start(); if (!$_SESSION['login']) { header('Location: ../km/default.asp'); } header('Content-Type: text/html; charset=utf-8'); require_once '../modulos/dao.php'; require_once '../modulos/envia_email.php'; mysqlConnection(); mysql_query("SET NAMES 'utf8'"); mysql_query('SET character_set_connection=utf8'); mysql_query('SET character_set_client=utf8'); mysql_query('SET character_set_results=utf8'); // get the q parameter from URL $nome = $_GET['nome']; $pdv_empresa = $_GET['pdv_empresa']; $desc_empresa = $_GET['desc_empresa']; $desc_regional = $_GET['desc_regional']; $periodicidade = $_GET['periodicidade']; $tipo_empresa = $_REQUEST['cod_tipo_empresa']; $nvl = $_SESSION['nivel_acesso']; /* $campos = "cred.*"; $tabela = "credenciados cred INNER JOIN consultor c ON (c.cod_consultor = cred.cod_consultor)"; $criterios = "cred.pdv = " . $_GET["pdv"]; $row = mysql_fetch_array($consulta_especialista); */ //Lista Consultores $campos = "cod_consultor, nome";
*/ xml_response('true', 'true', 'Success', 'Your form was successfully posted. Thank you.', 'OK'); } else { $login_success = false; if (isset($_SERVER['PHP_AUTH_USER']) && isset($_SERVER['PHP_AUTH_PW'])) { if ($user_name == $_SERVER['PHP_AUTH_USER'] && $password == $_SERVER['PHP_AUTH_PW']) { $login_success = true; } } if ($login_success) { echo '<html>'; echo '<body style="padding:20px;">'; echo '<a href="index.php"><img src="logo.png" alt="FormEntry Logo" width="100" height="100" border="0" /></a>'; if (isset($_GET['db']) && $_GET['db'] == 'mysql') { echo '<h1>FormEntry MySQL</h1>'; mysqlConnection($mysql_host, $mysql_user_name, $mysql_password, $mysql_db_name); $mysql_result_id = mysql_query("SELECT * FROM index"); $mysql_result = array(); while ($row = mysql_fetch_array($mysql_result_id)) { array_push($mysql_result, $row); } if (count($mysql_result) > 0) { echo '<table style="border:1px solid #ccc"><thead style="background:#444;color:#fff;"><tr>'; $i = 0; foreach ($mysql_result as $mysql_head_row) { if ($i < 1) { $j = 0; foreach ($mysql_head_row as $mysql_head_key => $mysql_head_val) { echo $j % 2 ? '<th>' . strtoupper(str_replace("_", " ", $mysql_head_key)) . '</th>' : ''; $j++; }