[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 "form name=\"search\" method=\"get\" action=\"movies/mysql_moviedb_search.php?Titlesearch=$Titlesearch\"\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] 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 snip Warning: Undefined variable: Titlesearch in d:\apache\htdocs\bkhtml\movies.php on line 22 This is line 22 of movies.php: print "form name=\"search\" method=\"get\" 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]
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: !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html headtitleUntitled/title/head body ?php $HOST = "the host"; $USER = "the username"; $PSW = "the password"; $DB = "Database name"; if (mssql_connect($HOST, $USER, $PSW)) { mssql_select_db($DB); echo mssql_result( mssql_query("SELECT @@VERSION"), 0, 0); } if (!mssql_close()) echo "No lo pudo cerrar"; ? /body /html 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
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] 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] 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]
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] Test - please ignore
Test