Re: part 2 - file exists not working

From	Denis McMahon <denismfmcmahon@gmail.com>
Newsgroups	comp.lang.php
Subject	Re: part 2 - file exists not working
Date	2013-09-24 19:10 +0000
Organization	A noiseless patient Spider
Message-ID	<l1so2u$4ob$3@dont-email.me> (permalink)
References	(3 earlier) <16091ltv3xnv7.h4tb7rm02jdu.dlg@40tude.net> <PHg0u.124791$Fo7.16927@fx19.iad> <2620287.ckb7lz7aL7@PointedEars.de> <awh0u.124795$Fo7.114268@fx19.iad> <1avjnj81i7h58$.tpbaqs9y1nv8.dlg@40tude.net>

Show all headers | View raw

On Tue, 24 Sep 2013 12:17:23 -0400, richard wrote:

> I will change when my host changes.
> As the host is responsible for maintaining the server side, I can't do a
> damn thing until they do.

Have you tested to see if mysqli is available on your host?

If it is, why are you not using it? mysqli is not something that your 
hosting server will expect to announce the roll out of, indeed it's quite 
possible that it's been on the server for several years already.

mysql is the internal php name for the old deprecated set of interface 
functions to the mysql database.
mysqli is the internal php name for a similar but better set of interface 
functions to the mysql database.

It is quite possible for both these sets of interface functions to be 
installed in the same php build. Certainly this is the case in eg PHP 
Version 5.3.10-1ubuntu3.8 on my server.

If you wait until your hosting provider upgrades to a php version that 
obsoletes mysql, then all your php files that use mysql_* functions will 
stop working until you rewrite them to use mysqli.

If you check now and discover that yes, your server does in fact also 
support mysqli_* functions already, then you can start migrating your 
code from mysql_* functions to mysqli_* functions now so that you won't 
get caught out in a future upgrade.

Note that checking doesn't mean you look to see if the database has 
changed from mysql to mysqli, because that's not what happens. Checking 
means creating a page called something like sysinfo.php that contains the 
following code:

<?php
phpinfo();

and then putting that page in your website, and then going to the url:

http://your_website_name_here/sysinfo.php

Then scroll down the output until you come to the mysqli section. The 
presence of this section means that the mysqli interface modules are 
installed in the servers php code.

Hostgator support PHP 5, so their PHP build includes mysqli_* functions. 
The only thing stopping you using mysqli_* functions instead of mysql_* 
functions is *YOU*!

-- 
Denis McMahon, denismfmcmahon@gmail.com

Thread

