Profile cover photo
Profile photo
nguyễn hồng khanh
40 followers
40 followers
About
Posts

MultCloud(https://www.multcloud.com/), a FREE and easy-to-use web app, supports for Managing Files and Transferring Files across Cloud Drives. Free provide 10TB traffic for data transmission.
Add a comment...

hôm nay báo cáo đề tài rồi! hy vọng vượt qua được tối nay :)
Add a comment...

Post has attachment
Add a comment...

Post has attachment
Add a comment...

Post has attachment
Add a comment...

Class kết nối mysql
<?php
                        /*************
                        class name:mysql
                        description:database abstraction class
                        purpose:to connect to mysql database and simplify sql queries
                        author name: ashwin morey
                        created on: 20/10/2005
                        modified by:
                        modified on:
                        methods used:database(constructor),connect(),query(),num_rows(),movenext(),getfield, getinsertID
                        ************/
    class database{
        //stores hostname or the server name
        var $hostName;
        //username for the database
        var $userName;
        //password for the database
        var $password;
        //database name
        var $dbName;
        //stores connection id
        var $conn;
        //stores the resource ID for the sql query
        var $rs;
        //stores properties of the record corresponding to that column
        var $record;
        //returns number of records returned by the sql query
        var $num;
        //returns the id of the latest inserted record
        var $latestID;
        /**************************
        function name:mysql(constructor)
        description:constructor
        purpose:to set values for the variables, calls up the connect method()
        arguments:hostName, dbName, $userName, $password
        returns:nothing
        *********************************/
        function database(){
            //parse the ini file here and assign values to the variables
            $ini = parse_ini_file("web.ini");
            while(list($key,$value) = each($ini)){
                if($key == 'hostName'){
                    $hostName = $value;
                }
                else if($key == 'userName'){
                    $userName = $value;
                }
                else if($key == 'password'){
                    $password = $value;
                }
                else if($key == 'dbName'){
                    $dbName = $value;
                }
            }
            $this->hostName = $hostName;
            $this->userName = $userName;
            $this->password = $password;
            $this->dbName = $dbName;
            $this->connect();
        }
        
        /***************************
        function name:connect()
        description:open a connection to mysql
        purpose:to open a connection to mysql database and select the database
        arguments:nothing
        returns:connection ID
        ****************************/
        function connect(){
            $this->conn =@mysql_pconnect($this->hostName,$this->username,$this->password)
            or die("Connection to the server failed");
            //select the database
           @mysql_select_db($this->dbName)
            or die("No such database exist");
            return $this->conn;
        }

        /**************************
        function name:query()
        description:pass sql query to the database
        purpose:to execute sql query
        arguments:$sql(sql query)
        returns:resource ID
        ***************************/
        function query($sql){
            $this->rs =@mysql_query($sql,$this->conn)
            or die("There is error in the sql query");
            return $this->rs;
        }

        /**************************
        function name:num_rows
        description:gives numbers of rows
        purpose:gives number of rows returned by sql query
        arguments:nothing
        returns:number of rows
        ***************************/
        function num_rows(){
            $num =@mysql_num_rows($this->rs);
            return $num;
        }

        /***************************
        function name:movenext()
        description:navigate the database
        purpose:to fetch an object with properties that correspond to the fetched row
        arguments:nothing
        returns:returns an object with properties of the fetched row
        ***************************/
        function movenext(){
            $this->record =@mysql_fetch_object($this->rs);
            return $this->record;
        }
        
        /**************************
        function name:getfield()
        description:retrieves the field value
        purpose:to get the field value corresponding to that record
        arguments:nothing
        returns:field value corresponding to that record
        **************************/
        function getfield($field){
            return $this->record->$field;
        }

        /**************************
        function name:getinsertID()
        description:retrieves the latest ID
        purpose:to get the ID of the latest inserted record
        (works only with auto increment fields of the database)
        arguments:nothing
        returns:ID of the latest inserted record
        ***************************/
        function getinsertID(){
          $this->latestID =@mysql_insert_id($this->conn);
          return $this->latestID;
        }
        
        /********************
        function name:close()
        description:close the connection
        purpose:to close connection with mysql database
        arguments:nothing
        returns:true or false (boolean value)
        *********************/
        function close(){
          return @mysql_close($this->conn);
        }
    } 

If water were kisses, I’d send you the sea
If leaves were hugs, I’d send you a tree
If nite was love ,I’d send you the stars
But I can’t send u my heart cause that where you are
Add a comment...

cuộc đời không như ta từng ước mơ. phải trải qua nhiều sóng gió mới biết nó quý như thế nào :)
Add a comment...

CI sắp xong phần cơ bản rồi! kakaka
Add a comment...

Post has attachment
Google Drive
Google Drive
drive.google.com
Add a comment...
Wait while more posts are being loaded