Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

weinhexe

Members
  • Posts

    25
  • Joined

  • Last visited

Reputation Activity

  1. Like
    weinhexe reacted to De Dokta in [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo   
    Very friendly of Hildegard that she has posted my approach here. But she has overlooked a correction which I have added in the German Forum.
    The last two functions should correctly rather be like this:
     

    * Function to fetch the last insertID * @[member='author'] Bobby Easland * @version 1.0 * @[member='Return'] integer */ function InsertID() { return mysqli_insert_id($this->link_id); } /** * Function to free the resource * @[member='author'] Bobby Easland * @version 1.0 * @[member='param'] resource $resource_id * @[member='Return'] boolean */ function Free($resource_id){ return mysqli_free_result($resource_id); } # end function
     
    Regards
    J.J.
  2. Like
    weinhexe got a reaction from Mort-lemur in [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo   
    Hello,
     
    De Dokta, a member of the German osc support forum rewrote a part of the seo.class.php:
     
    Lines 63 - 156:
     

    function SEO_DataBase($host, $user, $db, $pass){ $this->host = $host; $this->user = $user; $this->db = $db; $this->pass = $pass; $this->ConnectDB(); //// $this->SelectDB(); } # end function /** * Function to connect to MySQL * @[member='author'] Bobby Easland * @version 1.1 */ function ConnectDB(){ $this->link_id = mysqli_connect($this->host, $this->user, $this->pass, $this->db); if (!$this->link_id) { die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); } } # end function /** * Function to select the database * @[member='author'] Bobby Easland * @version 1.0 * @[member='Return'] resoource * function SelectDB(){ return mysqli_select_db($this->link_id, $this->db); } # end function /** * Function to perform queries * @[member='author'] Bobby Easland * @version 1.0 * @[member='param'] string $query SQL statement * @[member='Return'] resource */ function Query($query){ $result = mysqli_query($this->link_id, $query); return $result; } # end function /** * Function to fetch array * @[member='author'] Bobby Easland * @version 1.0 * @[member='param'] resource $resource_id * @[member='param'] string $type MYSQL_BOTH or MYSQL_ASSOC * @[member='Return'] array */ function FetchArray($resource_id, $type = MYSQL_BOTH){ if ($resource_id) { $result = mysqli_fetch_array($resource_id, $type); return $result; } return false; } # end function /** * Function to fetch the number of rows * @[member='author'] Bobby Easland * @version 1.0 * @[member='param'] resource $resource_id * @[member='Return'] mixed */ function NumRows($resource_id){ return @mysqli_num_rows($resource_id); } # end function /** * Function to fetch the last insertID * @[member='author'] Bobby Easland * @version 1.0 * @[member='Return'] integer */ function InsertID() { return mysqli_insert_id(); } /** * Function to free the resource * @[member='author'] Bobby Easland * @version 1.0 * @[member='param'] resource $resource_id * @[member='Return'] boolean */ function Free($resource_id){ return @mysqli_free_result($resource_id); } # end function
     
    De Dokta tested his modification on php 5.4, I tested it on php 5.5 and it seems to work correctly.
     
    Regards
    weinhexe
×
×
  • Create New...