我想要两个相等的变量

Question

fetching some data from mysqli

$value=mysqli_fetch_assoc($query)

I have a result like

$value = "123456789101112131415161718192021222324252627282930";

but I want to use it two variables like

$value1 = "123456789101112131415";
$value2 = "161718192021222324252627282930";

Answer 1

Use the database column names. If you don't have the value you need in separate database column you have to somehow extract the value from an existing column. You can use substr or regex to do so.

<?php while($row = mysqli_fetch_assoc($result)) { ?>
<tr>
    <td><?php echo $row['DATABASE_COLUMN_1_NAME']; ?></td>
    <td><?php echo $row['DATABASE_COLUMN_2_NAME']; ?></td>
    <td><?php echo $row['DATABASE_COLUMN_3_NAME']; ?></td>
    <!-- show only a part of the db columns content -->
    <?php $valueIwantToShow = subtr($row['DATABASE_COLUMN_4_NAME'], 0, 5); ?>
    <td><?php echo valueIwantToShow; ?></td>
    <!-- or show multiple values in one html column -->
    <td><?php echo $row['DATABASE_COLUMN_6_NAME']; ?>, <?php echo $row['DATABASE_COLUMN_7_NAME']; ?></td>
</tr>
<?php } ?>