[PHP-DB] Compatibility with PHP and MySQL
Will installing the most recent XMAPP to install PHP MySQL and Apache to create a development environment on my local computer affect how everything runs when I upload it to the server (My web host 1and1.com runs php 5.0 and MySQL 5.0) thanks -- Gabriel Solberg Solberg Design 845/389-6877
[PHP-DB] multiple queries in the same request
I have a table with some relational values, that really saves me on selects, but gives me a weird error in the insert... in the DB i have this 2 tables data and categories: data( id int category tinyint ), categories ( id tinyint description varchar ) for selects i can use a single query with a left join. but to populate the table without having to use magic numbers in my code i've come up with: SELECT (@category_id:=id) FROM categories WHERE description = cat1; REPLACE INTO data VALUES( 10, @category_id); i send this as a single query in PHP and it returns an error quoting everything after the first ; anyidea if i can't send several queries at once? any workaround? Thanks, Gabriel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Struggling to install php4 on win 2000 system with apache2
I have Windows 2000 on my system. I have installed Apache 2 and it seems to work fine, when I test it, it goes to the 'localhost' dir. PHP is the problem, I have tried about 5 different websites's installation manuals to no avail. I have tried to do a manual installation I have downloaded PHP 4.3.9 and have unzipped it into C:/php Apache is installed in 'c:/program files/ apache group/apache2' I have changed the php.ini-recommended file to php.ini, then I have copied it with the php4ts.dll and php4apache2.dll and all the dll's from the dlls folder to both my system and system32 folders in the WINNT folder on the c:/ Before I have done this I have changed the following files in the php.ini file; Short_open_tag = on off Magic_quotes_gpc = onoff Session.save_path = c:/temp (a temp folder was created on the c:) doc_root = c:\Program Files\Apache Group\ Apache2\htdocs extentions_dir = C:\PHP\extentions in the Apache httpd.conf.file DokumentRoot C:/Program Files/Apache Group/Apache2/htdocs Directory C:/Program Files/Apache Group/Apache2/htdocs DirectoryIndex index.html index.html.var index.php Loadmodule php4_module C:/php/php4apache2.dll (php4apache2.dll is in the php folder) .htaccess files AllowOverride All ScriptAlias /php/ C:/php/ AddType application/X-httpd-php .php Action Application/x-httpd-php /php/php.exe Can any one help me from this night mare? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PostgreSQL + Cygwin
Alguien ha hecho funcionar PostgreSQL con Cygwin, que error puede ser que me diga que gcc no puede generar ejecutables. Gracias desde ya, Saludos, Gabriel.
[PHP-DB] Re: using href=abc.php/?day=......
It's just the syntax: 1. Don't use the / after .php: a href=abc.php?day= 2. Don't use echo inside the string: a href='abc.php?day=$start_day'/a 3. Check the use of double and single quotes. If you use: echo a href='abc.php?day=$start_day'abc/a; maybe you will get the link you want. Gabriel. MüCella Erdem Efe [EMAIL PROTECTED] escribió en el mensaje news:[EMAIL PROTECTED] Hi; I need to use a href=abc.php/?day=.. /a statement in a xxx.php file. I have to use a php variable on the right of the day variable like a href=abc.php/?day=+?echo $start_day;? /a. When i get this variable in abc.php file if (phpversion() = 4.1.0) { $vars = array_merge($HTTP_GET_VARS, $HTTP_POST_VARS); } else { $vars = $_REQUEST; } print_r($vars); Output is Array ( [day] =(nothing) When i use a constant instead of variable like a href=abc.php/?day=12-12-2002/a. it works . Please help me about using a php variable in a href statement. thanks for your attention. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: disable History
Check the Header() function in the manual: // Tels to the browser the page has caducated and forces to reload.. header(Expires: Mon, 26 Jul 1997 05:00:00 GMT); // Avoids cahce. It seams it's what you want. header(Cache-Control: no-cache, must-revalidate); Gabriel. Open-Mind [EMAIL PROTECTED] escribió en el mensaje news:[EMAIL PROTECTED] How can I disable the use of History(Temporary Internet Files) in a page ? (and don't tell me: it's easy: Tools-internet options-settings ...;-) ... from script (htm ?, js ?, php ?) I want to do this ..) PS: I have a script witch generate jpegs (cuts from a larger one) and sometimes in browser I see older pictures ... If I go to: Tools-internet options-settings- chk for new versions every visit to the page everything works just fine -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Help with file upload
For the message: Warning: move_uploaded_file(./ayservenet.jpg): failed to open stream: Permission denied in /home/ayserve/public_html/fu/fuprocess.php on line 6 you have to change the permissions of the file folder where you are copying the file. If you created it via FTP then you can't use copy() or move(). check: echo fileperms( $folder ); if it's 33188 or 33279 it's ok but I think it is not the permission of your folder. I think you'll get 17901 or some other. so you have to use ftp_chmod() of ftp_site() to change it.. try this: $folderbase = folderbase; // it's the folder where your folder for uploads is. $folder = foldername;// it's your folder for uploads. $mode = 0777; $site = ftp_connect ( ftp.yourdomain.com ); if( $site != FALSE ) { $loged = ftp_login( $site , your username, your password ); if( $loged ) { ftp_chdir( $site , $folder ); ftp_site( $site , chmod $mode $folder ); } ftp_quit( $site ); John W. Holmes [EMAIL PROTECTED] escribió en el mensaje news:[EMAIL PROTECTED] Bunmi Akinmboni wrote: Pls Help. I have done a lot of reading prior to this yet I just can't seem make it work. I wrote an upload program as seen below but the response I got was: Possible file upload attack. Filename: ayservenet.jpg Array ( [ufile1] = Array ( [name] = ayservenet.jpg [type] = image/pjpeg [tmp_name] = /tmp/phpIMEhdh [error] = 0 [size] = 3030 ) ) [snip] if (is_uploaded_file($_FILES['ufile1']['name'])) { copy($_FILES['ufile1']['name'], .); echo $ufile1_name ; echo DONE; echo ; print_r($_FILES); } else { echo Possible file upload attack. Filename: . $_FILES['ufile1']['name']; echo ; print_r($_FILES); } ? You should pass $_FILES['ufile1']['tmp_name'] to is_uploaded_file(). -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Help with file upload
I made a mistake in my last message: The lines that say: ftp_chdir( $site , $folder ); ftp_site( $site , chmod $mode $folder ); should say: ftp_chdir( $site , $folderbase );// this is the one that was wrong ftp_site( $site , chmod $mode $folder ); Bunmi Akinmboni [EMAIL PROTECTED] escribió en el mensaje news:[EMAIL PROTECTED] Pls Help. I have done a lot of reading prior to this yet I just can't seem make it work. I wrote an upload program as seen below but the response I got was: Possible file upload attack. Filename: ayservenet.jpg Array ( [ufile1] = Array ( [name] = ayservenet.jpg [type] = image/pjpeg [tmp_name] = /tmp/phpIMEhdh [error] = 0 [size] = 3030 ) ) My codes are: File UPLOAD.HTM: html head titleUntitled Document/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body form method=post action=fuprocess.php enctype=multipart/form-data input type=file name=ufile1 size=20 input type=submit name=submit value=submit /form /body /html File FUPROCESS.PHP: ?php // In PHP earlier then 4.1.0, $HTTP_POST_FILES should be used instead of $_FILES. // $realname = $_FILES['ufile1']['name']; if (is_uploaded_file($_FILES['ufile1']['name'])) { copy($_FILES['ufile1']['name'], .); echo $ufile1_name ; echo DONE; echo ; print_r($_FILES); } else { echo Possible file upload attack. Filename: . $_FILES['ufile1']['name']; echo ; print_r($_FILES); } ? Thanks. -- 'Bunmi Akinmboni 5, Aibu Street, Off Bode Thomas Street, P.O. Box 6235, Surulere, Lagos, NIGERIA. Tel: (234) 1-813-3335 Fax: (234) 1-583-2585 (Nigeria Only) Fax: 1 (309) 285-2383 (International) Email: [EMAIL PROTECTED] Web site: http://www.budelak.com http://www.ayserve.net Web Design, Web Hosting, Domain Registration, ICT Consultancy, Networking, Internet, eCommerce, System Integrator === -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] more about permissions
Have in mind that some permissions can be changed only via FTP but some other can only be changed useing chmod(). If you want more security you should set the permission in the moment of the upload and change it again after it. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Another way.
You can also pass the variable via POST to the script where the function is. It remains a local variable. Or you can set it as global like Chris says. And another way is puting it in a cookie. Adam Symonds [EMAIL PROTECTED] escribió en el mensaje news:[EMAIL PROTECTED] Hi, I am starting to us functions with my work but I am having troubles With the variables in the functions.. If I have the following function called from my page it will work but the variable won't ($username) but if I put this code straight on the page then it works fine.. Any reason for the variable not to work in the function but in straight coding? Thanx Sample Function Below: == function LoginSystem() { echo div align=right; if ( !isset( $_SESSION['login'] ) ) { echo form action=../Users/Login.php method=post; echo font size=1Username: /fontinput name=user type=text size=10nbsp;font size=1Password: /fontinput name=pass type=password size=10nbsp;input type=submit value=GObr; echo a href=../Register.phpfont size=1Not A Member Yet?/font/font/anbsp;; echo /form; } else { echo font size=1Welcome $username nbsp;nbsp;nbsp;a href=../Users/Logout.phpfont size=1Logout/anbsp;nbsp;nbsp;/font/fontbrbr; } echo /div; } -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] About security.
In your code, where you have: if (is_uploaded_file($_FILES['ufile1']['name'])) { copy($_FILES['ufile1']['name'], .); ... you should check the extension of the file been uploaded you should'n accept files with php, cgi, asp, etc., extensions neither an index file if you do, some user (hacker) could upload a script and would be inside your server then check this: if (is_uploaded_file($_FILES['ufile1']['name'])) { if ( the file is not a script ){ copy($_FILES['ufile1']['name'], .); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Sorry, About security is for this discution.
The message About security is for Help with file upload. I placed the message outside. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Can't conect with mysql_connect(), please help.
I'm starting to use MySQL, well, trying to, and I get the next message: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) The manual says that mysql_connect() can be called without arguments. That's what I'm doing. What's wrong? Thanks, Gabriel. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Can't conect with mysql_connect(), please help.
phpinfo() says: MySQL Support enabled MYSQL_SOCKET /var/lib/mysql/mysql.sock but in fact the file /var/lib/mysql/mysql.sock doesn't exists. So I understand that the first step is to check the configuration of MySQL, is it? Dan Brunner [EMAIL PROTECTED] escribió en el mensaje news:[EMAIL PROTECTED] Hello!! Does that file /var/lib/mysql/mysql.sock exist?!!?!? Check to make sure mysql is running. Dan On Oct 14, 2003, at 4:34 PM, [EMAIL PROTECTED] wrote: I'm starting to use MySQL, well, trying to, and I get the next message: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) The manual says that mysql_connect() can be called without arguments. That's what I'm doing. What's wrong? Thanks, Gabriel. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Can't conect with mysql_connect(), please help.
My site is hosted in a remote server. I can't find /etc/init.d/mysqld /etc does exists but /etc/init.d doesn't What I found is /usr/bin/msql2mysql /usr/bin/mysql_config /usr/bin/mysql /usr/bin/mysql_install_db /usr/bin/mysql_find_rows ... and a lot of files like /usr/bin/mysql The one that seems to be useful is /usr/lib/php4/mysql.so it's the socket, isn't? I guess that running /etc/init.d/mysqld start is kind of command line executing So, how can I start mysql from inside a php script? Thanks again. Gabriel. Joe Nilson Zegarra Galvez [EMAIL PROTECTED] escribió en el mensaje news:[EMAIL PROTECTED] You must start your mysql server : do it: /etc/init.d/mysqld start and when you read the line mysql start [OK] your problem will be fix ;) Regards Nilson Gabriel Peugnet dijo: phpinfo() says: MySQL Support enabled MYSQL_SOCKET /var/lib/mysql/mysql.sock but in fact the file /var/lib/mysql/mysql.sock doesn't exists. So I understand that the first step is to check the configuration of MySQL, is it? Dan Brunner [EMAIL PROTECTED] escribió en el mensaje news:[EMAIL PROTECTED] Hello!! Does that file /var/lib/mysql/mysql.sock exist?!!?!? Check to make sure mysql is running. Dan On Oct 14, 2003, at 4:34 PM, [EMAIL PROTECTED] wrote: I'm starting to use MySQL, well, trying to, and I get the next message: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) The manual says that mysql_connect() can be called without arguments. That's what I'm doing. What's wrong? Thanks, Gabriel. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php - Joe Nilson Zegarra Galvez Sistemas Kola Real Telefax : 0051-54-256658 Movil: 0051-54-9603244 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Parse Errors...
Some times parse errors aren't in the line the interpreter says. Looking at the code you sent I don't see the error but if your original code is in a biger file try looking if the brackets {} or parenthesis of all the code are balanced. Scott V Nipp [EMAIL PROTECTED] escribió en el mensaje news:[EMAIL PROTECTED] om... I keep receiving a parse error every time I try and view the page I am working on. I am developing this very simple application in DreamWeaver MX 2004. Here are lines 3-16: ?php mysql_select_db($database_Prod, $Prod); $query_Host = SELECT Name FROM systems; $Host = mysql_query($query_Host, $Prod) or die(mysql_error()); $row_Host = mysql_fetch_assoc($Host); $totalRows_Host = mysql_num_rows($Host); mysql_select_db($database_ProdUsers, $ProdUsers); $query_UserMod = SELECT shell, home_dir FROM modification; $UserMod = mysql_query($query_UserMod, $ProdUsers) or die(mysql_error()); $row_UserMod = mysql_fetch_assoc($UserMod); $totalRows_UserMod = mysql_num_rows($UserMod); ? I am simply attempting to pull data from two separate tables in two separate databases. Every time I try to view my work, I am getting a parse error on the 'mysql_select_db($database_ProdUsers, $ProdUsers);' regardless of whether this is the first or second mysql_select_db. I imagine that I am simply doing something obviously wrong here. Please help. Thanks. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Parse Errors...
I just sent you an email that was rejected. Recipient address: [EMAIL PROTECTED] Reason: Server rejected MAIL FROM address. Diagnostic code: smtp;550 5.0.0 Access Denied for prodigy.net.mx So here is the message: For sending numbers with format I prefer the number_format() function. Instead of these two lines: $formatted = sprintf(%01.2f, $money); echo $formatted; I'd use only one line: echo number_format( $money, 2 ); The output would be: 123.10 I'm sorry I can't help about the format %01 I'm not familiar with it. Gabriel. Scott V Nipp [EMAIL PROTECTED] escribió en el mensaje news:[EMAIL PROTECTED] om... I keep receiving a parse error every time I try and view the page I am working on. I am developing this very simple application in DreamWeaver MX 2004. Here are lines 3-16: ?php mysql_select_db($database_Prod, $Prod); $query_Host = SELECT Name FROM systems; $Host = mysql_query($query_Host, $Prod) or die(mysql_error()); $row_Host = mysql_fetch_assoc($Host); $totalRows_Host = mysql_num_rows($Host); mysql_select_db($database_ProdUsers, $ProdUsers); $query_UserMod = SELECT shell, home_dir FROM modification; $UserMod = mysql_query($query_UserMod, $ProdUsers) or die(mysql_error()); $row_UserMod = mysql_fetch_assoc($UserMod); $totalRows_UserMod = mysql_num_rows($UserMod); ? I am simply attempting to pull data from two separate tables in two separate databases. Every time I try to view my work, I am getting a parse error on the 'mysql_select_db($database_ProdUsers, $ProdUsers);' regardless of whether this is the first or second mysql_select_db. I imagine that I am simply doing something obviously wrong here. Please help. Thanks. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: set password on a page
Use setCookie() function. It places a global variable on the client that your programs can verify after. See the manual for the use of the function. Here is an example: // Example of file chkacces.php. ?php $pass = $_POST['password'];// It receives the password from a FORM with POST method. if( ($pass != xyz ){// where xyz is the right password. echo You are not autorized to see this page; return; } // Autorized. setCookie( $USER, autorized ); header( Location: index.php );// redirects to index.php ? Example for your index.php file: ?php if( ($USER != autorized ){ echo You are not autorized to see this page; return; } // Here goes the code for autorized users. ? The variable set with setCookie() is not availabe until the script ends. See details in the manual. The manual is available in www.php.org Sagerat [EMAIL PROTECTED] escribió en el mensaje news:[EMAIL PROTECTED] How do I set up password on a page so that only restricted people can open it? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: best upload method
I use file upload, it's faster than ftp because the ftp conection and login process takes a few seconds. You have to see that the permissions in each method are diferent. Some times you cannot delete a file copied with ftp useing the unlink() function unless you change the chmod. If you used the upload method you can use unlink() but not ftp_delete(). It has solutions but with a little of complexity. That's why I recomend the upload method and the functions copy() and unlink() for moveing and deleting files. You can use also the chmod() function with this method to change permissions. Open-Mind [EMAIL PROTECTED] escribió en el mensaje news:[EMAIL PROTECTED] which is the best upload file method ? file uploads or FTP commands from PHP thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: set password on a page
In my last replay I told you to find the manual in the wrong place. The right place is www.php.net Sagerat [EMAIL PROTECTED] escribió en el mensaje news:[EMAIL PROTECTED] How do I set up password on a page so that only restricted people can open it? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: tutorial
Go to www.php.net, in the section Documentation you'll find manuals in several languages. Novianto Dwiatmojo [EMAIL PROTECTED] escribió en el mensaje news:[EMAIL PROTECTED] Hi everyone i'm a newbie in php, mysql and linux but i want to learn about it can you guys help me or give me referal to any tutorial links. thank you for your kindness. thanks :P sorry for my english :- [ _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB]php-odbc-ctree
Does anybody knows any kind of odbc for c-tree´s databases in linux ? Thanks in advance, Gabriel. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] C-Tree And PHP
Hi all, Anyone has interact with c-tree databases using php. Where can i found help about it? Thanks in advance, Gabriel.
[PHP-DB] How can i upload files
Hi All, Can anyone tell me how can i select and upload files using php. Thanks in advance, Gabriel, - Original Message - From: Clarkson, Nick [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 13, 2003 10:59 AM Subject: RE: [PHP-DB] MySQL problem -- new to PHP Looks like is to do with MySQL permissions. Check your host's (the one you are trying to connect from) permissions to the server. To change permissions, from the MySQL prompt type; GRANT ALL ON * TO username@host IDENTIFIED BY password; Substitute in username, host and password for your ones. Easier to use PHPMyAdmin or SQLYog (www.sqlyog.com) if you're new to it. I'm pretty new, so learning all the time. A couple of links to get you started; http://www.mysql.com/doc/en/GRANT.html http://www.mysql.com/doc/en/GRANT.html Good luck, Nick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 13 February 2003 13:20 To: [EMAIL PROTECTED] Subject: [PHP-DB] MySQL problem -- new to PHP Hi all I am new to PHP (just basically started yesterday). I am currently having a problem connecting to a MySQL database. My sample code is: -- ?php mysql_connect(localhost,username,password) or die (Unable to connect to MySQL server.); $db = mysql_select_db(DB_NAME) or die (Unable to select requested database.); ? --- This throws the following error: --- Warning: MySQL Connection Failed: Host 'my.host.name' is not allowed to connect to this MySQL server --- Now, the mySQL server and the web server reside on the same machine. This warning is therefore saying that this machine does not have permission to connect to itself. Hmm. I have put entries in the host table and the user table, using both hostname and ip address, but no luck. I keep getting the same error. What am I doing wrong? Any and all help appreciated. Thanks Evan Morris [EMAIL PROTECTED] +27 11 792 2777 (tel) +27 11 792 2711 (fax) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php This private and confidential e-mail has been sent to you by Egg. The Egg group of companies includes Egg Banking plc (registered no. 2999842), Egg Financial Products Ltd (registered no. 3319027) and Egg Investments Ltd (registered no. 3403963) which carries out investment business on behalf of Egg and is regulated by the Financial Services Authority. Registered in England and Wales. Registered offices: 1 Waterhouse Square, 138-142 Holborn, London EC1N 2NA. If you are not the intended recipient of this e-mail and have received it in error, please notify the sender by replying with 'received in error' as the subject and then delete it from your mailbox. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: [PHP-DEV] [CROSS POST] PHP Meetup Texas PHP Users
Jay Blanchard wrote: Howdy all! Just wanted to remind everyone that sign-up for the PHP Meetup is still in progress at http://php.meetup.com . At latest count there are 289 folks signed up world-wide with the top 10 cities being; Washington DC (9 members) Toronto (9 members) Leeds, UK (8 members) London, England (8 members) Amsterdam (7 members) Melbourne (6 members) Atlanta (5 members) Oakland-Alameda, CA (5 members) Manhattan (below 42nd St) (5 members) Montréal (4 members) Why do something like this? Meet other developers, networking (you can never tell when you're going to need another pair of hands for a project), networking (you can never tell when someone is going to need to hire extra hands for a project), and networking (you get the idea). Sign up soon! There are thousands of PHP folks out there, spread the word. First of all, sorry for the additional cross post. MeetUp.com lacks the ability to let you contact other folks who have signed up. In my general area, Massachusetts, there are a bunch of tiny groups scattered about, and I'd like a chance to get all of them to converge in one place to make the meetup worth it for all of us. I know there's only a few days before the meetup is to take place, but if folks from the following areas could email me, then we can try and work out somewhere we can all meet, instead of there being 5 groups of 2 or 3 people. Boston, Ma Hyannis, Ma North Boston Suburbs Springfield, Ma Manchester, NH (heck, even people in RI and CT who don't mind driving) Meetup.com cancels meetups for groups less than 5 also, so I'd like to see if we can just get one or two big groups. Also, anyone else in this area... I've been looking for user groups in the Massachusetts area, and the only one that did exist, was PHPUG New England, which doesn't seem to exist anymore. Anyone interested in getting one going around here? Again, sorry for the cross post. -- Gabriel Ricard [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Moving from MySQL to MSSQL Server 2000
Sorry for the late reply to this, but if you were to move to MS SQL I'd highly recommend using FreeTDS (www.freetds.org) to access the database from PHP. Due to the lack of an MS SQL client library in Mac OS X I have to use FreeTDS to contact another MS SQL server ( I use MySQL myself ). Setup was very easy, you just build FreeTDS and then configure PHP using --with-sybase-ct=/path/to/freetds. Then you can use the mssql_* group of functions to access the database. Or you could use ODBC... but I was never able to get that to work correctly, and the general consensus seems to be that ODBC is slow. On Saturday, January 12, 2002, at 03:24 PM, Boaz Yahav wrote: Hi I'm planning to move my site (Very successful / high traffic Auctions site) from MySQL to MSSQL Server 2000. I was wondering if anyone has done this move and if there are any pit falls to notice. 1. Is ODBC the only way to work from a Solaris / Apache / PHP 4 machine to a Win2K / SQL Server 2000? 2. What could be the performance cost (if any). 3. Are there any special points that need to be taken into consideration on either side? -- PHP Database 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-DB] Use of Like
Can anyone tell me a way to simulate the command LIKE in mySQL query´s, Thanks in advance, Gabriel. -- PHP Database 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-DB] Filling mysql db with access db
How can i import data from an access database to a mysql db. Thanks in advance, Gabriel.
[PHP-DB] Fwd: URGENT : How can i generate scripts of database
Anyone can tell me how can i generate the scripts of my database to create it in another mysql server. Or better wich other ways i´ve to do it. Thanks in advance, Gabriel.
[PHP-DB] Method POST not allowed
Someone can tell me how can i resolve the problem in the subject i ve a form with a peace of code in php calling a mysql db, when i press submit the apache server returns me that error: 450 Method not allowed The requested method is not allowed to this URL Ill appreciate any kind of help, Thanks in advance, Gabriel. *** END FORWARDED MESSAGE *** -- PHP Database 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-DB] SSI and PHP?
Dear Dan, Yes, you can! In PHP you must use: ? include("filename") ? or ? require("filename") ? Include evaluates andd executes the code in the external. And replace just replaces the contents of the file. Regards, Dan Eskildsen wrote: Hi there, Can anyone tell me if it is possible to combine Server Side Includes with PHP? If not, is there a work around? Please cc your comments to [EMAIL PROTECTED] I would like everyone who commented on my queries the last couple of days. I went from not knowing a single thing about PHP and MySQL to a day later having already programmed a small application that will display newspaper articles. Thanks! Dan -- PHP Database 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 Database 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-DB] i need help with odbc!
Emanuel.exe