从数据库中获取后，php mysqli数据无法正确回显 [英] php mysqli data can't properly echo after fetching from database

问题描述

在我的数据库中，逗号的数据很少. 首先，请注意我的数据库表.

In my database I have few data with comma . At first please watch my DATABASE TABLE .

现在是我想在帐单上单行提取并回显数据. 请观看帐单用户界面 例如:- pizza abc 230 70 40 7000 1 6930 将在第一行回显，然后 cake pnd 144 842 80 400 3 385 将在第二行回显

and now I want to fetch and echo data IN A SINGLE LINE on the bill . Please watch the bill UI Example:- pizza abc 230 70 40 7000 1 6930 will echo on 1st line and then also cake pnd 144 842 80 400 3 385 will echo in 2nd line

，此过程将使用循环完成，以使表行动态增加和减少.]

and this process will do complete using loop to make table rows increment ad decrement dynamically .]

推荐答案

explode()函数将字符串分成数组.

The explode() function breaks a string into an array.

注意:"separator"参数不能为空字符串.

Note: The "separator" parameter cannot be an empty string.

示例:

<?php

    $product_type = explode(',',"pizza,cake,biscuit,noodles");
    $product_name = explode(',',"abc,pnd,bun,dgj");
    $produ_cartoo_quantity=explode(',',"230,144,878,906");
    $produ_cartoo_weight=explode(',',"70,842,612,794");

    for($i=0;$i<count($product_type);$i++)
    {
        echo $product_type[$i]." ";
        echo $product_name[$i]." ";
        echo $produ_cartoo_quantity[$i]." ";
        echo $produ_cartoo_weight[$i]."<br>";

    }

?>

输出:

pizza abc 230 70
cake pnd 144 842
biscuit bun 878 612
noodles dgj 906 794

这篇关于从数据库中获取后，php mysqli数据无法正确回显的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！