我有一個(gè)預(yù)訂表格,我成功地將我的數(shù)據(jù)庫連接到我的網(wǎng)站。當(dāng)我在 MYSQL 中轉(zhuǎn)到我的數(shù)據(jù)庫以查看我插入的數(shù)據(jù)時(shí),所有字段都為零。我嘗試更改數(shù)據(jù)庫中數(shù)據(jù)字段的類型,但沒有成功。我的網(wǎng)站與MYSQL數(shù)據(jù)庫的連接:<?php $conexao=mysqli_connect("localhost", "root", "", "sitepap2");?>將表單中插入的數(shù)據(jù)發(fā)送到數(shù)據(jù)庫并檢查數(shù)據(jù)庫中是否已有類似記錄的代碼: <?php include("conecta.php"); $pnome=$_POST['pnome']; $numerotmv=$_POST['numerotmv']; $localsessao=$_POST['localsessao']; $data=$_POST['data']; $hora=$_POST['hora']; $pesquisaUsuario = mysqli_num_rows(mysqli_query($conexao," SELECT nome FROM agendamento WHERE numerotmv = '$numerotmv' ")); if($pesquisaUsuario >0){ echo 1; }else{ mysqli_query($conexao, " insert into agendamento (pnome, numerotmv, localsessao, data, hora) values ('$pnome','$numerotmv', '$localsessao','$data','$hora') "); echo 0; }?>我的數(shù)據(jù)庫結(jié)構(gòu): 數(shù)據(jù)庫當(dāng)我嘗試通過我的 PHP 表單在數(shù)據(jù)庫中插入數(shù)據(jù)時(shí)會發(fā)生什么: 問題感謝所有花時(shí)間閱讀這篇文章來幫助我的人。我很感激。
- 0 回答
- 0 關(guān)注
- 108 瀏覽
添加回答
舉報(bào)
0/150
提交
取消