Msql转msqli转换工具？ [英] Msql to msqli conversion tool?

问题描述

您好我需要将所有msql迁移到msqli代码。什么软件会转换？



我尝试过：

<？php 
 session_start（）; 
 require（header.php）; 
 require（checkUser.php）; 
？> 
<？php 
 echo< h1> My Answer< / h1>; 
 $ sql =SELECT * from answer，question where answer.user_id = $ _ SESSION [uid] and answer.question_id = question.question_id; 
 $ result = ExecuteQuery（$ sql）; 
 
 while（$ row = mysqli_fetch_array（$ result））
 {
 echo< span class ='box2'>; 
 echo< span class ='head'>< a href ='questionview.php？qid = $ row [question_id]'>< h4> $ row [heading]< / h4> < / A>< /跨度>中; 
 echo< / span>; 
 echo< br />; 
 
 
 
 echo $ row ['answer_detail']; 
 echo< br />; 
 
 
 echo $ row ['datetime']; 
 echo< br />; 
 echo< div class = line>< / div>; 
} 
 
 
？> 
<？php require（footer.php）;？> 

解决方案

sql =SELECT * from回答，问题在哪里answer.user_id =

_SESSION [uid]和answer.question_id = question.question_id;

result = ExecuteQuery（

Hi i need to migrate all msql to msqli codes. what software that will convert?

What I have tried:

<?php 
	session_start();
	require("header.php");
	require("checkUser.php");
?>
<?php
	echo "<h1>My Answer</h1>";
$sql="SELECT * from  answer,question where answer.user_id=$_SESSION[uid] and answer.question_id=question.question_id";
$result=ExecuteQuery($sql);

		while($row = mysqli_fetch_array($result))
		{
		echo "<span class='box2'>";	
		echo "<span class='head'><a href='questionview.php?qid=$row[question_id]'><h4>$row[heading]</h4></a></span>";
		echo "</span>";
		echo  "<br/>";
		
		
		
		echo $row['answer_detail'];
		echo  "<br/>";
		
		
		echo $row['datetime'];
		echo  "<br/>";
		echo "<div class=line></div>";
		}
	

?>
<?php require("footer.php");?>

解决方案

sql="SELECT * from answer,question where answer.user_id=

_SESSION[uid] and answer.question_id=question.question_id";

result=ExecuteQuery(

这篇关于Msql转msqli转换工具？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！