RE: [PHP] PHP (re)install problems
Yeah I am pretty sure it is right, it was working fine before I reinstalled. And thanks for the !$link that worked. jb > Warning: Undefined variable: Titlesearch in > d:\apache\htdocs\bkhtml\movies.php on line 22 > > This is line 22 of movies.php: > > print " action=\"movies/mysql_moviedb_search.php?Titlesearch=$Titlesearch\">\n"; are you sure your variable is capitalized previously? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] PHP (re)install problems
I just reformatted my computer and reinstalled:
Apache 1.3.14 Win32 r2
PHP 4.03pl1
mySQL 3.23.34 - Win
I copied over my mySWL database and my PHP files and I get the following
error:
Warning: Undefined variable: Titlesearch in
d:\apache\htdocs\bkhtml\movies.php on line 22
This is line 22 of movies.php:
print "\n";
I also get this error:
Warning: Use of undefined constant link - assumed 'link' in
d:\apache\htdocs\bkhtml\movies\mysql_movieindex.php on line 15
And this is lines 13-15 of mysql_movieindex.php:
$link = mysql_pconnect("localhost",$user,$pass);
if(!link)
die("Couldn't connect to mySQL");
It still displays what it is supposed to, so it is connecting to and
accessing the database, I just get these extra warnings that I never got
before.
TIA,
jb
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Terrible Hosting Experience
Speaking of hosting companies, has anyone had experience with a company called www.nomonthlyfees.com? TIA, jb -Original Message- From: Brian V Bonini [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 8:24 AM To: Hrishi; PHP List Subject: RE: [PHP] Terrible Hosting Experience Check out http://www.hostpro.com/hosting/shared/unix_products.html It's a semi-dedicated virtual environment with complete root access. -Brian > -Original Message- > From: Hrishi [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 21, 2001 10:10 AM > To: PHP List > Subject: Re: [PHP] Terrible Hosting Experience > > > > while we're on this topic, i'd suggest people take a look at pair > networks: > > http://www.pair.net > > i've had some good experience with them, almost complete control of the > server (even on virtual hosts). > they have the best support i have seen till date, and some of the best > connections i've seen in the industry. > > cheers, > Hrishi > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] php4 - MS SQL7 connection problem
Not sure if this helps but when I used PHP and SQL 7 I used odbc set of commands, not mmssql commands (i.e. odbc_pconnect and odbc_close etc). HTH, Jason -Original Message- From: Martin Tiscornia [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 01, 2001 10:27 AM To: [EMAIL PROTECTED] Subject: [PHP] php4 - MS SQL7 connection problem Hello! I'm running: WinNT4, IIS4, php 4.03pl1, and I'm trying to connect to MS SQL 7. Well, I configured the php.ini (extension=php_mssql70.dll), and I copy that .dll to the windows folder. Now I want to connect to the SQL and it doesn't work, it makes a time out. If I do the same things with php 3.0.17 it works fine. The code: Untitled Any solution? Thank you in advance . . . - @n Angel - _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Help Please, MySQL is driving me insane
Ummm try going into c:\mysql\bin and running winmysqladmin.exe or MySqlManager.exe - I can't remember which one I ran. HTH, jb -Original Message- From: Chris [mailto:[EMAIL PROTECTED]] Sent: Friday, January 26, 2001 8:29 PM To: Jason Bouwmeester; PHP Subject: Re: [PHP] Help Please, MySQL is driving me insane But i installed it to the default c:\mysql. How can I set a username and such to allow me to use it on my cpu? - Original Message - From: "Jason Bouwmeester" <[EMAIL PROTECTED]> To: "PHP" <[EMAIL PROTECTED]> Sent: Friday, January 26, 2001 4:12 PM Subject: RE: [PHP] Help Please, MySQL is driving me insane > I just installed mySQL yesterday from mysql.com (or .net or whatever it > was). It installed fine, there was a note about what to do if you didn't > install it to c:\mysql properly - I installed mine to a different directory, > followed the instructions and all went fine. Might be one place to start. > > HTH, > jb > > -Original Message- > From: Chris [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 26, 2001 8:21 PM > To: PHP > Subject: [PHP] Help Please, MySQL is driving me insane > > > I've installed PHP using the 4.04 win32 installer. I recently downloaded the > mysql(latest version) win32 installer and used that. But STILL mysql doesnt > work. Can someone give a code snipet i can use to see if it is working? > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Help Please, MySQL is driving me insane
I just installed mySQL yesterday from mysql.com (or .net or whatever it was). It installed fine, there was a note about what to do if you didn't install it to c:\mysql properly - I installed mine to a different directory, followed the instructions and all went fine. Might be one place to start. HTH, jb -Original Message- From: Chris [mailto:[EMAIL PROTECTED]] Sent: Friday, January 26, 2001 8:21 PM To: PHP Subject: [PHP] Help Please, MySQL is driving me insane I've installed PHP using the 4.04 win32 installer. I recently downloaded the mysql(latest version) win32 installer and used that. But STILL mysql doesnt work. Can someone give a code snipet i can use to see if it is working? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] SQL Server DB to mySQL DB
Thanks for the tip. I actually read that the default for mySQL is TAB and LF for delimiters, so I used those in SQL and exported a .txt file, imported it into mySQL database and voila! A few code modifications and we be running on mySQL. Thanks again! Jason -Original Message- From: Christopher Allen [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 9:16 AM To: Jason Bouwmeester; [EMAIL PROTECTED] Subject: Re: [PHP] SQL Server DB to mySQL DB Just did this to a 65mb fixed width file. What I did was get it into a csv file via perl :) Then I created the db table. Then I used: load data infile "/file.csv" into table blah fields terminated by ',' ; then go ahead and create any indexes etc... !works slick! > Is there an easy way to do this? I know that SQL Server can export a comma > delimited file, can mySQL import this? I imagine the PHP will be easy to > modify as long as the field names are the same. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] myODBC
Thanks, was just trying to figure out what I really needed to download/install to run mySQL with PHP on my W2K box. jb -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 9:26 AM To: Jason Bouwmeester; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP] myODBC myODBC lets you connect to a mysql databas3e via the ODBC protocol. So you can create a mysql database connection (on a windows machine) and use that connection in a MSAccess environment. Or pull data directly from mysql into an Excel spreadsheet. Plus i am sure ASP and stuff like that can use it as well (by why would you care about ASP???) ;) On Thu, Jan 25, 2001 at 09:08:36AM -0700, Jason Bouwmeester wrote: > myODBC - what is that useful for, or is there anywhere I can get > documentation or a description on it? > > Thanks again, > jb > > -Original Message- > From: Pavel Kalian [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 25, 2001 8:55 AM > To: Jason Bouwmeester > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP] SQL Server DB to mySQL DB > > > 1. Generate SQL script for your database in the MS SQL Server Enterprise > Manager > 2. Modify generated SQL to be compatible with MySQL > 3. Run the script on your MySQL server > > Pretty easy if you aren't using any feature of MS SQL that MySQL doesn't > support (for example stored procedures) > > Another way is to connect both the servers to Access using ODBC and just > copy the tables - it's the easiest way to do that but resulting MySQL tables > are quite screwed up. > > Pavel > > - Original Message - > From: "Jason Bouwmeester" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, January 25, 2001 4:44 PM > Subject: [PHP] SQL Server DB to mySQL DB > > > > Is there an easy way to do this? I know that SQL Server can export a comma > > delimited file, can mySQL import this? I imagine the PHP will be easy to > > modify as long as the field names are the same. > > > > Thanks, > > jb > > > > Jason Bouwmeester > > New Media Consultant > > InterVisual > > > > Suite 200, 709 - 11th Ave SW > > Calgary, AB T2R 0E3 > > Ph: 403.264.9199 > > Fax: 403.264.9225 > > www.intervisual.com > > "Internet Solutions Developer" > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- Christopher R. Moewes-Bystrom [EMAIL PROTECTED] http://www.moewes.com http://www.linuxnovice.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] myODBC
myODBC - what is that useful for, or is there anywhere I can get documentation or a description on it? Thanks again, jb -Original Message- From: Pavel Kalian [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 8:55 AM To: Jason Bouwmeester Cc: [EMAIL PROTECTED] Subject: Re: [PHP] SQL Server DB to mySQL DB 1. Generate SQL script for your database in the MS SQL Server Enterprise Manager 2. Modify generated SQL to be compatible with MySQL 3. Run the script on your MySQL server Pretty easy if you aren't using any feature of MS SQL that MySQL doesn't support (for example stored procedures) Another way is to connect both the servers to Access using ODBC and just copy the tables - it's the easiest way to do that but resulting MySQL tables are quite screwed up. Pavel - Original Message ----- From: "Jason Bouwmeester" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 25, 2001 4:44 PM Subject: [PHP] SQL Server DB to mySQL DB > Is there an easy way to do this? I know that SQL Server can export a comma > delimited file, can mySQL import this? I imagine the PHP will be easy to > modify as long as the field names are the same. > > Thanks, > jb > > Jason Bouwmeester > New Media Consultant > InterVisual > > Suite 200, 709 - 11th Ave SW > Calgary, AB T2R 0E3 > Ph: 403.264.9199 > Fax: 403.264.9225 > www.intervisual.com > "Internet Solutions Developer" > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] SQL Server DB to mySQL DB
Is there an easy way to do this? I know that SQL Server can export a comma delimited file, can mySQL import this? I imagine the PHP will be easy to modify as long as the field names are the same. Thanks, jb Jason Bouwmeester New Media Consultant InterVisual Suite 200, 709 - 11th Ave SW Calgary, AB T2R 0E3 Ph: 403.264.9199 Fax: 403.264.9225 www.intervisual.com "Internet Solutions Developer" -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Test - please ignore
Test
