dsfsdfsd34324 2014-05-20 18:29
浏览 36
已采纳

使用codeigniter从数据库中检索单词

I have recently started using codeigniter and I am a bit stuck as it is all rather new to me.

I use to have a config file with database conection and this on it:

$qset = "select * from re_settings";
$rset = mysql_query($qset) or die(mysql_error());
$aset = mysql_fetch_array($rset);

and this would allow me to pull words from database by simply putting this on the site

<?=$aset['SiteTitle']?>

How can I do this in codeigniter? Do I need to have a controller to do this or is it something much simpler than that.

  • 写回答

2条回答 默认 最新

  • dtng5978 2014-05-20 18:42
    关注

    You'll need to become familiar with the concepts of MCV which is how Codeigniter is built on and your ORM framework.

    There's a bunch of helpful resources on http://tutorialcodeigniter.com/ or the official docs http://ellislab.com/codeigniter/user-guide/database/examples.html

    as an example

    $query = $this->db->query('SELECT name, title, email FROM my_table');
    
    foreach ($query->result_array() as $row)
    {
        echo $row['title'];
        echo $row['name'];
        echo $row['email'];
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 拟通过pc下指令到安卓系统,如果追求响应速度,尽可能无延迟,是不是用安卓模拟器会优于实体的安卓手机?如果是,可以快多少毫秒?
  • ¥20 神经网络Sequential name=sequential, built=False
  • ¥16 Qphython 用xlrd读取excel报错
  • ¥15 单片机学习顺序问题!!
  • ¥15 ikuai客户端多拨vpn,重启总是有个别重拨不上
  • ¥20 关于#anlogic#sdram#的问题,如何解决?(关键词-performance)
  • ¥15 相敏解调 matlab
  • ¥15 求lingo代码和思路
  • ¥15 公交车和无人机协同运输
  • ¥15 stm32代码移植没反应