肥皂起泡泡
<?phprequire "conn.php";$FSC = $_POST["FSC"];$PART_NUMBER = $_POST["NIIN"];$mysql_qry_1 = "select * from MyTable where PART_NUMBER like '$PART_NUMBER';";$result_1 = mysqli_query($conn ,$mysql_qry_1);if(mysqli_num_rows($result_1) > 0) { $row = mysqli_fetch_assoc($result_1); $PART_NUMBER = $row["PART_NUMBER"]; $FSC = $row["FSC"]; $NIIN = $row["NIIN"]; $ITEM_NAME = $row["ITEM_NAME"]; echo $ITEM_NAME, ",>" .$PART_NUMBER, ",>" .$FSC, "" .$NIIN;//usage stats $sql = "INSERT INTO USAGE_STATS (ITEM_NAME, FSC, NIIN, PART_NUMBER)VALUES ('$ITEM_NAME', '$FSC', '$NIIN', '$PART_NUMBER')";if ($conn->query($sql) === TRUE) { $row = mysqli_insert_id($conn);} else { //do nothing}//} else { echo "NO RESULT CHECK TO ENSURE CORRECT PART NUMBER WAS ENTERED ,> | ,>0000000000000";}$mysql_qry_2 = "select * from MYTAB where FSC like '$FSC' and NIIN like '$NIIN';";$result_2 = mysqli_query($conn ,$mysql_qry_2);if(mysqli_num_rows($result_2) > 0) { $row = mysqli_fetch_assoc($result_2); $AD_PART_NUMBER = $row["PART_NUMBER"]; if(mysqli_num_rows($result_2) > 1){ echo ",>"; while($row = mysqli_fetch_assoc($result_2)) { $AD_PART_NUMBER = $row["PART_NUMBER"]; echo $AD_PART_NUMBER, ", "; } } else { echo ",> | NO ADDITIONAL INFO FOUND | "; }} else { echo ",> | NO ADDITIONAL INFO FOUND | ";}mysqli_close($con);?>所以我的问题是如何利用我拥有的可用资源提高读取速度,或者我当前的 PHP 文档是否存在导致此处瓶颈的问题?