dsjzmrz78089 2017-05-13 12:28
浏览 41
已采纳

Mysql到Mysqli数据库连接

I need to migrate my code from mysql to mysqli. I am new with coding so probably the mistake I am doing is really silly but please help me.

<?php
  $host="localhost"; // Host name
  $db_username="koko_login"; // Mysql username
  $db_password="YES"; // Mysql password
  $db_name="koko_database"; // Database name
  $tbl_name="members"; // Table name

  // Connect to server and select databse.
  // mysql_connect("$host", "$db_username", "$db_password")or die("cannot connect");
  // mysql_select_db("$db_name")or die("cannot select DB");

  $connection = mysqli_connect( 'host', 'username', 'password');
  $database = mysqli_select_db($link, 'database');


  if (isset($_SESSION['username'])){
      $username = $_SESSION['username'];
      $password = $_SESSION['username'];
  }

  function generate_event_link($tbl_name, $username, $key)
  {
    $sql="SELECT * FROM $tbl_name WHERE username='$username'";
    $result=mysqli_query( $link, $query);
    $count=mysqli_num_rows( $result);
    $arr = mysqli_fetch_array( $result, $type);
    if ($arr[$key] != 0){
    $href= "http://localhost/koko/event_page.php?id=" . $arr[$key]; ?>
    <li class="divider"></li>
    <li><a href=<? echo $href ?>"#">Your Event<img class="img responsive pull-right" src="icons/house.png" alt="User"></a></li>
    <?}}
?>
  • 写回答

3条回答 默认 最新

  • douyu7879 2017-05-14 10:03
    关注

    Agreed with RiggsFolly, but notice variable $type is not defined anywhere and can also be removed

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 本题的答案是不是有问题
  • ¥15 关于#r语言#的问题:(svydesign)为什么在一个大的数据集中抽取了一个小数据集
  • ¥15 C++使用Gunplot
  • ¥15 这个电路是如何实现路灯控制器的,原理是什么,怎么求解灯亮起后熄灭的时间如图?
  • ¥15 matlab数字图像处理频率域滤波
  • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
  • ¥15 ELGamal和paillier计算效率谁快?
  • ¥15 蓝桥杯单片机第十三届第一场,整点继电器吸合,5s后断开出现了问题
  • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?
  • ¥15 Arcgis相交分析无法绘制一个或多个图形