I have 2 seperate scripts. On useing PEAR::DB and the other using
mysql_connect.
mysql_connect works and PEAR::DB does not.
This is what I have...
the 'mysql_connect' script...
$db_host = 'myHost';
$db_user = 'myUser';
$db_pass = 'myPass';
$db_name = 'myDB';
$link =
My include path was messed up
AND
the sys admin changed the password on me!
Thanks anyway.
walter
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
This is the soBig virus!
Do not open attachement!
Do not open attachement!
Some SMTP servers bounce entire messages, even with attachements!
I hope the admin in here can remove this message from the server and NNTP
server so other do not get catch opening this!
Walter
--
PHP Database
This is the soBig virus!
Do not open attachement!
Do not open attachement!
Some SMTP servers bounce entire messages, even with attachements!
I hope the admin in here can remove this message from the server and NNTP
server so other do not get catch opening this!
Walter
--
PHP Database
I am querying a database just fine.
Getting back what I expect, just fine.
But now I've been thrown a wrench in the form of double row display.
my client wants...
a b
c d
e f
...
Well, I've reached the end on my PHP/SQL knowledge (which really isn't all
that far!)
Right
This is the SoBig.F virus.
It hijacks a random email address form an infected persons phone book, uses
that address as the SENDER, and then proceeds to mail out copies of itself
to everyone in he infected persons phone book.
I've had my address hijacked twice now.
So, be warned, clean your
Boaz Yahav [EMAIL PROTECTED] wrote in message
I'm not sure i understand the problem.
a,c,e come from one query result and b,d,f from another?
No, they all come from the same table, but the same field name but from
different rows of the database.
If it's all from the same query why not do :
This is what I use...
// Pull in DB PEAR Collection
require_once 'DB.php';
// What kind of database server are we connecting too?
$db_type = 'mysql';
// local connectivity data
$db_host = 'localhost';
$db_user = 'dbUsername
$db_pass = 'dbUserPW';
$db_name = 'dbName';
// Data Source Name: This
This SQL is generated by my script...
INSERT INTO cbs_eps ( eps_id , eps_name , eps_num , eps_air_date )
VALUES ( '5','No Hiding Place','5','1974-01-10');
'eps_id' is generated from the index ($x) of the array loop
the others are retrieved from the tab delimted text file
When run from
OK, now I am really sure it has to do with the vars I defined from my text
file...
Once I have the text file open, I'm looping through it...
// pull RETURN off the end
$trimmed = rtrim($lines[$x]);
// Pull apart array element
list($strDate,$strNum,$strName) = explode (\t, $trimmed);
//
I have a 1400 line text file. TAB delimited.
1974-01-13 8 Cold Storage
3 fields. nothing large or complicated.
I massaged the data to be in this format thinking it would make the import
easier.
I can open the file and drop it into an array just fine.
I can EXPLODE each array item into
John W. Holmes [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
jsWalter wrote:
What kind of columns are you inserting these values into?
eps_id int(11)Yes 0
eps_name varchar(100) Yes NULL
eps_num int(11) Yes NULL
eps_air_date date Yes -00-00
It seems that my text file was a UNICODE text file
I have no idea how that happened as this was exported from Excel.
So, anyway, now I know to check the file format before I spend over 100
hours trying to figure out why I could not INSERT to a database.
Thanks to all who offered help,
John W. Holmes [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
jsWalter wrote:
// Spit it out to double check what I've got
echo '' . $strDate . ' - ' . $strNum . ' - ' . $strName . ' p
/';
So does this echo display anything?
It spits out...
1974-01-09 - 4 - Lost Dog
OK, I solved it.
It seems that I **HAVE TO**, **MUST**, **NO CHOICE** place my php.ini in
C:\WINNT (for NT and 2k) or PHP will not find it. This is a hardcoded path
done at compile time.
So, since no ini file, PHP was running on default values, thus it could not
find DB.php since the default
My understanding is the location PHP looks for the php.ini is dependant on
the OS and what %SYSTEMROOT% is set to.
This is what I have gleemed from my reading on this, as I had the same
issue.
walter
Russell Griechen [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
i found that even
OK, I solved it.
It seems that I **HAVE TO**, **MUST**, **NO CHOICE** place my php.ini in
C:\WINNT (for NT and 2k) or PHP will not find it. This is a hardcoded path
done at compile time.
So, since no ini file, PHP was running on default values, thus it could not
find DB.php since the default
Pete Morganic [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
edit the php.ini file and change the include paths to being where your
isntallation is ;
Thanks Pete for the idea, but I should give you what I had in my INI...
That was the first thing I did...
include_path =
I borrowed the database class definition (see below) from the PHP docs
[http://www.php.net/mysql_close].
I've been reading (and reading, and reading) about '.htaccess' and
'mysql.default_host' and what to set and how to set; or at least I'm trying
to read and understand.
It is my understanding
I am trying to use DB.php, but I am getting htis error...
Fatal error: main(): Failed opening required 'DB.php'
(include_path='.;c:\php4\pear')
I can't find this path defined *anywhere*
I don't have PHP installed there.
How can I fix this include path issue.
[besides placing the PEARS
Aaron Wolski [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi All,
Trying to get my head around something and want to know if it's possible
first.
Can PHP and Javascript interact to the point of PHP querying a DB to
find out what records are in use as a variable for another
21 matches
Mail list logo
