嗨朋友,我想把这个数据isert到mysql数据库。 [英] Hi friends I am trying to isert this data to mysql database.
本文介绍了嗨朋友,我想把这个数据isert到mysql数据库。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨朋友们我想把这个数据输入mysql数据库。但是我无法完成这项任务,因为我不知道发生了什么。
我尝试了什么:
Hi friends I am trying to isert this data to mysql database. However I cannot get this done because I do not know what is happening.
What I have tried:
<!doctype html>
<meta charset="utf-8">
<title>Untitled Document
<div id="wrapper">
<div class="box-header">
<h2>NEW USER</h2>
</div>
information
<div class="input-group">
<div class="input-group-addon">
</div>
</div>
<div class="input-group">
</div>
</div>
<div class="input-group">
<div class="input-group-addon">
</div>
</div>
<div class="input-group">
<div class="input-group-addon">
</div>
Albania
Algeria
</div>
<div class="input-group space">
<div class="input-group-addon">
</div>
</div>
<div class="input-group space">
</div>
<div class="input-group space">
<div class="input-group-addon">
AGE
</div>
Year(s)
Month(s)
Day(s)
</div>
<div class="form-group space">
Gender:
Male
Female
</div>
Problem
visit
<?php
$query = "SELECT * from P_table";
$result = mysqli_query($con, $query);
?>
Please select
<?php
while ($row= mysqli_fetch_assoc($result)) {
$id = $row['u_id'];
$vist_to = $row['visit_to'];
?>
<?php echo $vist_to;?>
<?php } ?>
Doctor:
Doctor Name
Dr.Henry
Dr.Menro
<div class="input-group">
Fees:
<div class="input-group">
</div>
</div>
<!-- Date and time range -->
<div class="form-group">
Date and time
<div class="input-group">
<div class="input-group-addon">
</div>
</div>
<!-- /.input group -->
</div>
<!-- /.form group -->
<div class="clear"></div>
<div class="clear"></div>
<!--End of wrapper-->
?php
if(isset($_POST['submit']))
{
$name = $_POST['name'];
$f_name = $_POST['f_name'];
$phone_no = $_POST['phone_no'];
$country = $_POST['country'];
$city = $_POST['city'];
$add = $_POST['full_add'];
$age = $_POST['age'];
$age_sc = $_POST['age_sc'];
$gender = $_POST['gender'];
$prob = $_POST['problem'];
$visit = $_POST['visit'];
$doct = $_POST['doc'];
$fee = $_POST['fee'];
$crncy = $_POST['crncy'];
$a_date = $_POST['date'];
$insert = "insert into new_table (name,f_name,contact,country,city,address,age,age_sc,gender,problem,visit,doc,fee,currency,date,c_date) values('$name','$f_name','$phone_no','$country','$city','$add','$age','$age_sc','$gender','$prob','$doct','$fee','$crncy','$a_date',NOW())";
$qur = mysqli_query($con, $insert);
if($qur)
{
echo"alert('Added Successfully')";
echo"window.open('index.php','_self')";
}
else{
echo "<h2>Data not inserted </h2>";
}
}
?>
推荐答案
查询 = SELECT * from P_table;
query = "SELECT * from P_table";
result = mysqli_query(
result = mysqli_query(
con,
这篇关于嗨朋友,我想把这个数据isert到mysql数据库。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文