Кънект към ДБ

mita6ky

Registered
Код:
                $this->fpclass->DB->build_and_exec(array(
                                            'select' => "avatar_location, avatar_type, avatar_size",
                                            'from' => "member_extra",
                                            'where' => "id = '{$mem_id}'",
                                            'limit' => "1",
                ));
                $mextra = $this->fpclass->DB->fetch_row();
        
                # Avatar Size
                $avatarsize = explode("x", $mextra['avatar_size']);
                if($avatarsize[0] > 120)
                {
                     if($avatarsize[0] > $avatarsize[1]) $podebelo = true;
                     if($podebelo)
                    {
                        $avatarsize[0] = 120; $avatarsize[1] = 100;
                    }
                     else
                    {  
                        $avatarsize[0] = 100; $avatarsize[1] = 120;
                    }
                }
        
                if($mextra['avatar_location'])
                  {
                    if($mextra['avatar_type'] == 'upload')
                    {
                        $avatarurl = "<img src='{$this->fpclass->furl}/uploads/{$mextra['avatar_location']}' width='$avatarsize[0]' height='$avatarsize[1]' alt='avatar'>";
                      }
                      elseif($mextra['avatar_type'] == 'url')
                      {
                        $avatarurl = "<img src='".$mextra['avatar_location']."' width=".$avatarsize[0]." height=".$avatarsize[1]." alt='avatar'>";
                      }
                      elseif($mextra['avatar_type'] == 'local')
                      {
                          $avatarurl = "<img src='{$this->fpclass->furl}/style_avatars/{$mextra['avatar_location']}' alt='avatar'>";
                      }
                  }
                  else
                  {
                    $avatarurl = "<img src='templates/skin_{$this->fpclass->init->skin_id}/images/noavatar.gif' alt='avatar'>";
                }
Това е кода искам да се конектне към базата данни а етоя и нея
user: root
pass:1234
dbaneme: forum
+1
 
Код:
$host="localhost";
$dbusername="root";
$dbpassword="1234";
$db="forum";
$db_conn = mysql_connect("$host","$dbusername","$dbpassword") or die("Unable to connect to database!");
mysql_select_db("$db",$db_conn) or die("Unable to select database!");
mysql_query("SET CHARACTER SET cp1251");
                 $this->fpclass->DB->build_and_exec(array(
                                            'select' => "avatar_location, avatar_type, avatar_size",
                                            'from' => "member_extra",
                                            'where' => "id = '{$mem_id}'",
                                            'limit' => "1",
                ));
                $mextra = $this->fpclass->DB->fetch_row();
       
                # Avatar Size
                $avatarsize = explode("x", $mextra['avatar_size']);
                if($avatarsize[0] > 120)
                {
                     if($avatarsize[0] > $avatarsize[1]) $podebelo = true;
                     if($podebelo)
                    {
                        $avatarsize[0] = 120; $avatarsize[1] = 100;
                    }
                     else
                    { 
                        $avatarsize[0] = 100; $avatarsize[1] = 120;
                    }
                }
       
                if($mextra['avatar_location'])
                  {
                    if($mextra['avatar_type'] == 'upload')
                    {
                        $avatarurl = "<img src='{$this->fpclass->furl}/uploads/{$mextra['avatar_location']}' width='$avatarsize[0]' height='$avatarsize[1]' alt='avatar'>";
                      }
                      elseif($mextra['avatar_type'] == 'url')
                      {
                        $avatarurl = "<img src='".$mextra['avatar_location']."' width=".$avatarsize[0]." height=".$avatarsize[1]." alt='avatar'>";
                      }
                      elseif($mextra['avatar_type'] == 'local')
                      {
                          $avatarurl = "<img src='{$this->fpclass->furl}/style_avatars/{$mextra['avatar_location']}' alt='avatar'>";
                      }
                  }
                  else
                  {
                    $avatarurl = "<img src='templates/skin_{$this->fpclass->init->skin_id}/images/noavatar.gif' alt='avatar'>";
                }
Промени си хост може да не ти е localhost :roll:
 

Back
Горе