//Gravando os dados include("/var/conn/conn_sisinfo.php"); $conexao = mysql_connect($GLOBALS["bd_servidor"], $GLOBALS["bd_usuario"], $GLOBALS["bd_senha"]) or die("Não pude conectar: " . mysql_error()); mysql_select_db($GLOBALS["bd_base"]) or die("Não pude selecionar o banco de dados"); //verifica se as inscricoes excedem 150 participantes //Verifica se email já se encontra inscrito $sql = "SELECT * FROM fapesp_ama WHERE deleted IS NULL"; $con = mysql_query($sql) or die("SQL inválida: ".$sql); $num_inscritos = mysql_num_rows($con); if($_SERVER['REQUEST_METHOD']=='POST'){ //Se o formulario foi submetido ... $data = date("Y-m-d H:i:s"); //Verifica se email já se encontra inscrito $sql = "SELECT * FROM fapesp_ama WHERE email='".$_POST["email"]."'"; $con = mysql_query($sql) or die("SQL inválida: ".$sql); $res = mysql_fetch_array($con); if(mysql_num_rows($con)>0) { $sql = "UPDATE sisinfo.fapesp_ama SET cpf='".$_POST["cpf"]."', name='".$_POST["name"]."', phone='".$_POST["phone"]."', institution='".$_POST["institution"]."', occupation='".$_POST["occupation"]."', city='".$_POST["city"]."', country='".$_POST["country"]."', date_saved='".$data."' WHERE email='".$_POST["email"]."'"; } else { $sql = "INSERT INTO sisinfo.fapesp_ama (cpf, name, email, phone, institution, occupation, city, country, date_saved) VALUES ('".$_POST["cpf"]."', '".$_POST["name"]."', '".$_POST["email"]."', '".$_POST["phone"]."', '".$_POST["institution"]."', '".$_POST["occupation"]."', '".$_POST["city"]."', '".$_POST["country"]."', '".$data."')"; } //echo $insere; die; mysql_query($sql) or die("SQL inválida: ".$sql); //Envia e-mail de confirmação (usando configurações do SisPROPe) include_once("../../sisprope/includes/config.inc.php"); include_once('../../includes/phpmailer/class.phpmailer.php'); $sql_conf = "SELECT * FROM config WHERE id_config = 1"; $resp_conf = mysql_query($sql_conf); $conf = mysql_fetch_array($resp_conf); $mail = new PHPMailer(); $html = "Confirmação de cadastro no Workshop: Progress on alternative in vitro methods for the safety assessment of chemicals and their impact on human health: international and brazilian views. Seus Dados: CPF : ".$_POST['cpf']." Nome : ".$_POST['name']." E-mail : ".$_POST['email']." Telefone: ".$_POST['phone']." Instituição: ".$_POST['institution']." Ocupação: ".$_POST['occupation']." Cidade: ".$_POST['city']." País: ".$_POST['country']; $mail->CharSet = "iso-8859-1"; $mail->From = $conf["smtp_email_remetente"]; $mail->FromName = "Workshop"; $mail->Mailer = "smtp"; $mail->Subject = "Confirmação de Cadastro"; $mail->IsSMTP(); // set mailer to use SMTP $mail->Host = $conf["smtp_servidor"]; // specify main and backup server $mail->SMTPAuth = true; // turn on SMTP authentication $mail->Username = $conf["smtp_login_remetente"]; // SMTP username $mail->Password = des($conf["smtp_senha_remetente"]); // SMTP password $mail->Body = $html; $mail->AddAddress($email); //$mail->AddAddress("andre@fosjc.unesp.br"); if($mail->Send()) { $mail->ClearAddresses(); $mail->ClearAttachments(); } else { echo $mail->ErrorInfo; die; } } ?>
|
|
Progress on alternative in vitro methods for the safety assessment of chemicals and their impact on human health: international and Brazilian views
Maria José S. M Giannini – PROPe-UNESP Lorena R. Gaspar Cordeiro – FCFRP-USP Silvya Stuchi Maria-Engler – FCF-USP Suely Vilela – FCFRP-USP ![]() |
||||||||||||||||||||||||||||||