Re: [PHP] Re: limit access to php page
On 5/29/13 6:14 PM, Jim Giner wrote: On 5/29/2013 7:11 PM, Tim Dunphy wrote: Hello list, I've created an authentication page (index.php) that logs into an LDAP server, then points you to a second page that some folks are intended to use to request apache redirects from the sysadmin group (redirect.php). Everything works great so far, except if you pop the full URL of redirect.php into your browser you can hit the page regardless of the login process on index.php. How can I limit redirect.php so that it can only be reached once you login via the index page? Thank you! Tim I would simply place my redirect.php script outside of the web-accessible tree. The user can never type that uri into his browser and have it work. I always see this answer a lot but never any sample code of how to include that file using require_once() or include_once(). It would be nice to know the exact syntax of inclusion of such files. Say, for example if I put the login/redirect .php file 3-4 levels up from my webroot. -d -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect noob question
Well all, it turns out the *correct* answer to my question, which no one answered, and which only degenerated into a kindergarten-like argument is: You need to add the port # to the *end* of the mysql_connect() call. i.e.: $link = mysqli_connect( $host, user, pass, $database, $port ); Glad to see the maturity level of posters on this list, as in most of IT these days is that of a bunch of squabling 5-year olds. On 4/23/13 5:47 AM, Tedd Sperling wrote: On Apr 21, 2013, at 3:33 PM, Glob Design Info i...@globdesign.com wrote: What question did I not answer? That proves that you're not listening -- you are total waste of time for anyone trying to help. Welcome to my ignore file. tedd _ tedd.sperl...@gmail.com http://sperling.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: mysql_connect noob question
Thanks for that great response Geoff. That very well may be what is wrong, however, my problem is I don't have admin access to this server - it hosted in a BaaS site where they do all the admin. They do provide mysql command line access and it works, but it won't let me log in as root, not even on the command line. Where is the '@'ip70-162-142-180.ph.ph.cox.net' part coming from? I have to assume mysql_connect itself is appending that in the call since it's not part of the contents of the variable I pass from the form. And if I can't get server root access then that begs the question: how do I tell mysql_connect to turn that off and just send the user as-is? Thanks, On Apr 21, 2013, at 1:42 AM, Geoff Lane ge...@gjctech.co.uk wrote: Hi, On Sunday, April 21, 2013, 3:37:38 AM, you wrote: Night now this is just a test server. On the real thing I'll do it right. FWIW, the error you describe is one that I've seen often when setting up a new development/test server. In my case, the issue has arisen because the user doesn't have permission to connect to the database. This drove me nuts for a couple of days until I read the error message a little more carefully. In your case, you have: *Warning*: mysql_connect() [function.mysql-connect http://localhost/wservices/function.mysql-connect]: Access denied for user 'user'@'ip70-162-142-180.ph.ph.cox.net' (using password: YES) in */Library/WebServer/Documents/wservices/connect.php* on line *29* Notice that the username isn't just 'user', but 'user@host'. Hopefully, you have access to the MySQL command line on the MySQL server. If so, log on as root then do: mysqluse mysql; mysqlselect user,host from user; In the results table, check which hosts your user is permitted to connect from. Let's say for now that your results table looks like: +--+---+ | user | host | +--+---+ | root | myserver | | root | 127.0.0.1 | | debian-sys-maint | localhost | | root | localhost | +--+---+ To permit a user to connect from any host, change the host value to '%' e.g: mysqlupdate user set host='%' where user='root' and host='myserver'; permits user 'root' to connect from any host rather than just from 'myserver', the loopback IP address, and 'localhost'. If that doesn't work, you probably need to configure mysql to permit connections from any host. To do this, edit my.cnf (which should be /etc/mysql/my.cnf in Debian-based systems) and search for the line: bind-address = 127.0.0.1 Comment this out and replace with: bind-address = 0.0.0.0 Hopefully, that'll sort out the one test user you've tried so far. Note that you'll need to take responsibility for verifying your users at the application level or you'll need to create a new entry in the user table with CREATE USER; GRANT appropriate privileges; and then update the user's record to permit connection from the appropriate host(s). HTH, -- Geoff Lane Cornwall, UK -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: mysql_connect noob question
Thanks Geoff, I am aware of the security implications. I will deal with that later. Right now I am just trying to get the WS architecture working. I am logging in with the creds the hosting provider gave me (xeround.com) When I use those creds on the mysql command line, or hard-code them in the script, all works fine. It is only when I pass those values from my HTML form to the script that it fails - which was why I posted the question originally - the authentication works fine, but when entered from a form and passed to the script it fails, which is what is so baffling. I don't understand why mysql_connect should append something in the case of a passed variable but not in the case of a local variable. Unless there is something in the form parsing machinery I am unaware of. And I am trying both from the same host. Thanks, On Apr 21, 2013, at 2:31 AM, Geoff Lane ge...@gjctech.co.uk wrote: Hi Glob, On Sunday, April 21, 2013, 10:46:32 AM, you wrote: That very well may be what is wrong, however, my problem is I don't have admin access to this server - it hosted in a BaaS site where they do all the admin. They do provide mysql command line access and it works, but it won't let me log in as root, not even on the command line. Perhaps you can issue the commands of my previous email while logged in as the user who's credentials they've given to you. That said, I wouldn't be surprised if they denied you update privs on any of the tables in the mysql database! Where is the '@'ip70-162-142-180.ph.ph.cox.net' part coming from? I have to assume mysql_connect itself is appending that in the call since it's not part of the contents of the variable I pass from the form. I suspect that it's coming from DNS and that the MySQL instance is performing a reverse DNS lookup to resolve the IP address of the connecting host. And if I can't get server root access then that begs the question: how do I tell mysql_connect to turn that off and just send the user as-is? I don't think that you can. However, the hosting company should have given you credentials to use to log into the database. If your application can log in with those credentials, I suggest that you rewrite your code to take responsibility for user verification. For example, you could have your own user table that gives username and password together with other user data you need. (BTW, for security, don't store plain-text passwords in your database, rather store hashes (e.g. MD5) of the passwords and then use the appropriate function to hash the user input and compare with the stored hash). HTH, -- Geoff Lane Cornwall, UK -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: mysql_connect noob question
If that is the case then why does logging in with exactly the same params from a UNIX shell work fine? Command line login supposedly would be adding the @localhost or @IP_address as well but isn't. Only when I pass the variables to the script is that happening. I am doing exactly as you stated: mysql_connect('localhost', $_POST['username'], $_POST['password']); Except that I am first storing $_POST['username'] in local $user and $_POST['password'] in local $pass first and then passing those to mysql_connect. And I am connecting to a remote server, not localhost. I have already documented both the exact HTML and PHP code in this thread and so see no need to post it elsewhere. On Apr 21, 2013, at 6:32 AM, Stuart Dallas stu...@3ft9.com wrote: On 21 Apr 2013, at 11:20, Glob Design Info i...@globdesign.com wrote: I don't understand why mysql_connect should append something in the case of a passed variable but not in the case of a local variable. Unless there is something in the form parsing machinery I am unaware of. Nothing is being added by anything. When you log in to MySQL it takes both the username and the IP address/hostname of the machine you're logging in from and looks those up in the users table. This means that user abc logging in on localhost becomes abc@localhost. User abc logging in from 192.168.0.187 becomes abc@192.168.0.187, and is treated as a completely separate user from abc@localhost. The host comes from your end of the connection. So if you connect on localhost, your end is also localhost. If you connect on the IP address or hostname, your end is the rDNS lookup of your IP address - note that this may be the same address as the one to which you are connecting, but will represent a different user to @localhost as far as MySQL is concerned. The only thing that may be being added to the variable when the form data is parsed is slashes, and then only if you have magic_quotes_gpc switched on in php.ini. I believe this has already been eliminated as the cause earlier in this thread. The problem you describe is not possible, so I'm betting your description is missing something. Given a request with POST parameters of username=abc and password=def, the following two lines are equivalent: mysql_connect('localhost', 'abc', 'def'); mysql_connect('localhost', $_POST['username'], $_POST['password']); If this is exactly what you're doing then something very strange is going on. If this is not exactly what you're doing, please narrow your code down to the minimum required to demonstrate the problem and post it somewhere like gist.com then send us the link. However, a more important question for me is why you are doing this. You say you are aware of the security implications, and that you'll deal with that later, but I question how you're going to deal with it. What exactly are you developing that requires DB credentials to come from a form on a web page? -Stuart -- Stuart Dallas 3ft9 Ltd http://3ft9.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: mysql_connect noob question
This for a commercial app - the client wants both an API connect via PHP and a web portal in which they can login from a web page and view the tables in the DB. Right now I am just trying to get the form/PHP interaction to work. On Apr 21, 2013, at 6:42 AM, tamouse mailing lists tamouse.li...@gmail.com wrote: On Sun, Apr 21, 2013 at 5:20 AM, Glob Design Info i...@globdesign.com wrote: I am aware of the security implications. I will deal with that later. Right now I am just trying to get the WS architecture working. I'm wondering, if you can get it to work with the creds in the script, why do you have to have them come from a web form at all? What value is that providing at all? While it is certainly an interesting question as to why it doesn't work, if you have other things in your app to work on, just leave it and come back to it when you've time, if it's still that interesting. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect noob question
What question did I not answer? I am developing a web portal that has to display the tables in the DB via a form/script. The web page has a login with user and password. Right now I am just trying to connect. On Apr 21, 2013, at 7:12 AM, Tedd Sperling tedd.sperl...@gmail.com wrote: On Apr 21, 2013, at 9:32 AM, Stuart Dallas stu...@3ft9.com wrote: However, a more important question for me is why you are doing this. You say you are aware of the security implications, and that you'll deal with that later, but I question how you're going to deal with it. What exactly are you developing that requires DB credentials to come from a form on a web page? -Stuart You and I are asking the same question, but I am afraid the poster is not listening. Instead, he is pursuing a course of action that simply repeats his problem. His focus is on a specific tree instead of the forest. He doesn't want to widen his view. Until the poster answers our question, I'm afraid our recommendations will fall on deaf ears. Some days you can help and some days you can't. Cheers, tedd _ tedd.sperl...@gmail.com http://sperling.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect noob question
Except that a) I already have my form and script done, b) don't have time to learn phpMyAdmin, c) want to know why the script doesn't work as-is. On Apr 21, 2013, at 12:46 PM, David OBrien dgobr...@gmail.com wrote: Not meaning to beat the proverbial dead horse I am developing a web portal that has to display the tables in the DB via a form/script. The web page has a login with user and password. Right now I am just trying to connect. This for a commercial app - the client wants both an API connect via PHP and a web portal in which they can login from a web page and view the tables in the DB. Right now I am just trying to get the form/PHP interaction to work. This sounds like a very good use statement for http://www.phpmyadmin.net/ You can set it for http auth in the config ... they enter a mysql username and password and they only see the databases and tables you want them to see Might be easier than reinventing the wheel and stressing all of us :)
Re: [PHP] mysql_connect noob question
One other thing I noted in the FAQ was this: Dots in incoming variable names Typically, PHP does not alter the names of variables when they are passed into a script. However, it should be noted that the dot (period, full stop) is not a valid character in a PHP variable name. For the reason, look at it: ?php$varname.ext; /* invalid variable name */ ? Now, what the parser sees is a variable named $varname, followed by the string concatenation operator, followed by the barestring (i.e. unquoted string which doesn't match any known key or reserved words) 'ext'. Obviously, this doesn't have the intended result. For this reason, it is important to note that PHP will automatically replace any dots in incoming variable names with underscores. I should note my user name in this case *is* an email address, however the dots in that address are *not* being converted to underscores as mentioned (at least not visibly). On Apr 21, 2013, at 8:39 AM, tamouse mailing lists tamouse.li...@gmail.com wrote: On Fri, Apr 19, 2013 at 3:43 PM, Glob Design Info i...@globdesign.com wrote: I know this has probably been answered already. When I pass a user name and password from a form to my PHP script and then pass those to mysql_connect it doesn't connect. When I paste those exact same values into mysql_connect as string literals it works. Can anyone tell me why this happens? I know the strings are identical to the literals I try in a test but they don't work when submitted via form. $form_user = $_POST[ 'user' ]; $form_pass = $_POST[ 'password' ]; # Connect to remote DB $LINK = mysql_connect( $host, $form_user, $form_pass ); And yes, my $host param is correct. Thanks, So, um, look at this gist: https://gist.github.com/tamouse/5430012 I know this never helps, but 'Works for me!'
Re: [PHP] Re: mysql_connect noob question
On 4/21/13 3:27 PM, Stuart Dallas wrote: On 21 Apr 2013, at 20:29, Glob Design Info i...@globdesign.com wrote: If that is the case then why does logging in with exactly the same params from a UNIX shell work fine? Command line login supposedly would be adding the @localhost or @IP_address as well but isn't. Only when I pass the variables to the script is that happening. What makes you so sure it's not? It is. I promise you it is. You're not seeing it because you're not getting an error logging in. Do it on the command line again, but use a username that doesn't exist and you will see the host it's adding in the error message. Indeed you are correct: Last login: Sun Apr 21 15:41:10 on ttys000 iMac-333:~ glob$ sudo mysql --host=instance43490.db.xeround.com --port=8904 --user=fakeuser --password=somepassword Password: Warning: Using a password on the command line interface can be insecure. ERROR 1045 (28000): Access denied for user 'fakeuser'@'ip70-162-142-180.ph.ph.cox.net' (using password: YES) iMac-333:~ glob$ I am doing exactly as you stated: mysql_connect('localhost', $_POST['username'], $_POST['password']); Except that I am first storing $_POST['username'] in local $user and $_POST['password'] in local $pass first and then passing those to mysql_connect. And I am connecting to a remote server, not localhost. Side note: why are you putting them in other variables first when you're only going to use them in that one place? It's a waste of memory. It's a minor niggle but it's a pet hate of mine. I am using them in other places - printing them on the response page to see their values/show the user who logged in, etc. I have already documented both the exact HTML and PHP code in this thread and so see no need to post it elsewhere. And you're saying that when, instead of using $_POST variables you hard-code the username and password in the script it work? I doubt it. I can assure you it does. However, I may have found the problem: the port. As a security measure the BaaS provider appears to have changed MySQL to a non-standard port. So On the command line: sudo mysql --host=instance43490.db.xeround.com --port=8904 --user=realuser --password=realpass WORKS perfectly - entering the MySQL Monitor. However, on the same host, same command line: sudo mysql --host=instance43490.db.xeround.com:8904 --user=realuser --password=realpass Does NOT work - returning an error that the host is not found. So it appears to be the port, which begs the obvious question: is there a way to tell mysql_connect() to use a different port? On the command line are you simply doing mysql -u username -p and then entering the password? In that case it's using localhost. Is MySQL running on the same server as PHP? If so, try changing the remove server name to localhost in your script. I'm better a magnum of decent champagne that it works. See above - I am specifying the host explicitly - as stated in a previous email the MySQL DB is running on BaaS provider xeround, but the PHP and forms are running on localhost. It's very rare (and pretty stupid) for a web host to allow remote servers to connect to their MySQL instances, unless they have a shared MySQL instance for all of their customers. Given that you have command line access to the MySQL server, and can log in without specifying the host, I'm thinking you're trying to use it in a way they don't allow. Again this is a test server, the deployment configuration will be different. -Stuart -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect noob question
Except that I want to use my script and form - precisely because I have already sunk time into it. I'm not going to sink *more* time into something that could potentially create *another* problem. I want the script to work - as it should if PHP is 1/2 what it's cracked up to be. If not, I'll have to look for another solution (like C which I have been using for 20 years). On 4/21/13 3:37 PM, Stuart Dallas wrote: On 21 Apr 2013, at 22:43, Glob Design Info i...@globdesign.com wrote: Except that a) I already have my form and script done, b) don't have time to learn phpMyAdmin, c) want to know why the script doesn't work as-is. You have multiple database users who will need to do this, or just one database user? If just one then it makes more sense to hard-code the username and password in the script and use something else like HTTP authentication to protect the script from unauthorised users. Giving internal database credentials to external users is generally a really really bad idea. Also, consider the time it will take to learn phpMyAdmin (it's simple - install, use) against the time it's taking to get your script working. The time you've spent developing the script is already sunk so there's no point sinking more in an effort to make that already-sunk time worthwhile. Also, how well tested is your script? I don't know but I can say with absolute confidence that phpMyAdmin has been tested far more. -Stuart -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect noob question
Tried that. Still didn't work. I appears to be the port. On 4/21/13 3:40 PM, Stuart Dallas wrote: On 21 Apr 2013, at 23:01, Glob Design Info i...@globdesign.com wrote: I should note my user name in this case *is* an email address, however the dots in that address are *not* being converted to underscores as mentioned (at least not visibly). This could be the culprit. Try using a username without an @ in it. -Stuart -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect noob question
SUCCESS! However. if ( $_REQUEST['Submit'] ) { makes it work (using my own form button ID). Why it doesn't work without this on my machine is beyond me. But it doesn't. Could it be somehow there is something about accessing the $_REQUEST that changes something? I am baffled as to the cause, but anyway it does work now. Thanks for your help. On 4/21/13 3:56 PM, David OBrien wrote: I should note my user name in this case *is* an email address, however the dots in that address are *not* being converted to underscores as mentioned (at least not visibly). I just created a free account there and the email says my username is dgobr...@gmail.com but I connected to it from sqlyog and a php page by using JUST dgobrien ?php $host = instance44364.db.xeround.com:3924; if ( $_REQUEST['Submit'] ) { $conn = mysql_connect( $host, $_REQUEST['username'], $_REQUEST['password'] ) or die( mysql_error() ); if ($conn) { mysql_select_db(uwharrie) or die( mysql_error() ); echo Connectedbr; } } ?form id='login' action='index.php' method='post' accept-charset='UTF-8' legendLogin/legend input type='hidden' name='submitted' id='submitted' value='1'/ label for='username' UserName*:/label input type='text' name='username' id='username' value='dgobrien' maxlength=50 / label for='password' Password*:/label input type='password' name='password' id='password' maxlength=50 value='mm' / input type='submit' name='Submit' value='Submit' / /form -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect noob question
Even more strange: It doesn't work from the form with or without the domain (but on the command line it does), but.. IF I add the $_REQUEST access *and* use the user that the *MySQL* install has, and *not* the xeround user name (my email), then it *does* work! WEIRD. On 4/21/13 3:59 PM, David OBrien wrote: In fact using the @gmail.com part added on gives me the same error as the OP I think their welcome email needs tweaking.. try it without the domain added on On Sun, Apr 21, 2013 at 6:56 PM, David OBrien dgobr...@gmail.com wrote: I should note my user name in this case *is* an email address, however the dots in that address are *not* being converted to underscores as mentioned (at least not visibly). I just created a free account there and the email says my username is dgobr...@gmail.com but I connected to it from sqlyog and a php page by using JUST dgobrien ?php $host = instance44364.db.xeround.com:3924; if ( $_REQUEST['Submit'] ) { $conn = mysql_connect( $host, $_REQUEST['username'], $_REQUEST['password'] ) or die( mysql_error() ); if ($conn) { mysql_select_db(uwharrie) or die( mysql_error() ); echo Connectedbr; } } ?form id='login' action='index.php' method='post' accept-charset='UTF-8' legendLogin/legend input type='hidden' name='submitted' id='submitted' value='1'/ label for='username' UserName*:/label input type='text' name='username' id='username' value='dgobrien' maxlength=50 / label for='password' Password*:/label input type='password' name='password' id='password' maxlength=50 value='mm' / input type='submit' name='Submit' value='Submit' / /form -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: mysql_connect noob question
As shown in the OP I am already doing that in the PHP scipt: $host = instance43490.db.xeround.com:8904; And then passing that as the 1st param to mysql_connect On 4/21/13 4:23 PM, Stuart Dallas wrote: On 22 Apr 2013, at 00:14, Glob Design Info i...@globdesign.com wrote: However, I may have found the problem: the port. As a security measure the BaaS provider appears to have changed MySQL to a non-standard port. So On the command line: sudo mysql --host=instance43490.db.xeround.com --port=8904 --user=realuser --password=realpass WORKS perfectly - entering the MySQL Monitor. However, on the same host, same command line: sudo mysql --host=instance43490.db.xeround.com:8904 --user=realuser --password=realpass The MySQL command line doesn't support putting the port number there, but the first parameter of mysql_connect does. If this is the problem then it cannot be true that replacing the variables you were taking from $_POST with literal strings for the username and password worked, as I asked earlier to which you said it does. Replace the first parameter to your mysql_connect call with 'instance43490.db.xeround.com:8904' and it will probably work. -Stuart -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect noob question
A very complex solution that takes time to learn, configure, and install, vs. a single file I can toss on the server. Over-engineering is what is daft. On 4/21/13 4:33 PM, Stuart Dallas wrote: On 22 Apr 2013, at 00:16, Glob Design Info i...@globdesign.com wrote: Except that I want to use my script and form - precisely because I have already sunk time into it. I'm not going to sink *more* time into something that could potentially create *another* problem. The idea of sunk time is that it's already been spent, so spending more in an attempt to justify the fact you spent it (i.e. to make it work because it's already cost you time/money) is daft when you discover a pre-built solution. To refuse to investigate it due to a refusal to throw the result of that time away is pure stubbornness, a normally expensive path to walk. I want the script to work - as it should if PHP is 1/2 what it's cracked up to be. If not, I'll have to look for another solution (like C which I have been using for 20 years). Am I supposed to care whether you use PHP or not? But sure, let me know how much time it takes you to write a web-based MySQL management tool in C. In the meantime I'll install phpMyAdmin in five minutes, show it to your client, and probably not even charge them for it. C? Really? Why not assembly language, since the relationship between PHP and C is the same as that between assembly and C? Hell, take it all the way to punch cards if you want -Stuart -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect noob question
Ever heard of the MySQL C Connector? http://www.karlkraft.com/index.php/2010/06/02/mysql-and-objective-c/ :-) On 4/21/13 4:33 PM, Stuart Dallas wrote: On 22 Apr 2013, at 00:16, Glob Design Info i...@globdesign.com wrote: Except that I want to use my script and form - precisely because I have already sunk time into it. I'm not going to sink *more* time into something that could potentially create *another* problem. The idea of sunk time is that it's already been spent, so spending more in an attempt to justify the fact you spent it (i.e. to make it work because it's already cost you time/money) is daft when you discover a pre-built solution. To refuse to investigate it due to a refusal to throw the result of that time away is pure stubbornness, a normally expensive path to walk. I want the script to work - as it should if PHP is 1/2 what it's cracked up to be. If not, I'll have to look for another solution (like C which I have been using for 20 years). Am I supposed to care whether you use PHP or not? But sure, let me know how much time it takes you to write a web-based MySQL management tool in C. In the meantime I'll install phpMyAdmin in five minutes, show it to your client, and probably not even charge them for it. C? Really? Why not assembly language, since the relationship between PHP and C is the same as that between assembly and C? Hell, take it all the way to punch cards if you want -Stuart -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect noob question
Thanks for that good suggestion. I tried that and as expected, the passed variables are coming through exactly as expected: array(3) { [user]= string(3) joe [password]= string(11) complacency [login]= string(5) Login } The bottom one seems to be the submit button's tag. I'm at a loss too. It should work. Replacing all 3 script variables with hard-coded values for the login works fine - so I know the host string is fine. Very weird! On 4/20/13 1:36 AM, tamouse mailing lists wrote: No, that's for writing safe html output. If the user or password contains special chars, sending them through htmlspecialchars would turn them into html entities. i doubt you want that. I'm at a loss here. The only thing Ican think of is to try something like this at the top of the script: ?php error_reporting(-1); ini_set('display_errors',1); ini_set('display_startup_errors',1); header(Content-type: text/plain); var_dump($_POST); exit; ? and see precisely what is being passed in from your form. On Apr 19, 2013 10:50 PM, Glob Design Info i...@globdesign.com wrote: No, no spaces. I am wondering if I need to use htmlspecialchars() On Apr 19, 2013, at 7:17 PM, Jim Giner jim.gi...@albanyhandball.com wrote: On 4/19/2013 9:33 PM, Glob Design Info wrote: They aren't on the same server. The DB is on xeround.com, the web server is localhost. The host value is set and working. If I hard-code the user and password values in the mysql_connect() call and leave the host value as is, it connects fine. Only passing the user and password from the form cause it to fail. On 4/19/13 5:47 PM, David Robley wrote: Glob Design Info wrote: Sorry. The error displayed is: *Warning*: mysql_connect() [function.mysql-connect http://localhost/wservices/function.mysql-connect]: Access denied for user 'user'@'ip70-162-142-180.ph.ph.cox.net' (using password: YES) in */Library/WebServer/Documents/wservices/connect.php* on line *29* (But with the real user name, not just 'user') Thanks, On 4/19/13 3:28 PM, tamouse mailing lists wrote: On Fri, Apr 19, 2013 at 3:43 PM, Glob Design Info i...@globdesign.com wrote: I know this has probably been answered already. When I pass a user name and password from a form to my PHP script and then pass those to mysql_connect it doesn't connect. When I paste those exact same values into mysql_connect as string literals it works. Can anyone tell me why this happens? I know the strings are identical to the literals I try in a test but they don't work when submitted via form. $form_user = $_POST[ 'user' ]; $form_pass = $_POST[ 'password' ]; # Connect to remote DB $LINK = mysql_connect( $host, $form_user, $form_pass ); Please show the error you are getting from the mysql_connect And yes, my $host param is correct. Thanks, -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php First guess is that you don't have privileges for 'user'@'ip70-162-142-180.ph.ph.cox.net', but you may have privileges for 'user'. And, what are you using for the $host value? If the script and mysql are on the same server, it shouldn't need to be anything other than 'localhost'. Do your user or password contain spaces, thereby requiring quotes in your call? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect noob question
Goog suggestion. The user name is an email address so it does contain @. Password is all pure lowercase ASCII. Wonder if the shift-2 is causing the problem? On 4/20/13 4:44 AM, Matijn Woudt wrote: On Sat, Apr 20, 2013 at 10:36 AM, tamouse mailing lists tamouse.li...@gmail.com wrote: No, that's for writing safe html output. If the user or password contains special chars, sending them through htmlspecialchars would turn them into html entities. i doubt you want that. I'm at a loss here. Pretty much the same goes for me. It could be charset issue, do your username and password consist of only ASCII characters, or do they also contain others? If so, then it might be that your sending these characters in a different charset. - Matijn -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect noob question
Same error. That just turns those into string literals. On 4/20/13 5:48 AM, David OBrien wrote: $form_user = $_POST[ 'user' ]; $form_pass = $_POST[ 'password' ]; # Connect to remote DB $LINK = mysql_connect( $host, $form_user, $form_pass ); And yes, my $host param is correct. Have you tried $LINK = mysql_connect( $host, $form_user, $form_pass ); just for the heck of it? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect noob question
Night now this is just a test server. On the real thing I'll do it right. On 4/20/13 10:58 AM, Tedd Sperling wrote: On Apr 20, 2013, at 11:44 AM, Stuart Dallas stu...@3ft9.com wrote: On 20 Apr 2013, at 16:25, Jim Giner jim.gi...@albanyhandball.com wrote: Why are you allowing anyone to connect to your database from a form? A little OT, but... What do you mean by this question? How do you check someone's credentials if not by connecting to a db to verify the login? Cause I'm doing the same kind of thing all over the place. With good practices on validation and such before doing my query of course. I'm pretty sure that's not what tedd meant. The code is logging in to the database server using the username and password from the form. There are very few legitimate reasons to be doing this, so the question is well worth asking. -Stuart Stuart is exactly right. If you are checking someone's credentials to access your site, such as a user, then giving them the keys to the kingdom is a bit of an overkill. My advice, set up user_id and password fields in a user table for users you want to access some portion of your site, here's the code to do that: http://sperling.com/php/authorization/log-on.php Where I have said // define your user id here is the place to actually open your database and access your user table to gather the correct user_id and password. I also suggest that when you open the database you only use literals from a config.php file ($dbhost,$dbuser,$dbpass) for accessing the actual database and then check the user_id and password before giving them authorization to private areas. Keep the private stuff private! Cheers, tedd _ tedd.sperl...@gmail.com http://sperling.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] mysql_connect noob question
I know this has probably been answered already. When I pass a user name and password from a form to my PHP script and then pass those to mysql_connect it doesn't connect. When I paste those exact same values into mysql_connect as string literals it works. Can anyone tell me why this happens? I know the strings are identical to the literals I try in a test but they don't work when submitted via form. $form_user = $_POST[ 'user' ]; $form_pass = $_POST[ 'password' ]; # Connect to remote DB $LINK = mysql_connect( $host, $form_user, $form_pass ); And yes, my $host param is correct. Thanks, -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect noob question
Already did that. I printed the form values in the PHP script after they are received and they print exactly as entered in the form. Even checked for extra spaces. Any functions I can pass the values to to remove the magic quotes? Thanks, On 4/19/13 1:47 PM, Matijn Woudt wrote: On Fri, Apr 19, 2013 at 10:43 PM, Glob Design Info i...@globdesign.comwrote: I know this has probably been answered already. When I pass a user name and password from a form to my PHP script and then pass those to mysql_connect it doesn't connect. When I paste those exact same values into mysql_connect as string literals it works. Can anyone tell me why this happens? I know the strings are identical to the literals I try in a test but they don't work when submitted via form. $form_user = $_POST[ 'user' ]; $form_pass = $_POST[ 'password' ]; # Connect to remote DB $LINK = mysql_connect( $host, $form_user, $form_pass ); And yes, my $host param is correct. Thanks, Try printing the $form_user and form_pass values, it might be that it's just an error elsewhere, maybe field name is different in the html? Otherwise, it might be you have some php init setting, like magic quotes that does something with the input data. - Matijn -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect noob question
Nope, quotes are not visible in the output. Both the HTML and the script it calls are shown below. They are in 2 separate files. The variable names in both are user and password. The data comes through to the PHP script fine - if I print them I see exactly what I typed in the form, but when I pass them to my DB host on another server via mysql_connect it give me an error. HTML: !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd; html xmlns=http://www.w3.org/1999/xhtml; head meta http-equiv=Content-Type content=text/html; charset=UTF-8 / titleAdmin/title style type=text/css .desw { font-family: Arial, Helvetica, sans-serif; } /style /head body div align=center pnbsp;/p pimg src=../images/web_logo_admin.png alt=0 width=221 height=134 border=0 //p p class=deswnbsp;/p p class=deswstrongPlease log in./strong/p p class=deswnbsp;/p form id=form1 name=form1 action=../wservices/connect.php method=post pUser: input type=text name=user id=user //p pPassword: input type=password name=password id=password //p pinput type=submit name=login id=login value=Login //p /form p class=deswnbsp;/p p class=deswnbsp;/p /div pnbsp;/p pnbsp;/p /body /html PHP: ?php # Add redirect page for errors header( Location: ../admin/login_error.html ); # Server info $host = instance43490.db.xeround.com:8904; # Get user pass from input form $form_user = $_POST[ 'user' ]; $form_pass = $_POST[ 'password' ]; echo pUser: . $form_user . /p; echo pPass: . $form_pass . /p; # Connect to remote DB $WSDB_LINK = mysql_connect( $host, $form_user, $form_pass ); if( !$WSDB_LINK ) { error_log( NeverStranded: cannot connect to the database. ); } else { .. } ? On 4/19/13 2:13 PM, Matijn Woudt wrote: On Fri, Apr 19, 2013 at 10:59 PM, Glob Design Info i...@globdesign.comwrote: Already did that. I printed the form values in the PHP script after they are received and they print exactly as entered in the form. Even checked for extra spaces. Any functions I can pass the values to to remove the magic quotes? Thanks, You would see the quotes if they were there in the output. There's no reason why it should not work this way, though I doubt it's safe to do. Can you show us the rest of the code, including the HTML form? And exactly what error are you getting? (eg. from mysql_error()) On 4/19/13 1:47 PM, Matijn Woudt wrote: On Fri, Apr 19, 2013 at 10:43 PM, Glob Design Info i...@globdesign.com wrote: I know this has probably been answered already. When I pass a user name and password from a form to my PHP script and then pass those to mysql_connect it doesn't connect. When I paste those exact same values into mysql_connect as string literals it works. Can anyone tell me why this happens? I know the strings are identical to the literals I try in a test but they don't work when submitted via form. $form_user = $_POST[ 'user' ]; $form_pass = $_POST[ 'password' ]; # Connect to remote DB $LINK = mysql_connect( $host, $form_user, $form_pass ); And yes, my $host param is correct. Thanks, Try printing the $form_user and form_pass values, it might be that it's just an error elsewhere, maybe field name is different in the html? Otherwise, it might be you have some php init setting, like magic quotes that does something with the input data. - Matijn -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect noob question
Sorry. The error displayed is: *Warning*: mysql_connect() [function.mysql-connect http://localhost/wservices/function.mysql-connect]: Access denied for user 'user'@'ip70-162-142-180.ph.ph.cox.net' (using password: YES) in */Library/WebServer/Documents/wservices/connect.php* on line *29* (But with the real user name, not just 'user') Thanks, On 4/19/13 3:28 PM, tamouse mailing lists wrote: On Fri, Apr 19, 2013 at 3:43 PM, Glob Design Info i...@globdesign.com wrote: I know this has probably been answered already. When I pass a user name and password from a form to my PHP script and then pass those to mysql_connect it doesn't connect. When I paste those exact same values into mysql_connect as string literals it works. Can anyone tell me why this happens? I know the strings are identical to the literals I try in a test but they don't work when submitted via form. $form_user = $_POST[ 'user' ]; $form_pass = $_POST[ 'password' ]; # Connect to remote DB $LINK = mysql_connect( $host, $form_user, $form_pass ); Please show the error you are getting from the mysql_connect And yes, my $host param is correct. Thanks, -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect noob question
They aren't on the same server. The DB is on xeround.com, the web server is localhost. The host value is set and working. If I hard-code the user and password values in the mysql_connect() call and leave the host value as is, it connects fine. Only passing the user and password from the form cause it to fail. On 4/19/13 5:47 PM, David Robley wrote: Glob Design Info wrote: Sorry. The error displayed is: *Warning*: mysql_connect() [function.mysql-connect http://localhost/wservices/function.mysql-connect]: Access denied for user 'user'@'ip70-162-142-180.ph.ph.cox.net' (using password: YES) in */Library/WebServer/Documents/wservices/connect.php* on line *29* (But with the real user name, not just 'user') Thanks, On 4/19/13 3:28 PM, tamouse mailing lists wrote: On Fri, Apr 19, 2013 at 3:43 PM, Glob Design Info i...@globdesign.com wrote: I know this has probably been answered already. When I pass a user name and password from a form to my PHP script and then pass those to mysql_connect it doesn't connect. When I paste those exact same values into mysql_connect as string literals it works. Can anyone tell me why this happens? I know the strings are identical to the literals I try in a test but they don't work when submitted via form. $form_user = $_POST[ 'user' ]; $form_pass = $_POST[ 'password' ]; # Connect to remote DB $LINK = mysql_connect( $host, $form_user, $form_pass ); Please show the error you are getting from the mysql_connect And yes, my $host param is correct. Thanks, -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php First guess is that you don't have privileges for 'user'@'ip70-162-142-180.ph.ph.cox.net', but you may have privileges for 'user'. And, what are you using for the $host value? If the script and mysql are on the same server, it shouldn't need to be anything other than 'localhost'. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect noob question
No, no spaces. I am wondering if I need to use htmlspecialchars() On Apr 19, 2013, at 7:17 PM, Jim Giner jim.gi...@albanyhandball.com wrote: On 4/19/2013 9:33 PM, Glob Design Info wrote: They aren't on the same server. The DB is on xeround.com, the web server is localhost. The host value is set and working. If I hard-code the user and password values in the mysql_connect() call and leave the host value as is, it connects fine. Only passing the user and password from the form cause it to fail. On 4/19/13 5:47 PM, David Robley wrote: Glob Design Info wrote: Sorry. The error displayed is: *Warning*: mysql_connect() [function.mysql-connect http://localhost/wservices/function.mysql-connect]: Access denied for user 'user'@'ip70-162-142-180.ph.ph.cox.net' (using password: YES) in */Library/WebServer/Documents/wservices/connect.php* on line *29* (But with the real user name, not just 'user') Thanks, On 4/19/13 3:28 PM, tamouse mailing lists wrote: On Fri, Apr 19, 2013 at 3:43 PM, Glob Design Info i...@globdesign.com wrote: I know this has probably been answered already. When I pass a user name and password from a form to my PHP script and then pass those to mysql_connect it doesn't connect. When I paste those exact same values into mysql_connect as string literals it works. Can anyone tell me why this happens? I know the strings are identical to the literals I try in a test but they don't work when submitted via form. $form_user = $_POST[ 'user' ]; $form_pass = $_POST[ 'password' ]; # Connect to remote DB $LINK = mysql_connect( $host, $form_user, $form_pass ); Please show the error you are getting from the mysql_connect And yes, my $host param is correct. Thanks, -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php First guess is that you don't have privileges for 'user'@'ip70-162-142-180.ph.ph.cox.net', but you may have privileges for 'user'. And, what are you using for the $host value? If the script and mysql are on the same server, it shouldn't need to be anything other than 'localhost'. Do your user or password contain spaces, thereby requiring quotes in your call? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect noob question
Dunno. The code definitely has the underscore. On Apr 19, 2013, at 9:11 PM, Jim Giner jim.gi...@albanyhandball.com wrote: On 4/20/2013 12:23 AM, Glob Design Info wrote: No, no spaces. I am wondering if I need to use htmlspecialchars() On Apr 19, 2013, at 7:17 PM, Jim Giner jim.gi...@albanyhandball.com wrote: On 4/19/2013 9:33 PM, Glob Design Info wrote: They aren't on the same server. The DB is on xeround.com, the web server is localhost. The host value is set and working. If I hard-code the user and password values in the mysql_connect() call and leave the host value as is, it connects fine. Only passing the user and password from the form cause it to fail. On 4/19/13 5:47 PM, David Robley wrote: Glob Design Info wrote: Sorry. The error displayed is: *Warning*: mysql_connect() [function.mysql-connect http://localhost/wservices/function.mysql-connect]: Access denied for user 'user'@'ip70-162-142-180.ph.ph.cox.net' (using password: YES) in */Library/WebServer/Documents/wservices/connect.php* on line *29* (But with the real user name, not just 'user') Thanks, On 4/19/13 3:28 PM, tamouse mailing lists wrote: On Fri, Apr 19, 2013 at 3:43 PM, Glob Design Info i...@globdesign.com wrote: I know this has probably been answered already. When I pass a user name and password from a form to my PHP script and then pass those to mysql_connect it doesn't connect. When I paste those exact same values into mysql_connect as string literals it works. Can anyone tell me why this happens? I know the strings are identical to the literals I try in a test but they don't work when submitted via form. $form_user = $_POST[ 'user' ]; $form_pass = $_POST[ 'password' ]; # Connect to remote DB $LINK = mysql_connect( $host, $form_user, $form_pass ); Please show the error you are getting from the mysql_connect And yes, my $host param is correct. Thanks, -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php First guess is that you don't have privileges for 'user'@'ip70-162-142-180.ph.ph.cox.net', but you may have privileges for 'user'. And, what are you using for the $host value? If the script and mysql are on the same server, it shouldn't need to be anything other than 'localhost'. Do your user or password contain spaces, thereby requiring quotes in your call? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Why does the error message refer to mysql-connect and not mysql_connect? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] how to capture INF return from exp()
Hello List, I am using the math function exp( $arg ) http://php.net/exp ... using argument values ranging between 0 to 1500. When I get into larger numbers, such as 750, the function returns an undocumented INF. Presumably the INF means the number exceeds processing capacity. It would be nice to know the official explanation. At any rate, I want to capture the INF so that I can indicate to my users, in a friendlier manner, that capacity is exceeded. How? Please also cc my address on your reply, with thanks, Sincerely, Esteban 1888Software.com S.A. Software Powers the Net WWW: http://1888Software.com Email: 1888softw...@gmail.com
RE: [PHP] PHP httpd debug question
Hi Devendra That’s sounds like what I’m looking for. I don’t want to interfere with the current httpd process serving content while running the debug. Thanks -John From: Devendra Jadhav [mailto:devendra...@gmail.com] Sent: Tuesday, November 17, 2009 5:57 AM To: John Beaulaurier -X (jbeaulau - Advanced Network Info at Cisco) Cc: php-general@lists.php.net Subject: Re: [PHP] PHP httpd debug question Hi, I am not getting what are you asking but if you want to run two httpd then you have to run those on different ports. For this you can change Listen 80 to Listen 2020 from httpd.conf file. So that one server will run on 80 and other will run on 2020. you can change 2020 to whatever port you want .. but check if that port is not already assigned to some other application. On Tue, Nov 17, 2009 at 5:35 AM, John Beaulaurier -X (jbeaulau - Advanced Network Info at Cisco) jbeau...@cisco.com wrote: Hello, phpMyAdmin crashes when access is attempted each time, and I need to run an httpd backtrace. I have a question though. There is another httpd instance running on the same host. If I run httpd -X will it interfere with the other httpd process running, or will it be a separate process? Thanks -John -- Devendra Jadhav देवेंद्र जाधव
[PHP] PHP httpd debug question
Hello, phpMyAdmin crashes when access is attempted each time, and I need to run an httpd backtrace. I have a question though. There is another httpd instance running on the same host. If I run httpd -X will it interfere with the other httpd process running, or will it be a separate process? Thanks -John
Re: [PHP] returning an array from a function?
Hello List, Your help produced a refined function. The function converts a Google Map latitude and longitude into an equivalent Microsoft Virtual Earth latitude and longitude. Here is an example of how the function works, along with source code: http://www.globalissa.com/articles/convert_google_to_mve_array_doc.php Thank you to Ted and others who helped. sincerely, Rob At 12:09 AM -0700 10/26/07, [EMAIL PROTECTED] wrote: Hello all, function convert( $latitude, $longitude ) { $mve_latitude = $latitude; // actually other processing within this function determines this $mve_longitude = $longitude // actually other processing within this function determines this $mve_both = $mve_latitude . , . $mve_longitude; // prepare return values $mve_array[0] = $mve_latitude; $mve_array[1] = $mve_longitude; $mve_array[2] = $mve_both; return $mve_array; } // function $latitude = 23.263400; $longitude = 80.110030 convert( $latitude, $longitude ); print_r( $mve_array ); .. the above does not return a value in the array. What do I have to change to receive an array with global scope from this function? I read several pages of docs on php.net but the light didn't go on... Sincerely, Rob. Rob: Why use a global? Plus, your function is returning an array, but you're not catching it. $mve_array = convert( $latitude, $longitude ); Example: http://www.webbytedd.com/bbb/array-function/ Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] returning an array from a function?
Hello all, function convert( $latitude, $longitude ) { $mve_latitude = $latitude; // actually other processing within this function determines this $mve_longitude = $longitude // actually other processing within this function determines this $mve_both = $mve_latitude . , . $mve_longitude; // prepare return values $mve_array[0] = $mve_latitude; $mve_array[1] = $mve_longitude; $mve_array[2] = $mve_both; return $mve_array; } // function $latitude = 23.263400; $longitude = 80.110030 convert( $latitude, $longitude ); print_r( $mve_array ); .. the above does not return a value in the array. What do I have to change to receive an array with global scope from this function? I read several pages of docs on php.net but the light didn't go on... Sincerely, Rob. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] [RFC] HTTP timezone
I agree with Tijnema he's hit the nail on the head. And the inability to handle daylight time really is a big potential snag - who in North America isn't on daylight time at some point in the year? If the timezone data is unreliable then no thinking developer will use it. The question then becomes: As a developer why WOULD you use unreliable timezone data? Sincerely, Rob // Flag images, ISO codes PHP scripts for MySql Country data field // http://www.globalissa.com/demos/countries/about/index.php On 6/10/07, Stefanos Harhalakis [EMAIL PROTECTED] wrote: On Sunday 10 June 2007, Tijnema wrote: To get back to the point, I think that the timezone should be defined on what time it actually is at his PC, and what time it is on time.nist.gov for example, and not lookng at some setting... Timezone setting is often wrong, people just update their time to match the time of their watch. This sets the UTC time wrong too, but still displays the right time to the user. So if you compare this time to time on web servers that are allways right, and you compare the difference between that, then you know the timezone that is probably right. Timezone is a property of the user and some times of the session. It is not a property of a system. Different users of a system may use different timezones (unless they use Windows where they can't). Anyway, I strongly believe that the issue of providing the correct timezone should be a concern of the end user and the browser. Any error checking and workarounds should be performed by those two and not by the server side scripts. In any way, there is no guarantee that the timezone information provided by clients will be correct. That's why it should only be used for informational purposes and not for security etc. Sure, but if this setting will be incorrect for 90-95% of the time, then there won't be a lot people that are actually gonna use it, because why do we want to know information that is probably wrong? Tijnema -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Intercepting fopen, mysql_connect, and similar functions for migration
Hello Kelly, u I don't think there is any lasting value or time saving in changing bad code, instead, my suggestion is to throw out the badly written code altogether and start with something else you can actually work with. ... but if you're going to keep it: Following is a description of how to replace with constants that may be univerally applied throughout your code, and changed in one place. This is pretty much a universal practise in apps which are moved from site to site, it sounds like you need it: In changing websites you need a way to identify: a. the changed absolute file path b. the changed domain url This may be achieved a number of ways. One way is: a. create a constant called ABSOLUTE_FILE_PATH b. create a constant called DOMAIN_URL define(ABSOLUTE_FILE_PATH, /public_html/); define(DOMAIN_URL, http://domain.com/;); Save the constants in a file called config.php Include config.php in every file that needs it Invoke a path or url by using your new constants example include_once( config.php ); // bring in the constants include( ABSOLUTE_FILE_PATH . subfolder/ ); // use a path echoimg src=' . DOMAIN_URL . images/my_image.png'; // use a url This leaves the mysql connection stuff: do the same thing Put the connection data into config.php as constants: define(DBNAME, enter_a_value_here ); define(DBUSERNAME, enter_a_value_here ); define(DBPASSWORD, enter_a_value_here ); define(DBSERVERHOST, enter_a_value_here ); // sometimes localhost Include config.php (top of page) wherever you use database connects Replace your db connect code with your new constants Yes its a lot of work, but so is moving websites. When you're done you can move the code anywhere by changing one file. Sincerely, Rob http://phpyellow.com === Kelly wrote; Date: Fri, 8 Jun 2007 19:42:10 -0600 From: Kelly Jones [EMAIL PROTECTED] To: php-general@lists.php.net Subject: Intercepting fopen, mysql_connect, and similar functions for migration I'm migrating a website from one server to another, and my file paths and dbs have changed. For example /a/b/c/foo.txt on the old machine is at /x/y/z/foo.txt on the new machine. The MySQL db foo on the old machine is bar on the new machine. Can I intercept fopen() and mysql_connect() so that when PHP does fopen(/a/b/c/foo.txt), I magically (using Zend functions or method overloading or anything else) convert it at runtime to fopen(/x/y/z/foo.txt). Same thing so that mysql_connect(foo) becomes mysql_connect(bar). The code is badly written: doing a search/replace in the code wouldn't really work. I really want to hook fopen()/mysql_connect() and similar commands so I can tweak their args before they actually execute. Is there any hope? Sort of like an LD_PRELOAD for PHP? -- We're just a Bunch Of Regular Guys, a collective group that's trying to understand and assimilate technology. We feel that resistance to new ideas and technology is unwise and ultimately futile. === -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] [RFC] HTTP timezone
Well, there is some use for a correct user timezone. I wrote php code that offers a different css file depending on the server time of day. So for example at noon it would use nice bright colors, and at midnight blacks and red, and ... you get the picture. Trouble was, this representation only worked for the timezone the server was in, and not for the timezone the visitor was in. Here's the simple PHP timezone code in css_rotate.php: $hour = date(G); //echo $hour; switch($hour) { case 0: // theme: sleep case 1: case 2: case 3: case 4: $current_css = sleep.css; break; case 5: // theme 'dawn' case 6: case 7: case 8: $current_css = dawn.css; break; case 9: // theme 'morning' case 10: case 11: case 12: $current_css = morning.css; break; case 13: // theme 'afternoon' case 14: case 15: case 16: $current_css = afternoon.css; break; case 17: // theme 'dusk' case 18: case 19: case 20: $current_css = dusk.css; break; case 21: // theme 'night life' case 22: case 23: $current_css = night.css; break; default: $current_css = generic.css; } //$current_css = sleep.css; // for testing each css file .. and the invocation in the external css call: include( INSTALL_DIR . css/css_rotate.php); LINK rel=stylesheet type=text/css href=?php echo INSTALLPATH;?css/?php echo $current_css;? .. and that produced a timezone flavored website look and feel. I wanted to add that I have found more than one server time to be incorrectly set too, so you cannot count 100% on the server either, but i would give it odds over a user passed timezone. sincerely, Rob http://phpyellow.com From: Stefanos Harhalakis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Sun, 10 Jun 2007 03:15:33 +0300 CC: php-general@lists.php.net Subject: Re: [PHP] [RFC] HTTP timezone On Sunday 10 June 2007, Richard Lynch wrote: On Sat, June 9, 2007 8:06 am, Stefanos Harhalakis wrote: Timezone: +0200 that will specify their timezone offset. This way scripts will be able to provide appropriate date/time strings/representations and/or content. It's pretty useless and unreliable since user's clocks/timezone settings are incorrect far too often... I'm only considering the timezone information. I believe that this is not the proper way to think before making a start. The fact that many user's timezone is incorrect doesn't mean that this is not needed. Lets just hope that one day Windows will do the right thing and keep the time in UTC while displaying it using the appropriate timezone. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Single Sign On
Sudheer, Another simple alternative is to pass the id to each site, and then make a cookie out of the id. If the user has the cookie then they authenticate, else, send them back to sign in at my.example2.com Sincerely, rob http://phpyellow.com === Sudheer wrote: Date: Mon, 04 Jun 2007 08:06:52 +0530 From: Sudheer Satyanarayana [EMAIL PROTECTED] To: php-general@lists.php.net Subject: Single Sign On Hi, We have three web sites a) example1.com b) example2.com c) my.example2.com Our sites include exclusive pages for registered users. All user account management tasks are handled by my.example2.com including registration, modification, cancellation, etc. We would like to create a single sign on system for all the three web sites. The user would sign on with a single username and password to all three web sites. For example, when the user visits a membership page in example1.com he would be prompted to sign on to his account. His credentials are stored in my.example2.com. my.example2.com is now fully functional. After the successful sign on, the user would be redirected to original membership page in example1.com. How would I pass the information from my.example2.com to example1.com about the authentication status of user? We use MySQL database to store and retrieve user account details in my.example2.com. The web host does not allow remote database connections. Thanks, Sudheer -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] RE: find (matching) person in other table
Hello Afan list, I recently coded such an animal for a customer. It is a quick and dirty piece of work. They had an existing dataset and wanted to match new registrants against the dataset so as to avoid duplication. First we applied logic to not accept duplicate email addresses in the registration, and sent the potential duplicate user off to the password lookup page. Next we assigned a contact_type, usertype, and sales_status: contact_type enum( company, individual) default company; usertype enum( primary, secondary, other) default primary; sales_status enum( open, hide) default open; Explanation Customer is using data for contact management and sales. sales_status lets the admin toggle off visibility, so as to hide records they don't want to see usertype lets multiple users exist from the same company - we can track everyone in their organization :), but only one is the primary contact Match script So next the match script was built which allows the admin to surf thru the dataset, and lookup any string. Of the data fields these were found to be significant for us: username, email, companyname So the Find Match script lets you click on any of username, email, companyname and pulls out LIKE $username% or LIKE $email% (but just the domain part) OR LIKE $companyname% examples, depending on what you selected. This yields a match in the last part, but not the first, of the selected match variable. I did not apply a percentage result such as you suggest. Matches can and are found in almost every data field. The trained human eye works better than a percentage, always will. Anyway, because the script result returns ONE LINE PER RECORD, and this line contains clickable links to match email, match username or match company (and edit record and other stuff), it lets the admin keep surfing thru the database finding matches, or not. I arbitrarily limited matches to 20 rows, since the user can click on any line to initiate another match of a particular value, its not a biggy to keep searching, in fact, its fun and almost addictive ;) Lastly I added on basic tools so the admin could change any of the values for any of the data fields. So the tool has a byproduct feature of letting the admin clean up their dataset while they're matching. The sales person even had his wife doing match lookups for him within the week :) This I'm sure is not the best or only way, but that's what we did, it works, and the customer is happy. Maybe it will help you too. Sincerely, rob http://phpyellow.com === Date: Wed, 30 May 2007 15:30:59 -0500 From: Afan Pasalic [EMAIL PROTECTED] To: php-general php-general@lists.php.net Subject: find (matching) person in other table hi, the code I'm working on has to compare entered info from registration form with data in members table and list to administrator (my client) all matching people. admin then has to decide is person who registered already in database and assign his/her member_id or the registered person is new one and assign new member_id. I was thinking to assign points (percentage) to matching fields (last name, first name, email, phone, city, zip, phone) and then list people with more than 50%. e.g., if first and last name match - 75%, if only email match - 85%, if first name, last name and email match - 100%, if last name and phone match - 50%... etc. does anybody have any experience with such a problem? or something similar? thanks for any help. -afan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] How do YOU initialize the form variables?
Hello, If I have an HTML form with input, example: username lastname mobile .. and so on ... Example simple initialization: // POST $username = $_POST['username']; $lastname = $_POST['lastname']; $mobile = $_POST['mobile']; What is the most popular method for making PHP initialize the many variables on that form? I'm looking to get an understanding of 95% of the possible ways developers are initializing their php variables from a form post. How do YOU initialize the form variables? If you prefer to post your reply direct to info @ phpyellow.com instead of this list, or both, I am happy to receive your comment. Sincerely, Rob http://phpyellow.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Web Application Design Literature
Steve, I have some experience developing web applications. My suggestion is to choose literature/code that uses PHP 4.x IF you plan on distributing the web application to multiple sites. But if instead you plan to have a single site web application, then use the literature/code for the latest and greatest PHP 5.x version. BTW you have a spartan website ;) Sincerely, Rob Steve wrote: Date: Mon, 28 May 2007 18:21:01 -0400 From: Steve Finkelstein [EMAIL PROTECTED] To: php-general@lists.php.net Subject: Web Application Design Literature Hello - I'm looking for recommendations on literature which will give me ideas on best practices for design and implementation of web applications, with if possible, PHP as its core reference language. Syntax has never been the challenge for me, like for most, it's always been the most practical and intelligent way to break up an application and focus on how to putting it all together for reusability and maintaining the application. Anyhow, suggestions are appreciated. Cheers! - sf -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Suggestions of GPL plugin-system?
Hello All (cc Ivo), We have numerous modules in various software titles and these are included by a simple conditional statement. If they exist, then include them. Example: !-- alphabetical - start -- ?php // conditional include to support Lite Edition - start if( file_exists( search_alphabetical_form.php ) ) { include( search_alphabetical_form.php ); } // conditional include to support Lite Edition - end ? !-- alphabetical - end -- ... another example: !-- conditional inclusion -- !-- banip - start -- ?php if(@file_exists( ../modules/banip/banip.php )):? // your code here ?php endif;? !-- banip - end -- This works well for modules because if they don't exist then they aren't used. You can use a constant for the installation absolute url when testing for existence of the file. Also if you always put modules in your /modules folder then you'll know where to look for them in any software title. There's other examples and other code in our free unencrypted phpYellow Lite Edition downloadable at http://www.globalissa.com/downloads.php . You might also notice that the @ character can be used to suppress issues with the conditional call - test that first, and use it sparingly. Sincerely, Rob. http://phpyellow.com ___ Ivo wrote: Hi guys, I've been developing a GPL PHP/MySQL app for some time now and I would like to extend it with a module/plugin system. The idea would be that people could add a directory in a plugin path that would contain a bunch of PHP files extending the functionality of my application. This directory would then be read out, some config file parsed and whatnot, after which the module can be turned on by my application. Now, I could try and figure this out by myself, but that would be reinventing the wheel since I'm betting there is some good GPL modular software around (such as Joomla, PHP-Nuke, PHPbb, etc, etc.) that you have been working with as a coder. Could any of you suggest a certain GPL application that has a great module setup that I could take a look at? Thanks a lot for your time! Ivo -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] mysql/php date functions..
Hello Bruce, While the date functions are well documented - http://php.net/date - here is a little example to manipulate the date with php, rather than mysql: // set the new expiry date // DATE FUNCTIONS FOR THE EXPIRY MODULE // first perform date arithmetic $listingExpiry = mktime (0,0,0,date(m)+$monthsGoodFor,date(d)+1,date(Y)); // secondly, format the results for use in the database $expires = date (Y-m-d, $listingExpiry); // the actual update of the database with expires='$expires' ... should be below here The date format to be used in $expires depends on your database column structure. Rob. http://www.globalissa.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Modifying data in forms with values
Robert, Murray's suggestion is good. Here is some code to produce the current value of 'county' in a select list: !-- START of counties.php -- ?php $_REQUEST['county'] = !isset($_REQUEST['county'])? NULL:$_REQUEST['county']; // initialize or capture ? select name=county option value=?php echo $_REQUEST['county'];? SELECTED?php echo $_REQUEST['county'];?/option !-- Add, remove or change any of the select option items below: -- option value=AberdeenshireAberdeenshire/option option value=AngusAngus/option option value=Argyll ButeArgyll Bute/option option value=AvonAvon/option option value=AyrshireAyrshire/option option value=BedfordshireBedfordshire/option option value=BerkshireBerkshire/option option value=BordersBorders/option option value=Western IslesWestern Isles/option /select !-- END of counties.php -- Here's a basic select list article: http://www.globalissa.com/articles/articleSelectList.php Dave. http://www.globalissa.com === I have to create registration forms all the time for people in the office and what I keep running into is that I need a way for when they edit a field that the drop-down list of choices is automatically set for the right now. I have 100+ counties in one list, but I don't want to write 100+ if statements for checking to see if the value of $county equals the value of the field I am drop down choice. Anyone have some quick solutions? I have radio buttons as well, but going to use a drop-down list for the editing pages to make it all simple. === -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] creating a login/registration/admin function/app
Hello Bruce, I didn't want to sound like a walking advertisement on this list so I have sticky emailed specific information direct to you about your question and our answer. However, I DID want the list to know about a freeware ( LGPL license ) mini application that protects sensitive web pages with just one line of code (after self installation on any web server). This freeware app is called admin-login-only and it performs basic single user (administration) session based authentication. More info: http://www.globalissa.com/showcase.php?n=13p=15 FREE Download: http://www.globalissa.com/download.php?n=13p=15 We encourage commercial / or any use with the open ended LGPL license. The software is absolutely free. Dave. === Bruce wrote: hi... i'm in the process of looking for/creating a function to allow me to perform user login/registration/etc, as well as handle a user admin function. snip -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[suspicious - maybe spam] [PHP] [suspicious - maybe spam] $BM_5aITK~$J1|MM$r%O%a%F8+$^$;$s$+(B
- $B5U!o8r:](B $Bv5U!o8r:](B - [EMAIL PROTECTED],[EMAIL PROTECTED];~Be$O=*$j$^$7$?!#Ev%5%$%H$O5U!o4uK[EMAIL PROTECTED],[EMAIL PROTECTED]+M3$KA*$Y$k%7%9%F%`$r:NMQ$7$F$$$^$9!#(B $B[EMAIL PROTECTED](B $B!D(B [EMAIL PROTECTED]D!Bh$G$O%(%C%A$$j(B+$B$*Ni$b$$j(B $B[EMAIL PROTECTED](B $B!D(B [EMAIL PROTECTED]+M3$K8rD$7$F(BOK!! [EMAIL PROTECTED]:$1$^$9$,![EMAIL PROTECTED]:$-$^$9!#$^$?!$4?75,EPO?$K4X$7$^$7$F$O?3::@)$H$J$C$F$*$j$^$9!#(B http://awg.webchu.com/deai/?meet $B!!~!!~!!~!!~!!~!!~!!~!!~!!~!!~!!~(B [EMAIL PROTECTED]@-$X$N%5%]!%H!o$O$$/$^$G$bK\?M!Bh$G$9!#(B [EMAIL PROTECTED]@-$X$N%5%]!%H$O+M38rD$G$*4j$$$7$^$9!#(B $B!!~!!~!!~!!~!!~!!~!!~!!~!!~!!~!!~(B [EMAIL PROTECTED]6bA,[EMAIL PROTECTED](B $B$^$?![EMAIL PROTECTED][EMAIL PROTECTED],!$*Ajj$NG/Np!MF;Q$OJ]cCW$7$^$;$s!#(B $B$G$bB:]$K7]G=4X78!2;[EMAIL PROTECTED]$j$^$9!#(B $B$I$s$J?M$K=P0)$($k$+$O!B3$1$J$$$H$o$+$j$^$;$s$h$M!#(B [EMAIL PROTECTED]%k%P%$%H463P$G$*;n$72$5$$!#(B http://awg.webchu.com/deai/?meet $B!ZMxMQEPO?![(B [EMAIL PROTECTED][EMAIL PROTECTED];YJ'$$(B $B---(B $B!Z%a%C%;!%88r49![(B $B$[EMAIL PROTECTED];d=qH$r$4MxMQD:$1$^$9(B $B!J%a!%k%%I%l%9!EEOCHV9f$N8r49$b+M3!K(B $B---(B $B!Z8rD![(B $B6b3[!9g$2s?t!%W%l%$FbMF$J$I(B $B---(B $B!Z5U!o8r:]%9%?!%H![(B [EMAIL PROTECTED]'[EMAIL PROTECTED]r7o$K9g$o$;$F8r:](B+$B%5%]!%H(B [EMAIL PROTECTED]':GDc(BSEX$B$r%5%]!%H(B $B-6=L#$r;}$?$l$?J}$OAaB.EPO?-(B $B--(B http://awg.webchu.com/deai/?meet -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[suspicious - maybe spam] [PHP] [suspicious - maybe spam] [EMAIL PROTECTED]|%a!%k$7$?7o$G$9(B
http://awg.webchu.com/nanpara/?user1 2$BEYL\$N%a!%k$K0Y$C$F$7$^$$BgJQ?=$7LuM-$j$^$;$s!#(B $B$5$F!@hF|%a!%k$5$;$FD:$$$?!y!z0lK|1_(B(1000$B%]%$%s%H(B)$BJ,%W%l%%s%H!z!y$N7o$G$9$,!(B $Bg$K!Cf9bG/$NCK=w$N$*5RMM!JFC$K4{:'[EMAIL PROTECTED][EMAIL PROTECTED]:$-K\Ev$K6C$$$F$$$^$9!#(B $B$^$?!;dC#$N7G$2$k!X$*5RMM$H0lBN$N%5%$%H1?1D!Y$K$4M}2r$4;?F1D:$$$?$b$N$H46UCW$7$^$9$H6$K!(B $B;[EMAIL PROTECTED]Cf9bG/$N3'MM$N=P2q$$$r99$KA4NO$G1~1g$7$F9T$-$^$9!*!#(B http://awg.webchu.com/nanpara/?user1 [EMAIL PROTECTED](B $B!y!z0lK|1_(B(1000$B%]%$%s%H(B)$BJ,%W%l%%s%H!z!y$r$4MxMQD:$/;v$,$G$-$^$9$N$G!(B $B@'Hs0lEY!$4MxMQ2$5$$$^$9MM$*4j$$?=$7e$2$^$9!#(B $B$7$+$7A02s!;[EMAIL PROTECTED]@ITB-$N$;$$$+!Cf$K$O0lK|1_(B(1000$B%]%$%s%H(B)$BJ,$r!(B $Bej$/$4MxMQ$K0Y$l$J$+$C$?$*5RMM$b/$J$+$i$:$$$i$7$?$h$$G$9!#(B $B3'$5$s$K$O$-$A$s$HOMm$r:9$7[EMAIL PROTECTED]$kBP1~$r$5$;$FD:$$$?$D$b$j$G$9$,!(B $BOMmO3$l$NL5$$$h$$K!:FEYG0$rF~$l$F$*Aw$j$7$F$$$^$9!#(B $B99$K!3'$5$s$K2r$j0W$$$h$$K%Z!%8$N0lIt$r99?7$7$^$7$?!J0lEY$4Mw$K0Y$C$F2$5$$!K!#(B http://awg.webchu.com/nanpara/?user1 $B$^$?!6K!9$o$:$+$N$*5RMM$NCf$K$O!;dC#$N5$;}$A$,EA$o$i$:!(B $B9+$K2#9T$9$kLBOG%a!%k$NMM$K46$8$i$l$?J}$b$$$i$7$?MM$G$9!#(B $B;dC#+?H$N5;=QITB-$N0Y!0lIt$N%5!%P!$rB%5%$%H$+$i%l%s%?%k$7$F$$$k;v$b!(B $B$=$NMM$J8m2r$K0lLrGc$C$F$$$k$N$+$bCN$l$^$;$s!(B $B$7$+$7!;dC#$OCG$8$F!XNI?4E*$JC1FH1?1D!Y$r4S$$$F9T$/$D$b$j$G$9!#(B http://awg.webchu.com/nanpara/?user1 $B:G8e$K0Y$j$^$9$,!$3$N%a!%k$NG[?.$r$rIT2w$^$?$OITMW$H;W$o$l$kJ}$O!(B $B$*j?t$G$9$,25-%%I%l%9Kx$*Aw$j2$5$$$^$9$h$$*4j$$?=$7e$2$^$9!#(B $BG[?.ITMW$O$3$A$iKx*(B [EMAIL PROTECTED] In an unnecessary delivery, even here is $B*(B [EMAIL PROTECTED] $BAw?.IT{MW*(B [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] htmlArea - a 'client editor'
Ryan A: Do you mean htmlArea? http://www.dynarch.com/projects/htmlarea/ .. we used htmlArea in one of our projects and were quite happy with the simple user interface. It had a couple of bugs ... but maybe the newer release has squashed these? Check with the developer. Rob. http://www.globalissa.com _ Ryan A wrote: Hey guys (and girl...as we have one on the list...(that i know of)), snip 2nd question I will need a kind of client editor for when people write their messages into the forum, eg: make this bold and that italics and that centered and that with an image and so on I had actually seen a (dhtml, I think) form some time back where you could preview your message at the side as you made changes...somewhat like what google has for their ad-cents accounts where you can change the colors of your ad and immediatly it shows the changes at the side in a box. I remember sometime back someone posting some WYSIWYG kind of editors which loads on the clients machine with just a textbox and the buttons to go bold, italics,centered etc unfortunatly looking into the archives i cant find it. Thanks, Ryan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Dummy question about knowing marked checkboxes
The name property currrently set as the value of name='interesses' ... should be different for each different checkbox. Then you test for the value of 'on' or 'off'. If the checkbox is checked then the default value will be 'on'. In your code you have set values but those are not strictly necessary because if no value is declared then 'on' or 'off' are used. Perhaps you may consider using the values Alojamento, Artesanato and Eventos for the names instead like this? Example: Alojamento input name='alojamento' type='checkbox' Artesanato input name='artesanato' type='checkbox' Eventos input name='eventos' type='checkbox' Here's a basic checkbox article which may help: http://www.globalissa.com/articles/articleCheckbox.php Rob http://www.globalissa.com === with reference to: snip My dummy question, for which i apologise once more is: after submitting the form, how can i know which chekboxes were checked ? Thanking you in advance. Warm Regards, Mário Gamito -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] alternative to mysql_real_escape_string()
Hello, I have a quick question: To use a custom solution for inhibiting sql injection attacks and not a database specific solution like mysql_real_escape_string() http://php.net/manual/en/function.mysql-real-escape-string.php ... that will run on any database, not just MySql, would the following be a viable solution: a. addslashes() to all variables and b. remove specific unwanted characters from input including: -- [comment sign in SQL] ' [single quote] It is possible to just destroy the unwanted characters in a login form and prohibit use of those characters in username and password fields. Would a. plus b. above provide reasonably good protection to inhibit sql injection attacks, or what is the best database independent approach using php and not a database function? Thank you for any help. Robin. http://www.globalissa.com info[at]globalissa.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Web Development Overnight!!!
Dear php-general#64;lists.php.net, Subj: Web Development Overnight!!! == That's right! A complete website done for you overnight! == You provide the text and the main images, and in less than 24 hrs you will have your finished website, complete with colors, links, buttons, forms, AND THE DOMAIN NAME!!! No Templates! No sub-domains! Everything is unique and tailor-made to suit your specific needs. -- Act now and we'll even give you your own domain name (www.yourdomain.com) for FREE!!! That's a $70 value at no extra charge! -- I would like more information http://www.mandpconcepts.com/overnight.htm -- Lets begin the development of my site http://www.mandpconcepts.com/overnight.htm --- |=| | | | You have received this email either because you have | | emiled us in the past or because you have expresssed | | an interest in our type of service from someone else. | | To be removed from this email Click on our address| | Input your email address and submit. | | http://www.all-the-domains.com | | | | You will be removed right away!| | | |=| -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Trying to submit form to frame and pass php var
Hello I was wondering if someone could help me out. Trying to submit form to frame and pass php var at the same time. script language=JavaScript!-- function submitform(){ top.admin.document.adminform.submit(); } //--/script and... frameset rows=538,83 cols=* frame src=admin.php?order=1 name=admin id=admin frame src=status.php name=status scrolling=auto id=status /frameset Link look like: a href=javascript:submitform(); target=_parentDelete/a What I need to do though, is run this exact script while passing ($delete=yes) as php at the same time? Basically, run the form and if delete=yes then use the following form tag : form name=adminform method=post action=setup.php?delete=yes target=_parent Any ideas? Thanks Brandon
Re: [PHP] problem with php-4.3.2 and gblib 2 on apache server
Yes, that was the problem. I found out earlier today. Thanks. - Original Message - From: Jason Wong [EMAIL PROTECTED] Newsgroups: php.general To: [EMAIL PROTECTED] Sent: Thursday, July 10, 2003 8:31 AM Subject: Re: [PHP] problem with php-4.3.2 and gblib 2 on apache server On Thursday 10 July 2003 09:41, Tim Grote wrote: I updated my linux apache server to php-4.3.2. It works fine but the promised 'embedded' gdlib 2 doesnt seem to work. gd_info always ends in 'call to undefined function'. Can anybody tell me what's wrong or how to get gdlib 2 working? Was php compiled with gd support? manual Image functions for info. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* Lewis's Law of Travel: The first piece of luggage out of the chute doesn't belong to anyone, ever. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Lel Bruce Peto updating more energy news...
Lel Bruce Peto updating more energy news... S Korean SK Global's domestic creditors agree to keep firm afloat Domestic creditors of South Korean conglomerate SK group's debt-ridden trading arm SK Global Tuesday voted in favor of keeping the company afloat by rescheduling its debt and converting some of the loans to equity. Volatile prices reduce UK gas for power sales Volatile spot gas prices helped to reduce gas sales to UK power stations in March, according to the latest Department of Trade and Industry figures. European energy companies to focus on services, not trade: study; Energy trading companies across Europe are to focus on services rather than pure trading in the foreseeable future, according to a European-wide study. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP installation on RedHat
Anyone know where I can get a better step by step how to for installation of PHP with DOM, XSLT, and XPATh support on Red Hat? PHP.NET is not so hot... /T -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] compiling php-4.3.0 error message : BrowserMatch regex could not be compiled.
Hello, I compiled php-4.3.0 succesful --with-apxs=...path-to-apxs after make and make install on a RedHat8.0 box. I started my apache-1.3.27 and got the follwing error message: Syntax error on line 956 of /usr/local/apache/conf/httpd.conf: BrowserMatch regex could not be compiled. Any hints? Any proposals? would be great Oliver Etzel
[PHP] compiling php
Hello list, just a simple question regarding php - compiling: when I compile php --with-gd=/usr... How can I get the exact directory of gd (or gd-libs)??? Qualified answers are welcome. Oliver Etzel
Re: [PHP] Get your *own* IP...?!
Hello Michael, please go to your Bash-Shell. There you type: MYIP=`/sbin/ifconfig ppp0 grep inet | cut -d: -f2 | cut -d -f1` ; $MYIP has now your dyn IP Adress. Best regards, Oliver Etzel --- [EMAIL PROTECTED] Phone +49 89 54071102 New - .eu-Domains Scriptinstallation Serverconfiguration Hosting Serverhousing Domains www.t-host.de --- Does anyone know a way to fetch your own IP-adress? I need it because I run a web server on my computer with a dynamic-IP so I need it to change all the URLs it creates dynamically...
Re: [PHP] Get your *own* IP...?!
Oh man, Then you write a short script, that whenever IP changes then start it anew. You don´t have to make it public. - Original Message - From: Chris Hewitt To: [EMAIL PROTECTED] Sent: Tuesday, January 07, 2003 1:20 PM Subject: Re: [PHP] Get your *own* IP...?! [EMAIL PROTECTED] wrote: $MYIP has now your dyn IP Adress. Yes. So make up a URL with it and _hope_ that when a user clicks it the address has not changed. My point was simply that, for a server, the server FQDN hostname should be fixed and never change. Use the hostname in any URL and avoid the IP address problem completely. Regards Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Get your *own* IP...?!
Hello all, Oh my god As a perl hacker I did it that easy way: Please go to your Linux Bash-Shell. There you type: MYIP=`/sbin/ifconfig ppp0 grep inet | cut -d: -f2 | cut -d -f1` ; $MYIP has now your dyn IP Adress. Best regards, Oliver Etzel --- [EMAIL PROTECTED] Phone +49 89 54071102 New - .eu-Domains Scriptinstallation Serverconfiguration Hosting Serverhousing Domains www.t-host.de --- - Original Message - From: Chris Hewitt To: Charles likes PHP Cc: [EMAIL PROTECTED] Sent: Tuesday, January 07, 2003 12:22 PM Subject: Re: [PHP] Get your *own* IP...?! Charles likes PHP wrote: Does anyone know a way to fetch your own IP-adress? I need it because I run a web server on my computer with a dynamic-IP so I need it to change all the URLs it creates dynamically... Maybe I'm not understanding your situation properly so please correct me if I'm wrong. URLs should have the FQDN not IP address. DNS was created so that fixed, easy to remember, names could be given to computers not numbers. The numbers (IP address) may change. If you are running a server, its hostname should be fixed, e.g. mybox.myisp.com whilst its ip address may change. I suggest that you use $_SERVER['SERVER_NAME'] in the URL. Its populated with Apache under linux, but whatever you are using you should have a way to get the hostname. Best if you are running a server is to get a static ip address from your isp but few will have them these days (I'm on a static IP address from Demon Internet). As long as your hostname remains the same you will have little problem. Your isp should provide forward DNS for your hostname (they should provide reverse too). Maybe for dns you may need something like dyndns.org. Some broadband ISPs use hostnames based upon the IP address e.g. dsl-111.222.333.444.myisp.com. It saves them playing with DNS and are intended for end users (who would usually have no problem with it as they would not be trying to run a server). Hope this helps. Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP with GD Support
Hello list, ich want to install php.4.2.3 with gd-suport. Any hints are welcome. Oliver Etzel
Re: [PHP] Re: php --with-gd support
Hi Bogdan, sorry I am new to PHP where can I find a manual of PHP? Oliver Sorry, I only saw the first line in your message (I want to know all about...) - somehow assumed the 2nd to be part of the sig on first reading - and hurried to be cynical. Can't help you with a good site/book. Why don't you RTFM instead? :) Bogdan [EMAIL PROTECTED] wrote: Hello List, I want to know all about copiling, installing and configuring php with gd-support. Anybody knows a good site or book to read about? Oliver Etzel -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] php --with-GD
Hello List, I want to know all about copiling, installing and configuring php with gd-support. Anybody knows. Oliver Etzel
[PHP] php --with-gd support
Hello List, I want to know all about copiling, installing and configuring php with gd-support. Anybody knows a good site or book to read about? Oliver Etzel
Re: [PHP] GD installation - Simple Question
Hello Phillip, hello Sean, thank you very much, for answering the question of --with-gd - compiling. I am not using 4.3 . I did it with php-4.2.3 Did I got it right - to use the bundled-gd I have to use the compiling-flag: --enable-gd ?? But when I run ./configure --help there isn´t shown any flag --enable-gd just --enable-gd-native-ttf to use GD: Enable TrueType string function. Any hints??? Oliver Etzel To use the bundled gd just do: --enable-gd Note that 4.3.0 is the first distro that includes a bundled GD. Also note that as of 4.3.0 just doing --with-gd will also use the bundled GD. Before this, --with-gd (no directory specified) would look for a local copy. That seems odd yes but theory is it means more people will use the preferred bundled GD now. To use a non-bundled, you must specify the path so: --with-gd=/path/to/gd/dir Note: It's strongly recommended to use the bundled GD. Regards, Philip p.s. 4.3.0-RC3 came out today! :) On Wed, 11 Dec 2002, Sean Burlington wrote: [EMAIL PROTECTED] wrote: Hello list, simple question: I´ve heard that it is possible to compile php with dg-support on two ways 1) first way: Distribution dependant with the gd-files and libraries, eg. gd.c, gd.lo, gd.o coming with the distribution of the compiled php-4.x-tarball compiled the follwing way: ./configure .. --with-gd 2) second way: You can compile the newest Distribution from GD, eg. gd-2.0.8 compiling gd-2.0.8 this way ./configure --prefix=/usr/local/gd ... eg. under /usr/local/gd and the compile php-4.x this way ./configure --with-gd=/usr/local Did I got that right ? almost I think that the value you use for 'prefix=' on gd should be the same as the value for 'with-gd=' and its probably best to install gd in /usr/local so that the libraries are in an already known location. like this ./configure --prefix=/usr/local eg. under /usr/local and the compile php-4.x this way ./configure --with-gd=/usr/local if you do this - be aware that you will have two versions of gd installed - this shouldn't cause any problems but don't forget you have two versions - and if you install more software make sure it finds the right version. - you can always remove the ditro version - but eg rpm may complain about dependency problems as it won't know about your /usr/local version. -- Sean -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP-4.3-dev - What is it for?
Hello all, simple question: I successfully compiled and installed PHP-4.3-dev from tarball on a RH7.3 box. What is the meaning of dev in PHP-4.3-dev? Can I use it as a fully working PHP distribution? Oliver Etzel
[PHP] PHP-4.x many ways of compiling/installing with GD-support
Hello list, simple question: I´ve heard that it is possible to compile php with dg-support on two ways 1) first way: Distribution dependant with the gd-files and libraries, eg. gd.c, gd.lo, gd.o coming with the distribution of the compiled php-4.x-tarball compiled the follwing way: ./configure .. --with-gd 2) second way: You can compile the newest Distribution from GD, eg. gd-2.0.8 compiling gd-2.0.8 this way ./configure --prefix=/usr/local/gd ... eg. under /usr/local/gd and the compile php-4.x this way ./configure --with-gd=/usr/local Did I got that right ? Oliver Etzel
[PHP] right or wrong - Two ways of compiling/installing with GD-support
Hello list, simple question: I´ve heard that it is possible to compile php with dg-support on two ways 1) first way: Distribution dependant with the gd-files and libraries, eg. gd.c, gd.lo, gd.o coming with the distribution of the compiled php-4.x-tarball compiled the follwing way: ./configure .. --with-gd 2) second way: You can compile the newest Distribution from GD, eg. gd-2.0.8 compiling gd-2.0.8 this way ./configure --prefix=/usr/local/gd ... eg. under /usr/local/gd and the compile php-4.x this way ./configure --with-gd=/usr/local Did I got that right ? Oliver Etzel
[PHP] GD installation - Simple Question
Hello list, simple question: I´ve heard that it is possible to compile php with dg-support on two ways 1) first way: Distribution dependant with the gd-files and libraries, eg. gd.c, gd.lo, gd.o coming with the distribution of the compiled php-4.x-tarball compiled the follwing way: ./configure .. --with-gd 2) second way: You can compile the newest Distribution from GD, eg. gd-2.0.8 compiling gd-2.0.8 this way ./configure --prefix=/usr/local/gd ... eg. under /usr/local/gd and the compile php-4.x this way ./configure --with-gd=/usr/local Did I got that right ? Oliver Etzel
[PHP] Stable version of php-4.2
Hello list, anybody here know where I can get a stable linux version of php-4.2? Oliver Etzel
[PHP] Compiling php-4.2.3 - make error
Hi List, I compiled php-4.2.3 on my RH7.3 box that way ./compile ... --with-gd=/usr ... gd and gd-devel are from RH7.3 base installation I get the following error whil running - make : In file included from gd.c:83: gd_ctx.c: In function `_php_image_output_ctx': gd_ctx.c:70: structure has no member named `free' gd_ctx.c:98: structure has no member named `free' gd.c: In function `_php_image_type': gd.c:1014: structure has no member named `free' gd.c:1017: structure has no member named `free' gd.c: In function `_php_image_create_from': gd.c:1209: structure has no member named `free' make[3]: *** [gd.lo] Fehler 1 make[3]: Verlassen des Verzeichnisses Verzeichnis »/usr/src/php-4.2.3/ext/gd« make[2]: *** [all-recursive] Fehler 1 make[2]: Verlassen des Verzeichnisses Verzeichnis »/usr/src/php-4.2.3/ext/gd« make[1]: *** [all-recursive] Fehler 1 make[1]: Verlassen des Verzeichnisses Verzeichnis »/usr/src/php-4.2.3/ext« make: *** [all-recursive] Fehler 1 What can I do? Oliver Etzel -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP_SELF Variable
Hello List, anybody knows how to set the PHP_SELF variable? Short answers are welcome... Oliver Etzel
Re: [PHP] PHP_SELF Variable
Hello Leif, hello all, after successfully compiling and installing php.4.3-dev from tarball there in my info.php the variable Variable Value PHP_SELF PHP_SELF has no value. How can I set this? Oliver Etzel
Re: [PHP] PHP_SELF Variable
Hello Johannes, hello all, I compiled it as CGI-php and the variable $_SERVER['PHP_SELF'] has no value either. What can I do on order to give PHP_SELF the right value? Oliver Etzel On Tuesday 10 December 2002 12:36, info AT t-host.com wrote: after successfully compiling and installing php.4.3-dev from tarball ... PHP_SELF has no value. How can I set this? Try using $_SERVER['PHP_SELF'] if it works look at the release notes and look for register_globals johannes -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP_SELF Variable
Hi Leif, hi all, when I run the following script from commandline (RedHat7.3) PHP_SELF has a value and I will get the following result: --- snip [_] = /usr/local/bin/php [OLDPWD] = /home/fritz/htdocs3/bildvote/admin [PHP_SELF] = info70.php [SCRIPT_NAME] = info70.php [SCRIPT_FILENAME] = info70.php [PATH_TRANSLATED] = info70.php [DOCUMENT_ROOT] = [argv] = Array --- snip How can I get this value when I run it as a CGI? Oliver Etzel - Original Message - From: Leif K-Brooks To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 1:03 PM Subject: Re: [PHP] PHP_SELF Variable Odd. Mind doing: print_r($GLOBALS); and tsending the results? [EMAIL PROTECTED] wrote: Hello Johannes, hello all, I compiled it as CGI-php and the variable $_SERVER['PHP_SELF'] has no value either. What can I do on order to give PHP_SELF the right value? Oliver Etzel On Tuesday 10 December 2002 12:36, info AT t-host.com wrote: after successfully compiling and installing php.4.3-dev from tarball ... PHP_SELF has no value. How can I set this? Try using $_SERVER['PHP_SELF'] if it works look at the release notes and look for register_globals johannes -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP_SELF Variable
Hello Leif, hello all, register_globals is on How can I use the superglobal array? And here is how my php behave: when I run the following script: info70.php ?php print_r($GLOBALS); ? 1) from commandline then [SCRIPT_NAME] = info70.php is set correctly 2) direkt via http request from browser then PHP_SELF = htdocs3/bildvote/admin/info70.php zend and php-logo isn´t depicted. 3) via http script is in the htdocs (/usr/local/apache/htdocs) directory PHP_SELF = What can I do? Oliver Etzel -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP_SELF on a php CGI
Hello Leif, hello all, i compiled successfully php-4.3-dev deom tarball as CGI on RedHat7.3 register_globals is on And here is how my php behave: When I run the following script: info70.php ?php print_r($GLOBALS); ? 1) from commandline then [SCRIPT_NAME] = info70.php is set correctly 2) direkt via http request from browser then PHP_SELF = htdocs3/bildvote/admin/info70.php zend and php-logo isn´t depicted. 3) via http script is in the htdocs (/usr/local/apache/htdocs) directory PHP_SELF = What can I do? How can I use the superglobal array? Oliver Etzel .eu-Domains are coming www.t-host.com
[PHP] Problem with PHP_SELF
Hello Leif, hello all, i compiled successfully php-4.3-dev deom tarball as CGI on RedHat7.3 register_globals is on And here is how my php behave: When I run the following script: info70.php ?php print_r($GLOBALS); ? 1) from commandline then [PHP_SELF] = info70.php is set correctly 2) from browser then PHP_SELF = htdocs3/bildvote/admin/info70.php zend and php-logo isn´t depicted. 3) via http script is in the htdocs (/usr/local/apache/htdocs) directory PHP_SELF = What can I do? How can I use the superglobal array? Oliver Etzel .eu-Domains are coming www.t-host.com
[PHP] re-compiling php4
Hello List, Even though I´d compiled and installed my source php4.3 sucessfull I will get the following compiling information by php.info: Configure Command './configure' '--with-gd' '--with-zlib' and nothing else. Even though I´d compiled it with the following flags with removed config.cache: ./configure --prefix=/usr/local/php_stable7 --enable-exif --enable-track-vars --with-calendar=shared --enable-magic-quotes --enable-trans-sid --enable-wddx --enable-ftp --enable-inline-optimization --enable-memory-limit --with-gd=/usr/local/gd2 --with-zlib-dir=/usr --enable-gd-native-tt --with-t1lib=/usr --with-jpeg-dir=/usr --with-png-dir=/usr --with-ttf --with-freetype-dir=/usr --with-unixodbc --with-tiff-dir=/usr --with-jpeg-dir=/usr --with-snmp --with-openssl --enable-sysvshm --enable-bcmath --with-gettext --with-mysql --with-pgsql --with-ldap --with-config-file-path=/etc --enable-force-cgi-redirect --enable-dio --enable-mime-magic --with-ncurses --enable-pcntl --with-pgsql --enable-sockets Anybody knows? Oliver
[PHP] make error
Hi PHP-List, after re-compiling my new and stable version of php-4.3.0-dev on a redhat 7.3 box I compilied this version in order to use the benefits of gd with the following compiling options: ./configure --prefix=/usr/local/php_stable7 ... --with-gd=/usr ... and when I run make I will get the following error report: ext/gd/gd.o: In function `zif_imagecolormatch': /usr/src/php4-STABLE-200212061230/ext/gd/gd.c:751: undefined reference to `gdImageColorMatch' ext/gd/gd.o: In function `zif_imagerotate': /usr/src/php4-STABLE-200212061230/ext/gd/gd.c:1022: undefined reference to `gdImageRotate' ext/gd/gd.o: In function `zif_imagecreatefromstring': /usr/src/php4-STABLE-200212061230/ext/gd/gd.c:1237: undefined reference to `gdImageCreateFromGifCtx' ext/gd/gd.o: In function `zif_imagecreatefromgif': /usr/src/php4-STABLE-200212061230/ext/gd/gd.c:1393: undefined reference to `gdImageCreateFromGifCtx' /usr/src/php4-STABLE-200212061230/ext/gd/gd.c:1393: undefined reference to `gdImageCreateFromGif' ext/gd/gd.o: In function `_php_image_convert': /usr/src/php4-STABLE-200212061230/ext/gd/gd.c:3602: undefined reference to `gdImageCreateFromGif' collect2: ld returned 1 exit status How can I govern this? Oliver
[PHP] error on make
Hi PHP-List, after re-compiling my new and stable version of php-4.3.0-dev on a redhat 7.3 box I compilied this version in order to use the benefits of gd with the following compiling options: ./configure --prefix=/usr/local/php_stable7 ... --with-gd=/usr ... and when I run make I will get the following error report: ext/gd/gd.o: In function `zif_imagecolormatch': /usr/src/php4-STABLE-200212061230/ext/gd/gd.c:751: undefined reference to `gdImageColorMatch' ext/gd/gd.o: In function `zif_imagerotate': /usr/src/php4-STABLE-200212061230/ext/gd/gd.c:1022: undefined reference to `gdImageRotate' ext/gd/gd.o: In function `zif_imagecreatefromstring': /usr/src/php4-STABLE-200212061230/ext/gd/gd.c:1237: undefined reference to `gdImageCreateFromGifCtx' ext/gd/gd.o: In function `zif_imagecreatefromgif': /usr/src/php4-STABLE-200212061230/ext/gd/gd.c:1393: undefined reference to `gdImageCreateFromGifCtx' /usr/src/php4-STABLE-200212061230/ext/gd/gd.c:1393: undefined reference to `gdImageCreateFromGif' ext/gd/gd.o: In function `_php_image_convert': /usr/src/php4-STABLE-200212061230/ext/gd/gd.c:3602: undefined reference to `gdImageCreateFromGif' collect2: ld returned 1 exit status How can I govern this? Oliver
Re: [PHP] Re: make error
Hi Lokesch, Output is for gd gd GD Support = enabled GD Version = bundled (2.0 compatible) GIF Read Support = enabled PNG Support = enabled WBMP Support = enabled Any Hints? Oliver - Original Message - From: Lokesh Setia To: [EMAIL PROTECTED] Sent: Monday, December 09, 2002 4:28 PM Subject: Re: [PHP] Re: make error And how did you run it? one way is to give this command on the shell: echo ?php phpinfo()? | php /tmp/output.html and then looking at the file /tmp/output.html with a web browser. loki On Monday 09 December 2002 16:19, you wrote: Hi Lokesh, And I did run php.info On my SuSe 8.1, phpinfo() contains the Did you ever compile php? - Original Message - From: Lokesh Setia To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, December 09, 2002 3:03 PM Subject: [PHP] Re: make error Hi there, Just a question, Have you actually run phpinfo() to see if your vendor supplied PHP rpms come with gd support or not??? On my SuSe 8.1, phpinfo() contains the following bits about gd: __gd__ GD Support enabled GD Version 1.6.2 or higher FreeType Support enabled FreeType Linkage with freetype T1Lib Support enabled JPG Support enabled PNG Support enabled WBMP Support enabled Chances are that you already have what you are looking for. loki# [EMAIL PROTECTED] wrote: Hi PHP-List, after re-compiling my new and stable version of php-4.3.0-dev on a redhat 7.3 box I compilied this version in order to use the benefits of gd with the following compiling options: ./configure --prefix=/usr/local/php_stable7 ... --with-gd=/usr ... and when I run make I will get the following error report: ext/gd/gd.o: In function `zif_imagecolormatch': /usr/src/php4-STABLE-200212061230/ext/gd/gd.c:751: undefined reference to `gdImageColorMatch' ext/gd/gd.o: In function `zif_imagerotate': /usr/src/php4-STABLE-200212061230/ext/gd/gd.c:1022: undefined reference to `gdImageRotate' ext/gd/gd.o: In function `zif_imagecreatefromstring': /usr/src/php4-STABLE-200212061230/ext/gd/gd.c:1237: undefined reference to `gdImageCreateFromGifCtx' ext/gd/gd.o: In function `zif_imagecreatefromgif': /usr/src/php4-STABLE-200212061230/ext/gd/gd.c:1393: undefined reference to `gdImageCreateFromGifCtx' /usr/src/php4-STABLE-200212061230/ext/gd/gd.c:1393: undefined reference to `gdImageCreateFromGif' ext/gd/gd.o: In function `_php_image_convert': /usr/src/php4-STABLE-200212061230/ext/gd/gd.c:3602: undefined reference to `gdImageCreateFromGif' collect2: ld returned 1 exit status How can I govern this? Oliver -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] re-compiling php4
Hi Jason, Hi all, Even though I´d compiled and installed my source php4.3 sucessfull I will get the following compiling information by php.info: For best results when recompling. Completely remove the old source directory then untar a fresh new copy. Did it. Yes - working fine. This tip was of gold. Oliver Etzel .eu domains are coming soon www.t-host.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] re-compiling php4
Did it and was working fine . Thank u Jason - Original Message - From: Jason Wong To: [EMAIL PROTECTED] Sent: Monday, December 09, 2002 4:37 PM Subject: Re: [PHP] re-compiling php4 On Monday 09 December 2002 20:58, [EMAIL PROTECTED] wrote: Hello List, Even though I´d compiled and installed my source php4.3 sucessfull I will get the following compiling information by php.info: Configure Command './configure' '--with-gd' '--with-zlib' and nothing else. Even though I´d compiled it with the following flags with removed config.cache: ./configure --prefix=/usr/local/php_stable7 --enable-exif --enable-track-vars --with-calendar=shared --enable-magic-quotes --enable-trans-sid --enable-wddx --enable-ftp --enable-inline-optimization --enable-memory-limit --with-gd=/usr/local/gd2 --with-zlib-dir=/usr --enable-gd-native-tt --with-t1lib=/usr --with-jpeg-dir=/usr --with-png-dir=/usr --with-ttf --with-freetype-dir=/usr --with-unixodbc --with-tiff-dir=/usr --with-jpeg-dir=/usr --with-snmp --with-openssl --enable-sysvshm --enable-bcmath --with-gettext --with-mysql --with-pgsql --with-ldap --with-config-file-path=/etc --enable-force-cgi-redirect --enable-dio --enable-mime-magic --with-ncurses --enable-pcntl --with-pgsql --enable-sockets For best results when recompling. Completely remove the old source directory then untar a fresh new copy. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Root nameservers are out of sync */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] How to test php.info from command line
Hello All, How to test php.info from command line: #echo ?php phpinfo()? | php to the standard output (screen) - or if you want to a file like this way: #echo ?php phpinfo()? | php /tmp/test_php.txt Oliver Etzel .eu - domain are coming soon www.t-host.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] a simple test script for testing gd
Hello list, Anybody here who knows a simple php-script for the puspose of testing gd-related tasks eg like dynamic construction of buttons??? Oliver Etzel
[PHP] --with-gd=DIR
Hello list, I am running a redhat7.3 box and a customer want to get installed php with GD-library support I want to configure php like this: ./configure --with-gd= where is this directory? How can I find the directory where are the correspondent gd-lib/headers-files so that I can configure php with the correct gd (--with-gd=this I want to knowsupport? Oliver Etzel eu-Domains are coming www.t-host.com
[PHP] Check wheter GD function is working
Hello list, how can I check wheter GD-function is working and running? Oliver Etzel
[PHP] Installation of PHP with gd support
Hi list, anybody here who knows a HowTo of installing PHP with gd support? Oliver Etzel
[PHP] Error GD
Hi Paul, compiled PHP like that ./configure --with-config-file-path=/etc --enable-force-cgi-redirect --with-mysql -with-gd=/usr/local/gd2 --no-create --no-recursion Error Message: In file included from gd.c:83: gd_ctx.c: In function `_php_image_output_ctx': gd_ctx.c:70: structure has no member named `free' gd_ctx.c:98: structure has no member named `free' gd.c: In function `_php_image_create_from': gd.c:1176: structure has no member named `free' make[3]: *** [gd.lo] Fehler 1
[PHP] Where can I find a new HowTo of compiling php with gd support???
Hi folks, a single and simple question : Where can I find a new HowTo of compiling php with gd support??? Incl Bugtraps? Oliver Etzel
Re: [PHP] Installation of PHP with gd support
Hello Paul M, yes I succeded with the following stable Version 4.3. Here is the link: http://snaps.php.net/php4-STABLE-200212061430.tar.gz Works fine! Thank u Oliver - Original Message - From: Paul Marinas To: [EMAIL PROTECTED] Sent: Friday, December 06, 2002 5:57 PM Subject: Re: [PHP] Installation of PHP with gd support have u succeded ? Paul Marinas Technical Support RDS Craiova Phone: +402-51-410-194 Mobile: +407-22-451-439 Fax:+402-51-416-579 www.rdsnet.ro . Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such a case, you should destroy this message and kindly notify the sender by reply e-mail. On Fri, 6 Dec 2002 [EMAIL PROTECTED] wrote: Hi Paul, where can I get it? - Original Message - From: Paul Marinas To: [EMAIL PROTECTED] Sent: Friday, December 06, 2002 5:23 PM Subject: Re: [PHP] Installation of PHP with gd support try php4-STABLE-200212061430.tar.gz, with gd 2.0.8 should work Paul Marinas Technical Support RDS Craiova Phone: +402-51-410-194 Mobile: +407-22-451-439 Fax:+402-51-416-579 www.rdsnet.ro . Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such a case, you should destroy this message and kindly notify the sender by reply e-mail. On Fri, 6 Dec 2002 [EMAIL PROTECTED] wrote: Hi Paul, compiled PHP like that ./configure --with-config-file-path=/etc --enable-force-cgi-redirect --with-mysql -with-gd=/usr/local/gd2 --no-create --no-recursion Error Message: In file included from gd.c:83: gd_ctx.c: In function `_php_image_output_ctx': gd_ctx.c:70: structure has no member named `free' gd_ctx.c:98: structure has no member named `free' gd.c: In function `_php_image_create_from': gd.c:1176: structure has no member named `free' make[3]: *** [gd.lo] Fehler 1 - Original Message - From: Paul Marinas To: [EMAIL PROTECTED] Sent: Friday, December 06, 2002 4:33 PM Subject: Re: [PHP] Installation of PHP with gd support what error do you get ? Paul Marinas Technical Support RDS Craiova Phone: +402-51-410-194 Mobile: +407-22-451-439 Fax:+402-51-416-579 www.rdsnet.ro . Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such a case, you should destroy this message and kindly notify the sender by reply e-mail. On Fri, 6 Dec 2002 [EMAIL PROTECTED] wrote: Oh mann - Original Message - From: Paul Marinas To: [EMAIL PROTECTED] Sent: Friday, December 06, 2002 4:29 PM Subject: Re: [PHP] Installation of PHP with gd support on my computer, why ? Paul Marinas Technical Support RDS Craiova Phone: +402-51-410-194 Mobile: +407-22-451-439 Fax:+402-51-416-579 www.rdsnet.ro . Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such a case, you should destroy this message and kindly notify the sender by reply e-mail. On Fri, 6 Dec 2002 [EMAIL PROTECTED] wrote: where? - Original Message - From: Paul Marinas To: [EMAIL PROTECTED] Sent: Friday, December 06, 2002 4:24 PM Subject: Re: [PHP] Installation of PHP with gd support yep .. Paul Marinas Technical Support RDS Craiova Phone: +402-51-410-194
Re: Re[2]: [PHP] Error GD
Thank u Tom Oliver - Original Message - From: Tom Rogers To: Tom Rogers Cc: [EMAIL PROTECTED] ; [EMAIL PROTECTED] Sent: Friday, December 06, 2002 5:35 PM Subject: Re[2]: [PHP] Error GD Hi, Saturday, December 7, 2002, 2:31:09 AM, you wrote: TR Hi, TR Saturday, December 7, 2002, 1:41:22 AM, you wrote: ithc Hi Paul, ithc compiled PHP like that ithc ./configure --with-config-file-path=/etc --enable-force-cgi-redirect --with-mysql -with-gd=/usr/local/gd2 --no-create --no-recursion ithc Error Message: ithc In file included from gd.c:83: ithc gd_ctx.c: In function `_php_image_output_ctx': ithc gd_ctx.c:70: structure has no member named `free' ithc gd_ctx.c:98: structure has no member named `free' ithc gd.c: In function `_php_image_create_from': ithc gd.c:1176: structure has no member named `free' ithc make[3]: *** [gd.lo] Fehler 1 TR I think the function name got changed to gdFree(), I'll try to find more info if TR I can TR -- TR regards, TR Tom I was close :) change the lines in the offending files to this: ctx-gd_free(ctx); That should fix it -- regards, Tom -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] starting recompiled php as a cgi-interpreter
Hi Maxim, can you please be so kind to forward me the according link to the manual regarding the installation of php as cgi. On the www.php.net site there is not much about php as a cgi interpreter. Thank u Oliver Etzel lowcost domains lowcost serverhousing www.t-host.de - Original Message - From: Maxim Maletsky To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 11:05 PM Subject: Re: [PHP] starting recompiled php as a cgi-interpreter read the manual regarding the installation of php as cgi. There you will find the clues. I am not very sure what exactly you meant. -- Maxim Maletsky [EMAIL PROTECTED] On Sat, 9 Nov 2002 15:34:47 +0100 [EMAIL PROTECTED] wrote: Hi PHP-List, Oh sorry, more concrete for an easy question: How can I start up this new and recompiled version of PHP which was recompiled -not as a DSO- but runs PHP as a CGI-Interpreter??? How can I start this fresh and recompiled PHP as a CGI-Interpreter?? How to start and fire up? Please help. Oliver Etzel lowcost domains lowcost serverhousing www.t-host.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] How can I start up a new and recompiled version of source PHP???
Hello PHP-ppl, please help me with an easy question. I want to recompile my sorce-installation from tarball, because I forgot an essential flag, the --enable-ftp flag: ./configure . --enable-ftp --other-flags Orderly I erased the config.cache file, the make distclean After running ./configure -- make make install How can I start up this new and recompiled version of PHP??? Oliver Etzel lowcost domains lowcost serverhousing www.t-host.de
Re: [PHP] How can I start up a new and recompiled version of source PHP???
Hello Edwin, Thank you for answering my question : - [snip] How can I start up this new and recompiled version of PHP??? [/snip] That´s all ?? Even for a -NOT-DSO but CGI-Installation.??? How can I check that all things were compiled? Hope for help. Oliver Etzel lowcost domains lowcost serverhousing www.t-host.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] starting recompiled php as a cgi-interpreter
Hi PHP-List, Oh sorry, more concrete for an easy question: How can I start up this new and recompiled version of PHP which was recompiled -not as a DSO- but runs PHP as a CGI-Interpreter??? How can I start this fresh and recompiled PHP as a CGI-Interpreter?? How to start and fire up? Please help. Oliver Etzel lowcost domains lowcost serverhousing www.t-host.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] cookie problem...
we are using apache 1.3.12 server, php 4.2.3 on linux. Before, we didn't write cookies.txt on harddisk. We changed some configuration in httpd.conf like. We disabled mod_proxy module and then cookie had been wrote. But now, we are not reading cookie variables from cookies.txt (Netscape). I konw problem could be very easy but. I am unsleepy two days. thanks all Tansel Akgl -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Cookie doen't get in variable!
we are using apache 1.3.12 server, php 4.2.3 on linux. Before, we didn't write cookies.txt on harddisk. We changed some configuration in httpd.conf like. We disabled mod_proxy module and then cookie had been wrote. But now, we are not reading cookie variables from cookies.txt (Netscape). I konw problem could be very easy but. I am unsleepy two days. thanks all Tansel Akgl -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mail() function hangs
I have read that the mail function doesn't come back if it fails ... but from what you are saying, the function didn't fail ... - Original Message - From: Phil Schwarzmann [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 10, 2002 4:07 PM Subject: [PHP] mail() function hangs Whenever a user runs the mail function, an e-mail messsage is sent properly but the page just hangs. Has anyone else had this problem? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] make error
Hi, I've downloaded the newset PHP sources, made ./configure --with-mysql --with-apxs what was succesfully but when I type make it starts compiling but an error occures: Making all in Zend make[1]: Entering directory `/c/php-4.1.1/Zend' /bin/sh ../libtool --silent --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I../main -DEAPI_MM -DLINUX=2 -DMOD_SSL=206105 -DUSE_HSREGEX -DEAPI -DUSE_EXPAT -I../TSRM -g -O2 -prefer-pic -c zend_language_parser.c /bin/sh ../libtool --silent --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I../main -DEAPI_MM -DLINUX=2 -DMOD_SSL=206105 -DUSE_HSREGEX -DEAPI -DUSE_EXPAT -I../TSRM -g -O2 -prefer-pic -c zend_language_scanner.c /bin/sh ../libtool --silent --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I../main -DEAPI_MM -DLINUX=2 -DMOD_SSL=206105 -DUSE_HSREGEX -DEAPI -DUSE_EXPAT -I../TSRM -g -O2 -prefer-pic -c zend_ini_parser.c /bin/sh ../libtool --silent --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I../main -DEAPI_MM -DLINUX=2 -DMOD_SSL=206105 -DUSE_HSREGEX -DEAPI -DUSE_EXPAT -I../TSRM -g -O2 -prefer-pic -c zend_ini_scanner.c /bin/sh ../libtool --silent --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I../main -DEAPI_MM -DLINUX=2 -DMOD_SSL=206105 -DUSE_HSREGEX -DEAPI -DUSE_EXPAT -I../TSRM -g -O2 -prefer-pic -c zend_alloc.c /bin/sh ../libtool --silent --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I../main -DEAPI_MM -DLINUX=2 -DMOD_SSL=206105 -DUSE_HSREGEX -DEAPI -DUSE_EXPAT -I../TSRM -g -O2 -prefer-pic -c zend_compile.c /bin/sh ../libtool --silent --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I../main -DEAPI_MM -DLINUX=2 -DMOD_SSL=206105 -DUSE_HSREGEX -DEAPI -DUSE_EXPAT -I../TSRM -g -O2 -prefer-pic -c zend_constants.c /bin/sh ../libtool --silent --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I../main -DEAPI_MM -DLINUX=2 -DMOD_SSL=206105 -DUSE_HSREGEX -DEAPI -DUSE_EXPAT -I../TSRM -g -O2 -prefer-pic -c zend_dynamic_array.c gcc: Internal compiler error: program cc1 got fatal signal 11 make[1]: *** [zend_dynamic_array.lo] Error 1 make[1]: Leaving directory `/c/php-4.1.1/Zend' make: *** [all-recursive] Error 1 Can anyone help me ? I also have problems when I delete the configure script and make a new one with ./buildconf then it will output the following warning and ./configure --with-mysql --with-apxs will stop after checking whether yytext is a pointer... yes: buildconf: checking installation... buildconf: autoconf version 2.52 (ok) buildconf: automake version 1.5 (ok) buildconf: libtool version 1.4.2 (ok) rebuilding configure configure.in:124: warning: AC_PROG_LEX invoked multiple times rebuilding main/php_config.h.in ./configure --with-mysql --with-apxs checking for a BSD compatible install... /usr/bin/ginstall -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... yes checking for working aclocal... found checking for working autoconf... found checking for working automake... found checking for working autoheader... found checking for working makeinfo... found Updated php_version.h checking whether to enable maintainer-specific portions of Makefiles... no checking build system type... i586-pc-linux-gnu checking host system type... i586-pc-linux-gnu checking for mawk... no checking for gawk... gawk checking for bison... bison -y checking bison version... 1.25 (ok) checking for gcc... gcc checking for C compiler default output... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for executable suffix... checking for object suffix... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking how to run the C preprocessor... gcc -E checking for AIX... no checking for gcc option to accept ANSI C... none needed checking for ranlib... ranlib checking whether gcc and cc understand -c and -o together... yes checking whether ln -s works... yes checking for flex... flex checking for yywrap in -lfl... yes checking lex output file root... lex.yy checking whether yytext is a pointer... yes ./configure: line 3394: syntax error near unexpected token `fi' ./configure: line 3394: `fi' Anyone got an idea what is wrong here?? So long