将mysql更改为pdo并将结果存储在变量中 [英] change mysql to pdo and store result in variable

问题描述

我如何将mysql代码更改为pdo并将结果存储在variabel中

how can i change mysql code to pdo and store results in variabel

我在index.php内容中使用以下代码:

i use this code in index.php content:

$games_sql = mysql_query("SELECT id,col1,col2,now FROM tblname ORDER BY now ASC LIMIT 9");
$gn=0;
while($game_get=mysql_fetch_array($games_sql))
{
$id = $game_get['id'];
$col1= $game_get['col1'];
$col2= $game_get['col2'];
$now = $game_get['now'];
$gametimeanddate = jdate("l d M y time G:i",$now);
$gamedate = jdate("l d M y",$now);
$gametime = jdate("G:i",$now);
$gn++;
if(($gn%2)==0){
    $class='background-color:#EEE'; , ..... ?>

并使用以下变量:

<?php echo $id;?>&title=<?php echo func1($col1).'-'.func1($col2);?>

和pdo连接包括以下内容:

and pdo connection include content:

$conn = new PDO('mysql:host=localhost;dbname

我想将查询更改为pdo并将查询结果存储为变量，并在php代码中使用

i want change my query to pdo and store query result to variables and use that in php codes

推荐答案

尝试一下:

<?php
$games_sql = "SELECT id,col1,col2,now FROM tblname ORDER BY now ASC LIMIT 9";
$sth = $conn->query($games_sql);
$sth->setFetchMode(PDO::FETCH_ASSOC);

$gn=0;
while ($game_get = $sth->fetch()) {

$id = $game_get['id'];
$col1 = $game_get['col1'];
$col2 = $game_get['col2'];
$now = $game_get['now'];

$gametimeanddate = jdate("l d M y time G:i",$now);
$gamedate = jdate("l d M y",$now);
$gametime = jdate("G:i",$now);

//SAVE VALUES IN ARRAY
$items[] = array('id' => $id, 'col1' => $col1, 'col2' => $col2, 'now' => $now, 'gametimeanddate' => $gametimeanddate, 'gamedate' => $gamedate, 'gametime' => $gametime); 

$gn++;

    if(($gn%2)==0){
        $class='background-color:#EEE';
    }
}
?>

使用数组值示例:

<?php
echo '<table>';
    foreach($items as $value)
    {
        echo '<tr>';
        echo '<td>'. $value['id'] .'</td>';
        echo '<td>'. $value['col1'] .'</td>';
        echo '<td>'. $value['col2'] .'</td>';
        echo '<td>'. $value['gametimeanddate'] .'</td>';
        echo '<td>'. $value['gamedate'] .'</td>';
        echo '<td>'. $value['gametime'] .'</td>';
        echo '</tr>';
    }
echo '</table>';
?>

以您的示例为例:

<?php
foreach($items as $value)
{
    echo $value['id']?>&title=<?php echo func1($value['col1']).'-'.func1($value['col2']);
}
?>

PDO:

一些不错的教程，学习有关PDO的一些基础知识

A couple of nice tutorials to learn some basics about PDO

NetTuts

phpro

您可以将数组值提取为变量.示例:

You could extract your array values to variables. Example:

<?php

$items = array("color" => "blue", "size"  => "medium", "shape" => "sphere");

extract($items);

echo $color;

?>

以您的示例为例，

extract($game_get);

这篇关于将mysql更改为pdo并将结果存储在变量中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！