Re: [phplib] Shared server help for PHPLIB and mySQL From: nathan r. hruby (nathan <email protected>)
Date: 06/26/01

On Mon, 25 Jun 2001, Brant wrote:

> I've added the prepend file as an include to each php
> file and I've modified the include_path in local.inc
> to the appropriate pathway (I hope). Still, I'm getting
> errors related mostly to the database not being set up.
> Are there other workarounds or ways to test PHPLIB that
> don't involve the database?
>

You're on the right track, Make sure that in prepend.php3 the line that
says $_PHPLIB["libdir"] is set to the path (with trailing /) of your
phplib files.

> 2) I cannot create or edit .htaccess files. Boy that would
> make life easy. But they will not do so.
>

Yes, as turning off gpc_magic_quotes would be a nice thing, as well as
enabling track_vars. I think ini_set(0 was mentioned, which would work as
well, provided you're not in a safe_mode environemnt.

> 3) I do not have telnet access to create mysql databases
> and tables. I have a mysql database and I've been able to
> use a poorly functioning phpMyAdmin to create the tables
> but I can't edit them table structure once created. I
> can add, edit and delete records with no problem via php
> and have done so. My "helpful" ISP said that I should be
> able to create/modify tables from a PHP script, but I've
> never done this and don't know how.
>

subclass your database and access it with the subclass:

class MyNewDB extends DB_Sql {
  var $user = ""
  var $database = ""
 ...
}

Then just do stuff like this:
$db = new MyNewDB;
$create_clause = "CREATE TABLE myTable <some table structure>");
$db->query($create_clause);

You'll get an error of your clause is incorrect, I'm not sure what the
return value in php is of a CREATE statement (anyone?) nuw_rows and
affected_rows will return "0". mysql_result may be the answer?

-n 

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
nathan hruby / digital statement
nathan <email protected>
http://www.dstatement.com/

Public GPG key can be found at:
http://www.dstatement.com/nathan-gpg-key.txt
ED54 9A5E 132D BD01 9103  EEF3 E1B9 4738 EC90 801B
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>