Meu código para enviar dados no banco não esta funcionado - PHP
Galera, meu codigo para enviar dados ao banco não está funcionando, estou usando php. Ao tentar enviar, aparece isso:
Notice: Array to string conversion in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Undefined variable: recnum_matricula in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Array to string conversion in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Undefined variable: recnome in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Array to string conversion in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Undefined variable: recinstituicao in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Array to string conversion in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Undefined variable: reccurso in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Array to string conversion in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Undefined variable: recperiodo in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Array to string conversion in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Undefined variable: recdata_nasc in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Array to string conversion in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Undefined variable: recvalidade in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Esse é o meu código:
Notice: Array to string conversion in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Undefined variable: recnum_matricula in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Array to string conversion in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Undefined variable: recnome in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Array to string conversion in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Undefined variable: recinstituicao in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Array to string conversion in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Undefined variable: reccurso in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Array to string conversion in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Undefined variable: recperiodo in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Array to string conversion in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Undefined variable: recdata_nasc in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Array to string conversion in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Notice: Undefined variable: recvalidade in C:\\\\\\\\xampp\\\\\\\\htdocs\\\\\\\\site_ame\\\\\\\\grava.php on line 86
Esse é o meu código:
<?php
include ("conexao.php");
session_start ();
$_SESSION [''''$error''''] = null ;
$error = null;
$consulta = mysqli_query($conexao, "SELECT num_matricula FROM form ");
echo $conexao->error;
$usuario = mysqli_fetch_array($consulta);
$_SESSION [''''$recnome''''] = isset( $_POST[ ''''fname'''' ]) ? $_POST[ ''''fname'''' ] : null ;
$_SESSION [''''$recinstituicao''''] = isset( $_POST[ ''''finstituicao'''' ]) ? $_POST[ ''''finstituicao'''' ] : null ;
$_SESSION [''''$reccurso''''] = isset( $_POST[ ''''fcurso'''' ]) ? $_POST[ ''''fcurso'''' ]: null ;
$_SESSION [''''$recperiodo''''] = isset( $_POST[ ''''fperiodo'''' ]) ? $_POST[ ''''fperiodo'''' ]: null ;
$_SESSION [''''$recnum_matricula''''] = isset( $_POST[ ''''fnummatricula'''' ]) ? $_POST[ ''''fnummatricula'''' ]: null ;
$_SESSION [''''$recvalidade''''] = isset( $_POST[ ''''fvalidade'''' ]) ? $_POST[ ''''fvalidade'''' ]: null ;
$_SESSION [''''$recdata_nasc''''] = isset( $_POST[ ''''fdatanasc'''' ]) ? $_POST[ ''''fdatanasc'''' ]: null ;
if ( $_SESSION [''''$recnome''''] == "") :
$error [0] = "Preencha o campo Nome";
endif;
if ($_SESSION [''''$recinstituicao''''] == "") :
$error[1] = "Preencha o campo Instituição";
endif;
if ($_SESSION [''''$reccurso''''] == "") :
$error[2] = "Preencha o campo Curso";
endif;
if ($_SESSION [''''$recperiodo''''] == "") :
$error[3] = "Preencha o campo Período";
endif;
if ($_SESSION [''''$recnum_matricula''''] == "") :
$error[4] = "Preencha o campo Número da Matrícula";
elseif ($_SESSION [''''$recnum_matricula''''] == $usuario[''''num_matricula''''] ):
$error[4] = "Matrícula já cadastrada";
endif;
// Data de nascimento
if ($_SESSION [''''$recdata_nasc''''] == "") :
$error[5] = "Preencha a data de nascimento";
elseif (!preg_match("/^[0-9]-(0[1-9]|1[0-2])-(0[1-9]|[1-2][0-9]|3[0-1])$/", $_SESSION [''''$recdata_nasc''''])) :
$error[5] = "Data de nascimento em formato inválido";
endif;
// Validade
if ($_SESSION [''''$recvalidade''''] == "") :
$error[6] = "Preencha a data de Validade";
elseif (!preg_match("/^[0-9]-(0[1-9]|1[0-2])-(0[1-9]|[1-2][0-9]|3[0-1])$/", $_SESSION [''''$recvalidade''''])) :
$error[6] = "Data de Validade em formato inválido";
endif;
$_SESSION [''''$error''''] = $error;
// Caso não haja nenhum erro
if (($error) == 0) :
mysqli_query ($conexao, "INSERT INTO form (num_matricula, nome, instituicao, curso, periodo, data_nasc, validade_cart) VALUES (''''$_SESSION [''''$recnum_matricula'''']'''','''' $_SESSION [''''$recnome'''']'''', ''''$_SESSION [''''$recinstituicao'''']'''', ''''$_SESSION [''''$reccurso'''']'''',''''$_SESSION [''''$recperiodo'''']'''', ''''$_SESSION [''''$recdata_nasc'''']'''', ''''$_SESSION [''''$recvalidade'''']''''");
elseif (($error) != 0):
print_r ($error);
echo $_SESSION [''''$recdata_nasc''''];
echo $_SESSION [''''$recvalidade''''];
endif;
mysqli_close($conexao);
?>Igorgabrielboeckigor
Curtidas 0
Respostas
Alex William
24/01/2019
Olá,
As variaveis $recnome, $recinstituicao, $reccurso, $recperiodo, $recnum_matricula, $recvalidade, $recdata_nasc não possuem valores nessa pagina.
Quando voce tenta acessar um $_SESSION[$recnome] o PHP tenta acessar $_SESSION[] e avisa que voce esta tentanto setar um valor string em um Array, já que $_SESSION[] é a chamada do Array SESSION.
Atribua valores a estas variaveis, pra ver se funciona ou use o texto direto no nome da variavel, ex:
Ao invez de usar $_SESSION[$recnome] use $_SESSION["recnome"].
Espero ter ajudado. :D
As variaveis $recnome, $recinstituicao, $reccurso, $recperiodo, $recnum_matricula, $recvalidade, $recdata_nasc não possuem valores nessa pagina.
Quando voce tenta acessar um $_SESSION[$recnome] o PHP tenta acessar $_SESSION[] e avisa que voce esta tentanto setar um valor string em um Array, já que $_SESSION[] é a chamada do Array SESSION.
Atribua valores a estas variaveis, pra ver se funciona ou use o texto direto no nome da variavel, ex:
Ao invez de usar $_SESSION[$recnome] use $_SESSION["recnome"].
Espero ter ajudado. :D
GOSTEI 0