嗨朋友,我想把这个数据isert到mysql数据库。 [英] Hi friends I am trying to isert this data to mysql database.

查看:98
本文介绍了嗨朋友,我想把这个数据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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