part 2 - file exists not working richard <noreply@example.com> - 2013-09-23 10:04 -0400
  Re: part 2 - file exists not working Tim Streater <timstreater@greenbee.net> - 2013-09-23 15:17 +0100
    Re: part 2 - file exists not working richard <noreply@example.com> - 2013-09-23 10:35 -0400
  Re: part 2 - file exists not working Paul Herber <paul@pherber.com> - 2013-09-23 15:33 +0100
  Re: part 2 - file exists not working David Robley <me@home.invalid> - 2013-09-24 10:16 +0930
    Re: part 2 - file exists not working Lew Pitcher <lew.pitcher@digitalfreehold.ca> - 2013-09-23 22:07 -0400
      Re: part 2 - file exists not working richard <noreply@example.com> - 2013-09-24 01:57 -0400
        Re: part 2 - file exists not working David Robley <me@home.invalid> - 2013-09-24 17:19 +0930
          Re: part 2 - file exists not working richard <noreply@example.com> - 2013-09-24 04:10 -0400
          Re: part 2 - file exists not working richard <noreply@example.com> - 2013-09-24 04:32 -0400
          Re: part 2 - file exists not working Doug Miller <doug_at_milmac_dot_com@example.com> - 2013-09-24 23:23 +0000
            Re: part 2 - file exists not working David Robley <me@home.invalid> - 2013-09-25 09:48 +0930
        Re: part 2 - file exists not working Lew Pitcher <lew.pitcher@digitalfreehold.ca> - 2013-09-24 09:45 -0400
          Re: part 2 - file exists not working Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2013-09-24 16:34 +0200
            Re: part 2 - file exists not working Lew Pitcher <lew.pitcher@digitalfreehold.ca> - 2013-09-24 10:41 -0400
              Re: part 2 - file exists not working richard <noreply@example.com> - 2013-09-24 12:17 -0400
                Re: part 2 - file exists not working Richard Yates <richard@yatesguitar.com> - 2013-09-24 09:29 -0700
                Re: part 2 - file exists not working Twayne <nobody@spamcop.net> - 2013-09-24 18:51 -0400
                Re: part 2 - file exists not working Denis McMahon <denismfmcmahon@gmail.com> - 2013-09-24 19:10 +0000
                Re: part 2 - file exists not working Twayne <nobody@spamcop.net> - 2013-09-24 19:08 -0400
                Re: part 2 - file exists not working Richard Yates <richard@yatesguitar.com> - 2013-09-24 18:39 -0700
                Re: part 2 - file exists not working "Peter H. Coffin" <hellsop@ninehells.com> - 2013-09-24 22:17 -0500
                Re: part 2 - file exists not working Twayne <nobody@spamcop.net> - 2013-09-26 17:20 -0400
                Re: part 2 - file exists not working Richard Yates <richard@yatesguitar.com> - 2013-09-26 15:43 -0700
                Re: part 2 - file exists not working Jerry Stuckle <jstucklex@attglobal.net> - 2013-09-26 19:43 -0400
                Re: part 2 - file exists not working Scott Johnson <noonehome@chalupasworld.com> - 2013-09-24 18:54 -0700
                Re: part 2 - file exists not working Twayne <nobody@spamcop.net> - 2013-09-26 17:39 -0400
                Re: part 2 - file exists not working Richard Yates <richard@yatesguitar.com> - 2013-09-26 15:47 -0700
                Re: part 2 - file exists not working Twayne <nobody@spamcop.net> - 2013-09-28 13:58 -0400
                Re: part 2 - file exists not working Richard Yates <richard@yatesguitar.com> - 2013-09-28 11:45 -0700
                Re: part 2 - file exists not working Tim Streater <timstreater@greenbee.net> - 2013-09-25 09:01 +0100
              Re: part 2 - file exists not working Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2013-09-24 18:54 +0200
                Re: part 2 - file exists not working Tim Streater <timstreater@greenbee.net> - 2013-09-24 18:30 +0100
              Re: part 2 - file exists not working Scott Johnson <noonehome@chalupasworld.com> - 2013-09-24 15:40 -0700
                Re: part 2 - file exists not working Twayne <nobody@spamcop.net> - 2013-09-24 19:14 -0400
                Re: part 2 - file exists not working Richard Yates <richard@yatesguitar.com> - 2013-09-24 18:43 -0700
                Re: part 2 - file exists not working Twayne <nobody@spamcop.net> - 2013-09-26 17:42 -0400
              Re: part 2 - file exists not working Twayne <nobody@spamcop.net> - 2013-09-24 18:50 -0400
                Re: part 2 - file exists not working Scott Johnson <noonehome@chalupasworld.com> - 2013-09-24 18:56 -0700
                Re: part 2 - file exists not working Curtis Dyer <dyer85@gmail.com> - 2013-09-26 06:01 +0000
                Re: part 2 - file exists not working Twayne <nobody@spamcop.net> - 2013-09-26 18:04 -0400
                Re: part 2 - file exists not working Curtis Dyer <dyer85@gmail.com> - 2013-09-27 01:47 +0000
                Re: part 2 - file exists not working Jerry Stuckle <jstucklex@attglobal.net> - 2013-09-26 22:56 -0400
                Re: part 2 - file exists not working Richard Yates <richard@yatesguitar.com> - 2013-09-26 20:11 -0700
                Re: part 2 - file exists not working Jerry Stuckle <jstucklex@attglobal.net> - 2013-09-26 23:41 -0400
                Re: part 2 - file exists not working Curtis Dyer <dyer85@gmail.com> - 2013-09-27 06:04 +0000
                OT Re: part 2 - file exists not working Twayne <nobody@spamcop.net> - 2013-09-28 14:33 -0400
                Re: OT Re: part 2 - file exists not working Fiver <numeralfive@gmail.com> - 2013-09-28 23:12 +0200
                Re: OT Re: part 2 - file exists not working The Natural Philosopher <tnp@invalid.invalid> - 2013-09-29 06:50 +0100
                Re: OT Re: part 2 - file exists not working "Peter H. Coffin" <hellsop@ninehells.com> - 2013-09-29 10:39 -0500
                Re: OT Re: part 2 - file exists not working Jerry Stuckle <jstucklex@attglobal.net> - 2013-09-29 14:49 -0400
  Re: part 2 - file exists not working Doug Miller <doug_at_milmac_dot_com@example.com> - 2013-09-24 23:20 +0000
    Re: part 2 - file exists not working Richard Yates <richard@yatesguitar.com> - 2013-09-24 18:46 -0700
    Re: part 2 - file exists not working richard <noreply@example.com> - 2013-09-24 22:27 -0400
      Re: part 2 - file exists not working The Natural Philosopher <tnp@invalid.invalid> - 2013-09-25 06:21 +0100
      Re: part 2 - file exists not working David Robley <me@home.invalid> - 2013-09-25 15:20 +0930
        Re: part 2 - file exists not working Doug Miller <doug_at_milmac_dot_com@example.com> - 2013-09-26 20:30 +0000
    Re: part 2 - file exists not working Denis McMahon <denismfmcmahon@gmail.com> - 2013-09-25 07:42 +0000
      Re: part 2 - file exists not working The Natural Philosopher <tnp@invalid.invalid> - 2013-09-25 09:07 +0100
        Re: part 2 - file exists not working Richard Yates <richard@yatesguitar.com> - 2013-09-25 06:29 -0700
          Re: part 2 - file exists not working The Natural Philosopher <tnp@invalid.invalid> - 2013-09-25 15:09 +0100

csiph-web