RE: [PHP] Server Uptime
There is no function, but you could shell out and grab the output from the uptime command and use regex to parse the resultsor use one command line with uptime piped to awk to pull out what you need. HTH! --Sam -Original Message- From: Brad Ciszewski [mailto:[EMAIL PROTECTED] Sent: Monday, February 07, 2005 3:21 PM To: php-general@lists.php.net Subject: [PHP] Server Uptime What is the function, or how do you make a script that displays the server's uptime? Thanks, Brad Ciszewski www.BradTechnologies.com Web Services -- 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] PHP Hosting
I think you mean GEOS :) --Sam -Original Message- From: Alex Hogan [mailto:[EMAIL PROTECTED] Sent: Friday, July 09, 2004 8:15 AM To: [EMAIL PROTECTED] Subject: RE: [PHP] PHP Hosting Don't you require Windows 3.1.11 for proper network support :) - at least 3.1 was stable. Poke fun all you want.., Everyone knows the real OS was Warp! ;-) *onward flamewar soldiers* alex hogan * The contents of this e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. The views stated herein do not necessarily represent the view of the company. If you are not the intended recipient of this e-mail you may not copy, forward, disclose, or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please e-mail the sender. * -- 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] Function Date
Use the strtoupper function: http://www.php.net/strtoupper HTH! --Sam -Original Message- From: Juan Pablo Herrera [mailto:[EMAIL PROTECTED] Sent: Monday, June 14, 2004 11:05 AM To: [EMAIL PROTECTED] Subject: [PHP] Function Date Hi! I am using date(j M Y), the format date is 14 Jun 2004, but i need this format 14 JUN 2004. The unique difference is Jun - JUN. How can i change this?. Thank You, Juan -- 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] Re: WDDX
Hehe must be too early on a Monday for Craig :) --Sam -Original Message- From: Craig [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 9:31 AM To: [EMAIL PROTECTED] Subject: [PHP] Re: WDDX take a look on http://www.phpclasses.org Good luck, Craig Dave Avent [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi All, Does anyone know if there is a WDDX Class for PHP. I have googled and checked phpclasses.org. I am unable to recompile my webserver so I cannot include wddx support that way, so if anyone can help me with any suggestions I would be very gratefull Cheers Dave -- 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] php email functionality
What sorts of errors are you seeing in your log? --Sam -Original Message- From: Shawn Beard [mailto:[EMAIL PROTECTED] Sent: Friday, April 02, 2004 8:11 AM To: [EMAIL PROTECTED] Subject: [PHP] php email functionality I just upgraded to PHP 4.3.5 and now my email functionality does not work. I do have the SMTP setting in the php.ini set up and did restart Apache. We are running a Windows 2000 server and Apache 2.0.49. Any ideas? Shawn Beard Web Administrator Iowa Foundation for Medical Care Information Systems [EMAIL PROTECTED] Office: 515-440-8581 Pager: 515-208-5907 -- 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] date()
Are you sure that you aren't echoing something else somewhere in your script as well? My output from this code is: 18/03/04 --Sam Khalid Judeh wrote: hello all, i am new to php, i am trying to call the date function this way: ?php echo date(d/m/y); ? and the result i get is: object18/03/04 any help would be appreciated Khaled Jouda cell. phone: 0163-2382758 fax: 1(801)439-1253 alternative email: [EMAIL PROTECTED] _ Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Simple: Whats wrong with this?
This drove me nuts for a while and instead of doing $variable++ I started using ++$variable and never had the problem again. --Sam Jake McHenry wrote: No. $correct++; Is all you need for the second condition, it automatically sets itself back. Does this always work? In my timesheet app, I have to do $counter = $counter + 1, because for some reason the $counter++; doesn't work. It just + doesn't work, no incrementation of the variable. Is there something in php.ini that can prohibit this from working? Thanks, Jake -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] I have a problem In Mail Function
This doesn't sound like it has anything to do with the mail function. It appears that your newsletter is getting caught by their spam filters. --Sam PHP wrote: Hi In a web application I need to send mail for each members whith a different content . mail message must be in HTML Format and 1256 code page I call mail() functoin in a simple loop to send multiple mail message with differrent content. now I want know that is any body know better method to do it ?? but I have bigest problem when I send message to yahoo mail server ,yahoo rout my message to bulk mail and I cant solve this problem please tell me if you have know solution. my send mail is come below: function send_mail($to,$subject,$message){ $headers = MIME-Version: 1.0\r\n; $headers .= Content-type: text/html; charset=windows-1256\r\n; $headers .= From: Me [EMAIL PROTECTED]\r\n; $headers .= Return-path: Me [EMAIL PROTECTED]\r\n; $headers .= Reply-To: Me [EMAIL PROTECTED]\r\n; // $headers .= Bcc: $to \r\n; if (mail($to, $subject, $message, $headers)) print($to Send Ok!br); else print(b$to Send Problem/b!br); } thanks -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Re: ASP to PHP language problems
Not trying to sound rude or anything, but have you looked up the mysql functions at http://php.net/mysql in your research? I would start with mysql_connect(), mysql_query(), and mysql_fetch_array()/mysql_result(). There are lots of user notes on each page as well which should be of assistance. HTH! --Sam Alistair Hayward wrote: Thanks Chris, Believe me, I have been doing research non-stop for a few days now and this is my last resort. The problem is the language. I can't find what I'm looking for on the net because I don't know what it's called. I have worked out how to create a connection to a mySQL server and database. (after spending so much time configuring and installing PHP and mySQL for the first time) I now know how to use include files. I can not figure out how to create a recordset and call fields from the record set while performing a loop. I have done heaps of research, but have not found what I need. Chris W. Parker wrote: Alistair Hayward mailto:[EMAIL PROTECTED] on Wednesday, March 10, 2004 2:46 PM said: This is what I get when I try to create the recordset Notice: Use of undefined constant DBlink - assumed 'DBlink' in D:\Development\Completed\Sealhouse\phpSealTest\ProductSpecs.php on line 24 well you're going to need to do a *little* research on your own. oh what the heck... DBlink is the same as your cnn in your asp code. in other words you still need to create a connection to a database. chris. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Re: ASP to PHP language problems
Since I am assuming Type is a text field, you will want to enclose it in single quotes. Also, because I am anal retentive, I like to also use the addslashes() function on any input coming in on the GET string or via a POST. Also, since all variables are preceded by a $ character, your call to mysql_query will fail. So, I would change your code to something like this: $type = addslashes($_GET['type']); $sql = SELECT * FROM tbCategory WHERE Type ='$type' order by style; $resultID = mysql_query($sql, $db); HTH! --Sam Alistair Hayward wrote: This is what I have: ?php $connection = mysql_connect(localhost,root,batman); if (!$connection) { echo Couldn't make a connection!; exit; } $db = mysql_select_db(sealhouse, $connection); if (!$db) { echo Couldn't select database!; exit; } $type = $_GET['type']; $sql = SELECT * FROM tbCategory WHERE Type =$type order by style; $resultID = mysql_query($sql, DB); Chris W. Parker wrote: Alistair Hayward mailto:[EMAIL PROTECTED] on Wednesday, March 10, 2004 2:46 PM said: This is what I get when I try to create the recordset Notice: Use of undefined constant DBlink - assumed 'DBlink' in D:\Development\Completed\Sealhouse\phpSealTest\ProductSpecs.php on line 24 well you're going to need to do a *little* research on your own. oh what the heck... DBlink is the same as your cnn in your asp code. in other words you still need to create a connection to a database. chris. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Problem with cookies on new server
If the install on the new server is a fresh install, you might want to start by comparing the php.ini files being used on both machines to see where they differ. HTH! --Sam Teren wrote: Hey, I'm having some trouble with one of my scripts that is on a new server I just launched. The scripts worked fine on the old server, so i'm pretty sure it's a php configuration problem. The problem is that i am using cookies on the script with the setcookie() function. It looks like the cookies aren't getting created or anything. anyone have any ideas? Thanks Teren -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] PHP logging into htaccess Auth
I believe that using http://; in the front of the URL is required when using this syntax. --Sam [EMAIL PROTECTED] wrote: Hi there i am having issues trying to get php to log into a htaccess protected directory. I used be able to simply have the username and password in the url like username:[EMAIL PROTECTED]/directory/to/protect now i get invalid syntax, any ideas ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] odd, sporatic upload problem ...
How long is it before the Page Not Found error occurs? Is the browser possibly timing out? --Sam Kenn Murrah wrote: Greetings. I have an odd (to me) problem ... from most computers, the upload code (shown, in part, below) works just fine but from at least one computer, if the user uploads a small file (under 1meg), it works properly . but if he uploads a larger file he gets either a page not found (Internet Explorer) or no data (Netscape) error other users can upload files of any size, with no problem Does anyone have any ideas? The code (though I'm not at all sure it's relevent) is below: $customer_trimmed = eregi_replace([^[:alnum:]\.],,$customer) ; $customer_shortened = substr($customer_trimmed,0,18); $customer_trimmed = $customer_shortened; $folder_name = $customer_trimmed . date(mdyHis); $old_umask = umask(); mkdir('/home/upco/uploads/' . $folder_name, 0777); //umask($old_umask); $dest_dir = '/home/upco/uploads/' . $folder_name; error_reporting(0); $summary_info = You have successfully uploaded the following file(s):br ; for ($i=0; $icount($_FILES['userFile']['name']); $i++) { $new_name = $_FILES['userFile']['name'][$i]; $parsed_name = eregi_replace([^[:alnum:]\.],,$new_name) ; $dest = $dest_dir . '/' . $parsed_name; if (!file_exists ($dest)) { copy($_FILES['userFile']['tmp_name'][$i], $dest) ; $changepermissions = chmod($dest, 0777); -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] odd, sporatic upload problem ...
You're sure that the computer in question doesn't possibly have a previous version of the page cached? Any sort of proxy server setup in that browser that isn't on the others? Sorry for the mundane questions...just trying to cover some of the obvious points... --Sam -Original Message- From: Kenn Murrah [mailto:[EMAIL PROTECTED] Sent: Friday, March 05, 2004 2:58 PM To: Sam Masiello Cc: php Subject: Re: [PHP] odd, sporatic upload problem ... No, it happens immediately upon clicking the submit button on the previous page Sam Masiello wrote: How long is it before the Page Not Found error occurs? Is the browser possibly timing out? --Sam Kenn Murrah wrote: Greetings. I have an odd (to me) problem ... from most computers, the upload code (shown, in part, below) works just fine but from at least one computer, if the user uploads a small file (under 1meg), it works properly . but if he uploads a larger file he gets either a page not found (Internet Explorer) or no data (Netscape) error other users can upload files of any size, with no problem Does anyone have any ideas? The code (though I'm not at all sure it's relevent) is below: $customer_trimmed = eregi_replace([^[:alnum:]\.],,$customer) ; $customer_shortened = substr($customer_trimmed,0,18); $customer_trimmed = $customer_shortened; $folder_name = $customer_trimmed . date(mdyHis); $old_umask = umask(); mkdir('/home/upco/uploads/' . $folder_name, 0777); //umask($old_umask); $dest_dir = '/home/upco/uploads/' . $folder_name; error_reporting(0); $summary_info = You have successfully uploaded the following file(s):br ; for ($i=0; $icount($_FILES['userFile']['name']); $i++) { $new_name = $_FILES['userFile']['name'][$i]; $parsed_name = eregi_replace([^[:alnum:]\.],,$new_name) ; $dest = $dest_dir . '/' . $parsed_name; if (!file_exists ($dest)) { copy($_FILES['userFile']['tmp_name'][$i], $dest) ; $changepermissions = chmod($dest, 0777);
RE: [PHP] Re: Parse error ???
This is because the file is uploaded as the user running the web server process; apache, in this case. --Sam Mike Mapsnac wrote: It works now. I run the script as user mike and mike:mike is owner of the directory, when I upload something to directory the owner of the file is apache:apache. Why the owner of the file is not mike ? thanks From: Neil Freeman [EMAIL PROTECTED] To: Mike Mapsnac [EMAIL PROTECTED] CC: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: [PHP] Re: Parse error ??? Date: Thu, 04 Mar 2004 13:58:26 + If I remember correctly the second parameter of move_uploaded_file() needs to be the full filename, ie path plus required filename. so... if(!move_uploaded_file($_FILES['myfile']['tmp_name'], (/var/www/html/upload/ . $_FILES['myfile']['name']))) Neil Mike Mapsnac wrote: *** This Email Has Been Virus Swept *** brackets solve the probleb. But why I have the warning messages? The permission on the directory is correct. Any ideas what can cause such messages? Warning: move_uploaded_file(/var/www/html/upload/): failed to open stream: Is a directory in /var/www/html/uploadproc.php on line 11 Warning: move_uploaded_file(): Unable to move '/tmp/phpiMrdlQ' to '/var/www/html/upload/' in /var/www/html/uploadproc.php on line 11 Error Moving the uploaded file failed. From: Michael Nolan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP] Re: Parse error ??? Date: Thu, 04 Mar 2004 13:40:46 + Mike Mapsnac wrote: The script should upload files (images). Error message is give below, any ideas why I get this errror message? Parse error: parse error in /var/www/html/uploadproc.php on line 3 die() needs brackets around its arguments, eg: die(Error! The expected file wasn't a part of the submitted form); Mike -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ One-click access to Hotmail from any Web page - download MSN Toolbar now! http://clk.atdmt.com/AVE/go/onm00200413ave/direct/01/ -- -- www.curvedvision.com -- This communication is confidential to the intended recipient(s). If you are not that person you are not permitted to make use of the information and you are requested to notify the sender immediately of its receipt then destroy the copy in your possession. Any views or opinions expressed are those of the originator and may not represent those of Advanced System Architectures Ltd. *** This Email Has Been Virus Checked *** _ Frustrated with dial-up? Lightning-fast Internet access for as low as $29.95/month. http://click.atdmt.com/AVE/go/onm00200360ave/direct/01/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Link List
Are you sure that file exists? When I try to access it with my browser I get a 404. --Sam Lopez, Kaleb (GEAE, Foreign National, CIAT) wrote: I'm sorry. I got confused. I'm using file. Here's a part of the code, more or less. I don't get anything. The table is blank. // I'm creating the array here. $inputfile = file('http://aepd.mtc.ge.com/portal/test/links.inc'); // Here come the links... foreach ($inputfile as $line_num = $linea) { echo a href=http://; . htmlspecialchars($linea) . br /\n; Thanks -Original Message- From: Matt Matijevich [mailto:[EMAIL PROTECTED] Sent: Thursday, March 04, 2004 4:00 PM To: Lopez, Kaleb (GEAE, Foreign National, CIAT); [EMAIL PROTECTED] Subject: Re: [PHP] Link List snip I have tried to use readline to make this happen, but I'm getting error messages. Somebody with a suggestion about this? /snip have any code samples or example error messages for us? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] frameset und php-script in frame
Yes, they are wide enough...i was speaking of long enough. In other words, be sure the top frame doesn't scroll. The code as you posted it works fine, but on my display it barely fits in the top frame. On a lower resolution you might not see the text in the top frame. Have you tried making your top frame bigger (change the 83 to 200) to see if you can see the text? --Sam joe-at wrote: Thanks for the hint, but the frames are wide enough. I also tried it on my test server and on a real web server with the same result. Sam Masiello [EMAIL PROTECTED] schrieb im Newsbeitrag news:[EMAIL PROTECTED] . I am afraid that I don't get the same problem that you do. If I request frameset.html in my browser I get the text that you are echoing in your PHP statement in the top frame. Is it possible that your resolution is such that you need to scroll in the top frame to see it? Try viewing the source of the top frame to see if the contents of your echo statement is in there. --Sam joe-at wrote: hi pleas help me, when I try to use php in a frame of a frameset it dos not work. what is wrong with my files? fameset.html: html head titleframeset/title /head frameset rows=83*,377* cols=* frame src=test.php name=topFrame frame src=Info.htm name=mainFrame /frameset noframes/noframes body /body /html test.php: html head titletest/title /head body pJetzt sollt ein PHP-Skript erscheinen:/p ?php echo Wer fersteht das noch? ? /body /html result of the top frame (test.php): Jetzt soll ein PHP-Skript erscheinen: test.php works without frameset: Jetzt sollt ein PHP-Skript erscheinen: Wer fersteht das noch? Thanks for help joe-at -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] function.date.php
Actually, your use of substr is incorrect. The third parameter is how many characters you want to go from your offset, not the ending character. Also, your last variable shouldn't be year...it should be day (or whatever you want to name it...anything but year or month :) ), otherwise you will overwrite your previously set year with the day of the month :) Aside from that, you can use the date function once you fix your code a bit: $mynewdate = date(F d, Y, mktime(0, 0, 0, $month, $day, $year) ; HTH! --Sam John Taylor-Johnston wrote: Is there a way to reverse engineer http://www.php.net/manual/en/function.date.php ? I want to feed in 2003-02-28 and extract February 28, 2003. I can substr it out ... $eventid = 2003-02-28; $year = substr($eventid, 0,4); $month = substr($eventid, 5,7); $year = substr($eventid, 8,10); But there must be a function that would do it? Everything else exists :) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Parsing large log files with PHP
Are you getting an error when trying to read/parse your log file? If so, what is that error? --Sam Pablo Gosse wrote: Hi folks. Has anyone encountered any problems parsing large log files with PHP? I've got a log file that's about 1.2 gig that I need to parse. Can PHP handle this or am I better of breaking this down into 12 100mb chunks and processing it? Any advice is appreciated. Cheers, Pablo -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] What's wrong with this code please?
If you want to see the contents of an array, use the print_r function: http://www.php.net/print_r HTH! --Sam Donpro wrote: $emails = array([EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED]); $addresses = explode(,,$emails); for ($i=0; $i count($addresses); $i++) { echo $i . ': ' . $addresses[$i] . 'br'; if ($i == count($addresses) - 1) $form['recipient'] .= $addresses[$i]; else $form['recipient'] .= $addresses[$i] . ','; } echo 'Recipient = ' . $form['recipient'] . 'br'; The output I am receiving is: 0: Array Recipient = Array Obviously, I want to see the output of each array element as well as the final contents of $form['recipient']. Thanks in advance, Don -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] date functions
Depending on your database engine (which you didn't mention in your post), some allow you to format the date however you want it as you pull it out of the database in your sql query. I always find this to be the easiest way to do it. That way you don't have to worry about formatting the data after it has been output from your query. HTH! --Sam Matthew Oatham wrote: Hi, You might already be fed up with my posts but I'm a complete PHP newbie and find these groups are the best way to learn! Anyway I have the database date in the format: -mm-dd hh:mm:ss e.g. 2004-02-24 07:57:59 but when in some situations I only want to show the user the date in the format dd-mm- what is the correct / best php function to use for this purpose ? Cheers. Matt -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] apache mysql php windows
I believe you are looking for: http://www.easyphp.org HTH! --Sam Shane Nelson wrote: Hi Folks A few days ago on the list I saw someone mention a package that includes apache, mysql and php for Windows. The one install file included all these programs. Anyone remember what it was? I've checked google and searched through my email list but I can't seem to find it! Thanks, Shane -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Transfering a file
How about FTP? --Sam Mike Koponick wrote: Hello everyone, I will apologize in advance if this has been discussed previously. I would like transfer a file that is created by PHP. Once written, I need to transfer (or write it) to another server. The destination server is on another network behind a firewall, whereas the front end is in a DMZ. Both of these servers are Linux (Redhat 9.0) and I REALLY don't want to use NFS because of security reasons. Is there another route I should look at? Thanks in advance, Mike -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] frameset und php-script in frame
I am afraid that I don't get the same problem that you do. If I request frameset.html in my browser I get the text that you are echoing in your PHP statement in the top frame. Is it possible that your resolution is such that you need to scroll in the top frame to see it? Try viewing the source of the top frame to see if the contents of your echo statement is in there. --Sam joe-at wrote: hi pleas help me, when I try to use php in a frame of a frameset it dos not work. what is wrong with my files? fameset.html: html head titleframeset/title /head frameset rows=83*,377* cols=* frame src=test.php name=topFrame frame src=Info.htm name=mainFrame /frameset noframes/noframes body /body /html test.php: html head titletest/title /head body pJetzt sollt ein PHP-Skript erscheinen:/p ?php echo Wer fersteht das noch? ? /body /html result of the top frame (test.php): Jetzt soll ein PHP-Skript erscheinen: test.php works without frameset: Jetzt sollt ein PHP-Skript erscheinen: Wer fersteht das noch? Thanks for help joe-at -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: Re[2]: [PHP] Self Submitting Form
Ah ha! I think I found where the problem lies(and also our confusing disconnect). Even though you and I were doing pretty much the same thing, your case worked fine in the instance where the parameter being submitted in the self submitting form was only one word. If you changed your test case to something like hi there (which is what I was using in my testing), it breaks. Why? The parameter needs to be urlencoded first. Thank you very much for your help and suggestions, Toby! I really appreciate your time and effort in helping me to see the light. --Sam Toby Irmer wrote: Hi Sam, I did that only because I was too lazy to upload and did the testing locally so I could grab the value in Javascript. Of course it works with post as well... test.html form name=myform1 method=get action= input type=hidden name=myvar1 value=testing script window.open(test2.html, test); /script /form test2.html BODY onLoad=document.forms[0].submit(); form name=myform1 method=post action=test.php INPUT TYPE=hidden NAME=do_preview VALUE=1 script document.write('INPUT TYPE=hidden NAME=itworks VALUE='+opener.myform1.myvar1.value+''); /script /FORM /BODY test.php ? print_r($_POST); Outputs: Array ( [do_preview] = 1 [itworks] = testing ) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Php and GpG
What is the error that you get when you try to use gpgext? --Sam Paul Marinas wrote: Those anyone know hoh to use php with gpg. I've tryed gpgext, but doesn't seems to work maybe my php is not compiled with some kind of support. thanks Paul GnuPG Key http://sgi.rdscv.ro/~paulm/paulm.PGP -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Can anyone tell me why this code doesn't insert anything?
What happens if you echo out $query to the browser window and try to copy and paste the query into a command line mysql session (be sure to connect to the database using the same authentication credentials that you have in the script)? Does it work? --Sam Brian Dunning wrote: This inserts nothing into the database, but returns no error that I can see. How come? What's wrong with it? $dbname = my_database; $dbconnection = mysql_connect(mysql05.powweb.com,my_user,my_pass); mysql_select_db($dbname, $dbconnection); $query = INSERT INTO invoices ('ip','total','creation','first_name','email','session','last_name') VALUES ('0.0.0.0','0.00',NOW(),'Bob','[EMAIL PROTECTED]','12345','Smith'); $result = mysql_query($query); -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] saving form data
If the PHP configuration doesn't have register_globals turned on in the php.ini file, you will be able to access the form variables via the _POST array like this: $_POST[my_form_var] Of course, substitute my_form_var with the correct variable from the form that you are submitting. If the server does have register_globals turned on you can access the variables just as they are named in the form. For example, if you have a text input field named lastname, you can access the value in that text box using the variable $lastname. HTH! --Sam Charlie Fiskeaux II wrote: I'm using a prebuilt Perl form mailer script for a project, but because the form is so long, my client would like to give the user the ability to save the data and come back to finish it later. I was hoping to be able to code this part in PHP (because I don't know Perl), but I'm fairly new to PHP and don't know how to get one form to go to two different places. Because the target of the form is the Perl script (for emailing the submitted form), how can I grab the data from the form with PHP? -- Charlie Fiskeaux II Media Designer Cre8tive Group cre8tivegroup.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Self Submitting Form
My apologies if this post is somewhat OT. I am having some trouble figuring something out, and I am hoping you can help. I have a PHP web form on which a user can enter a number of different things into both text and textarea fields. At the bottom of the form is a preview button which opens another browser window. I know I can use the GET string to pass these form fields from one PHP page to another, but with textareas involved and the possibly large amounts of text being passed, I didn't want to run the possibility of overrunning the limit on a GET string. So I figured using a form POST would be more appropriate. My thought was to create a self submitting form in the child window, but I am having trouble getting it to work (or maybe I should try a different method entirely to do this...any suggestion welcome!). My code for the preview window (which contains the self submitting form is as follows: ? if ($do_preview) { echo $myvar; exit; } ? HTML HEAD TITLE/TITLE META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 /HEAD BODY onLoad=document.preview_form.submit() BGCOLOR=#FF TEXT=#00 LINK=#00 FORM NAME=preview_form METHOD=post ACTION=? echo $PHP_SELF ? INPUT TYPE=hidden NAME=do_preview VALUE=1 script document.write('INPUT TYPE=hidden NAME=myvarVALUE='+opener.myform1.myvar1.value+''); /script /FORM /BODY /HTML (I also tried doing an eval within the VALUE attribute, but all that did was set myvar to the text that I had between the quotes :) ) When I click the preview button on the parent window, I would like to see the value of the myvar1 variable when the form self submits...unfortunately, I get nothing. I know it is getting into my $do_preview block at the top, and I am accessing the variable correctly because if I do an alert(opener.myform1.myvar1.value), I get the proper value. Any thoughts would be greatly appreciated! --Sam -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Self Submitting Form
Hi Toby! Thank you for your suggestion, but unfortunately you are using GET in your test2.html file. I specifically stated in my initial email that due to the fact that I am using textareas in my original form (your test1.html) that I did not want to use GET for it might run the risk of overstepping the bounds of how many characters the browser will accept in the GET string. Any other suggestions that anyone else has would be most appreciated as I am still pretty stuck on this. As always, thanks in advance! --Sam From: Toby Irmer [mailto:[EMAIL PROTECTED] Sent: Fri 2/20/2004 6:07 PM To: Sam Masiello Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Self Submitting Form Hi Sam, I am not sure I know what you want to do... I tried to recreate your problem: test.html form name=myform1 method=get action= input type=hidden name=myvar1 value=testing script window.open(test2.html, test); /script /form test2.html BODY onLoad=document.forms[0].submit(); form name=myform1 method=get action=test3.html INPUT TYPE=hidden NAME=do_preview VALUE=1 script document.write('INPUT TYPE=hidden NAME=itworks VALUE='+opener.myform1.myvar1.value+''); /script /FORM /BODY test3.html script language=Javascript function parseQueryString (str) { str = str ? str : location.search; var query = str.charAt(0) == '?' ? str.substring(1) : str; var args = new Object(); if (query) { var fields = query.split(''); for (var f = 0; f fields.length; f++) { var field = fields[f].split('='); args[unescape(field[0].replace(/\+/g, ' '))] = unescape(field[1].replace(/\+/g, ' ')); } } return args; } var args = parseQueryString (); for (var arg in args) { document.write(arg + ': ' + args[arg] + 'BR'); } /script And the output is: do_preview: 1 itworks: testing As should be expected... Pls try to specify your problem. toby
RE: [PHP] compile problem
The --with-curl directive can also take a directory (--with-curl=[DIR}). Try passing in the directory where cURL is installed to. (I am not sure where this is since you didn't mention whether cURL is installed on your system via RPM or if you did it from source). Good luck! --Sam Donpro wrote: Hi, trying to compile PHP 4.3.4. on RedHat Linux 7.3 and getting the following error: checking for CURL support... yes checking for CURL in default path... found in /usr checking for cURL 7.9.8 or greater... configure: error: cURL version 7.9.8 or later is required to compile php with cURL support I am compiling with the --with-curl option AND I have curl 7.10.4 installed. Any ideas? Thanks, Don -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Backslashing the [ and ] in a regex
I am kind of stuck on a problem that I am hoping you can help with. I am working on an application where the user can input a regular expression into a text box on a web form. This regular expression will be put into a postgres database, then later into an XML file. My dilemma is that if a user backslashes characters like +, *, etc I use the line below to put an extra backslash on those before they go into the database: $rule = ereg_replace([[:alpha:]+*/.|()$], 0, $rule) ; But if the user backslashes either a left or right bracket ([ or ]), I am having difficulty getting that extra backslash into the string. I tried just adding the [ and ] characters to the line above between the and () characters, but that didn't work along with several other iterations of attempts to get it to work. Does anyone have any ideas? I am stuck. TIA! --Sam -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Backslashing the [ and ] in a regex
Thank you for the reply, Adam, but unfortunately it didn't work. --Sam Adam Bregenzer wrote: On Wed, 2004-02-04 at 14:06, Sam Masiello wrote: $rule = ereg_replace([[:alpha:]+*/.|()$], 0, $rule) ; But if the user backslashes either a left or right bracket ([ or ]), I am having difficulty getting that extra backslash into the string. I tried just adding the [ and ] characters to the line above between the and () characters, but that didn't work along with several other iterations of attempts to get it to work. Does anyone have any ideas? I am stuck. Try adding \\[\\] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Newbie question
It appears as if you don't have MySQL support compiled in with your PHP build. If you installed it from source you will want to recompile PHP with the --with-mysql option. I have never installed PHP from RPM though so if you installed it that way, perhaps someone else in the group can provide some guidance on how to do that. HTH! --Sam James Marcinek wrote: Hello Everyone, I'm new to this so forgive my ignorance. I'm trying to use php with MySQL as a database. I'm using apache 2.0 in addition to Mysql 4.1. I created a simple page (using book to learn) and when I try to go to a simple php script I recieve the following error: Call to undefined function: mysql_connect() I've followed the instructions and the mysql_connect() function has the correct arguments supplied (host, user, passwd); Can anyone shed any light on this? I've looked at the php.ini file and it looks ok. the apache has the php.conf file in the conf.d directory. The book I'm learning from had some simple examples pages that I created early on and they work; however this is the first attempt at trying to use php to connect. Any help would be appreciated. Thanks, James -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Parse error in mysql_query()
Perhaps it doesn't like the fact that you don't have quotes around your array keys? --Sam Tyler Longren wrote: Error: Parse error: parse error, expecting `']'' in /usr/local/apache/htdocs/UP/index.php on line 871 Line 871: mysql_query(INSERT INTO domainregistrations (domain,type,years,price) VALUES ('$_POST[domainregister_domain$i]','$_POST[domainregister_type$i]','$_PO ST[domainregister_years$i]','$_POST[domainregister_price$i]')); Anyone know why that parse error is happening? I can't find a missing ] anywhere. Any help would be greatly appreciated. Thanks, Tyler Longren -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PEAR::SOAP using PHP...please help!
I have posted this question to both the PHP SOAP and the PEAR General lists and have not received a reply on either list (not a very responsive group, I guess :) ) so I thought I would try to reach a larger audience in hopes that perhaps one of you out there might be able to help. Any assistance that ANYONE can provide would be more than appreciated...I am really stuck on how to proceed here as calling the client script doesn't produce ANY output, even if I change the return from emailSubmit from the SOAP_Value to a simple string...nothing. I have done a couple of SOAP projects before using the NuSOAP library and XML-RPC, but my latest project has me working with a client who wants to use doc+literal instead of XML-RPC and I am having a very hard time with it, and was hoping you all could help. Do I need to be doing this differently because it is doc+literal instead of XML-RPC? Is it even more different because the XML also has complex types? I have gone to many different sites and seen many different variations of how to do many different things, but I am having a LOT of trouble getting any sort of output from my client code. I have tried many different code variations for just a simple test client. This is what I am currently on: /* START CLIENT CODE */ require_once(SOAP/Client.php) ; $url = http://path_to_my_wsdl/mywsdl.wsdl; ; $wsdl = new SOAP_WSDL($url); $client = $wsdl-getProxy() ; $params=array('header'='hi', 'body'='there') ; $options=array( 'namespace' = 'urn:mxlogic.outlookaddin', 'style' = 'document', 'use' = 'literal'); print $client-emailSubmit($params, $options); /* END CLIENT CODE */ /* START SERVER CODE */ require_once(SOAP/Server.php) ; class SOAP_My_Server { var $dispatch_map = array(); function SOAP_My_Server() { $this-dispatch_map['pingService'] = array( 'in'= array(), 'out' = array('pingReturn'= array('ack'='boolean', 'time'='int'))) ; $this-dispatch_map['emailSubmit'] = array( 'in'= array('header'='string', 'body'='string'), 'out' = array('submitReturn'='boolean')) ; } function emailSubmit($header, $body) { return new SOAP_Value('return', 'boolean', true); } function pingService() { $myreturn = array('ack'='1', 'time'='3600') ; return new SOAP_Value('return', 'pong', $myreturn) ; } } $options = array('namespace'='urn:mxlogic.outlookaddin','type'='document','use'= 'literal') ; $server=new SOAP_Server; $soapmyserver= new SOAP_My_Server; $server-addObjectMap($soapmyserver,$options); $server-service($GLOBALS['HTTP_RAW_POST_DATA']); /* END SERVER CODE */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Help with php output to file
Anytime I need to do something similar to this I prefer to use lynx -source [[URL]] [[output_file]] HTH! --Sam Paul Godard wrote: Hi I have develop an online catalog in php/mysql. Now the client needs the web site on a cd. Of course without php or mysql... What is the fastes and easiest way to convert the only 2-3 dynamic php pages into static html files? Of course I could copy the html code generated by the php pages for each product and save it as different product1.html product2.html ... but that will take ages ... 2000 products in 2 languages. Is there a way to redirect the output of php pages to a file instead of to the screen? So I could create a simple php script that loop for each product languages to generate all the pages. -- Kind regards, Paul. Gondwana [EMAIL PROTECTED] http://www.gondwanastudio.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] MySQL newsgroup
The URL below lists all of the MySQL mailing lists. Just choose the one that is most specific to your issue: http://lists.mysql.com/ HTH! --Sam JLake wrote: Can anyone point my to a MySQL specific SQL newsgroup. having some problem corectly extracting data. Thanks, J -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] What is a XSS attacks?
That is correct. http://www.derkeiler.com/Mailing-Lists/securityfocus/bugtraq/2003-11/006 5.html --Sam Richard Davey wrote: Hello orlandopozo, Saturday, December 13, 2003, 12:04:02 AM, you wrote: oicv What is a XSS attacks? Cross Site Scripting Attack I think. Like when people insert malicious HTML/JS code into your site as a result of your code not checking inputs properly. -- Best regards, Richardmailto:[EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] display settings
Since PHP is a server side language, you cannot get information like the users display settings. If you want this information, you will need to use a client side language like Javascript or VBScript. --Sam Hartley, Matt wrote: I am sort of new at this, I am wondering if it is possible to find the display settings of the user I know that ?php echo $_SERVER[HTTP_USER_AGENT]; ? will give you Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) is there one that will recover the display settings of the user? Matt -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] can mail() function send emails to any email account?
Did you get a bounce? Perhaps to the root account on your local machine? Some domains do reverse DNS lookup and if sendmail is not configured properly the receiving domain might kick the email back if it doesn't recognize where the email claims to be coming from. --Sam -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 9:46 AM To: See Kok Boon; php-general Subject: RE: [PHP] can mail() function send emails to any email account? [snip] Hello.. it's me again. Trying to use mail() function to send emails to hotmail accounts. It seems that it's not working. Tried the same function on my own email account, it worked. Tried on some other, it doesn't. What determines if the mail() function works? [/snip] Whether or not it is installed properly. If it is it will send e-mails to any given e-mail address. Perhaps the hotmail account is set up to deflect unknown users as spam? -- 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] Dealing with large classes over several files
This URL might be of some assistance to you: http://www.php.net/manual/en/ref.classobj.php It is a page on how to write classes and its associated member functions in PHP. There are a couple of other pages in the documentation which may be of assistance to you as well. HTH! --Sam -Original Message- From: Callum Urquhart [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 10:57 AM To: [EMAIL PROTECTED] Subject: [PHP] Dealing with large classes over several files This may well have come up before as it is an obvious problem/question. Coming from a C++ background, I define a class in a header file and define the functions for that class in a seperate source file. Now the question: is this possible in PHP4? I have tried the obvious: // myclass.inc.php class foo { // constructor and destructor function f () {} } // myclass.php function foo::f () { // define here } This gives me an error: unexpected T_PAAMAYIM_NEKUDOTAYIM Is this possible in PHP4, and if not, why not? It's an obvious problem, namely for code management. -Callum Urquhart www.pastecode.net -- 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] Argh! nulls un stuff..
How about something like this: if ($_SESSION[temp] 0) ? Or if you want to be really sure: if ($_SESSION[temp] 0 $_SESSION[temp] != ) ORif you want to be sure the value is a number as well: if ($_SESSION[temp] 0 $_SESSION[temp] != is_numeric($_SESSION[temp]) HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Francis [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 9:23 AM To: [EMAIL PROTECTED] Subject: [PHP] Argh! nulls un stuff.. ok going mad all I need to do is check a variable and if it has a number in it then do something, so anything from 0 up, but it keeps thinking 0 is null and failing, anyway around this? or am I just being stupid as usual? $_SESSION[temp] = 0; $tempVar = 0; if($_SESSION[temp] !=){ echo != conditionbr; } if(isset($_SESSION[temp])){ echo isset conditionbr;} if(isset($tempVar)){ echo tempVar isset conditionbr;} if($tempVar !=){ echo tempVar != conditionbr;} if(!empty($tempVar)){ echo tempVar !empty conditionbr;} -- 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] is php.net down ?
You could try one of the mirrors. For example, http://php.ca is up and running. HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 11:56 AM To: 'R'twick Niceorgaw'; [EMAIL PROTECTED] Subject: RE: [PHP] is php.net down ? [snip] any one else able to get into www.php.net ? [/snip] Nope... :^[ Jay -- 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] Re: how to popup a new browser window from php
Your message was clear, and as stated by several people already, you can't do it in PHP. PHP is a server side scripting language, Javascript and VBScript are client side languages. Popping up a dialog box is a client side function, thusly cannot be done in PHP. :) HTH --Sam -Original Message- From: Wo Chang [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 8:00 AM To: Wo Chang; [EMAIL PROTECTED] Subject: [PHP] Re: how to popup a new browser window from php Thanks for all the reply! I think I didn't make myself clear. I want to use php command to popup a dialog or window msg to alert user like the Javascript alert without using javascript. Is it possible? Thanks again. --Wo - Original Message - From: Wo Chang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 7:14 PM Subject: how to popup a new browser window from php Dear All, One simple question: Is there any easy way to popup a new browser from PHP without using any Javascript? Any helps would be greatly appreciated. --Wo -- 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] PHP and passwords
What you could do is have a script called connect.inc which has your pg_pconnect statement, then use the include directive to include your connect.inc on all of your subsequent PHP pages. This way you only have the username/password hard coded in one location so if the username/password were to change, you only have to change one script instead of changing many. HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 X289 [EMAIL PROTECTED] - Original Message - From: webmaster [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 4:59 AM Subject: [PHP] PHP and passwords Is there a way to connect to your database using php without hard coding a password into the php file? We run PostgreSQL 7.1 on a Linux 7.2 server with the latest version of apache. I don't want to change the authentication within Postgres to not require a password. But I also, for security reasons, don't want to have passwords coded into the php scripts for accessing the database. I'm very new to php, but very excited about what I've learned so far. Any help would be appreciated. thanks, Elkan -- 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] Unusual Form situation?
I assume that you are doing something like this for your image: input type=image src=path/to/image/image.gif border=0 name=myimage Given that, PHP gives you $myimage_x and $myimage_y which correspond to the X and Y coordinates that were clicked on the image from the user. So on the page that your form submits to, you can do the following: if (isset($myimage_x) || isset($myimage_y)) { // do something } If the image was clicked, this will submit your form, and both $myimage_x and $myimage_y will be set. HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 X289 [EMAIL PROTECTED] - Original Message - From: SpyProductions Support Team [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 1:33 PM Subject: [PHP] Unusual Form situation? I have form I am working with and trying to add some PHP processing to the form's contents. The form is a html template used by a CGI script. So, instead of having a 'submit' button for the form's content, there is a GIF. The CGI apparently reads the GIF as a button to submit the form's content and move on. How would I go about getting php to recognize this GIF as such? Typically for forms I use: if ($submit) { blah, blah, blah } Would I use if ($gifname)? Would the the GIF's name be the ALT tag? Or am I going to have to sift through the arcane CGI to find some action? Can I make the PHP come to life using the ACTION section of the form (which only refers to the CGI right now)? Thanks, -Mike -- 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] force refresh?
You can force the browser to refresh using a meta tag: meta HTTP-EQUIV=Refresh content=180 This will cause the page to refresh every 180 seconds. HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 X289 [EMAIL PROTECTED] - Original Message - From: Chris Wright [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 07, 2002 11:34 AM Subject: RE: [PHP] force refresh? Probably only by writing javascript to the window using php. --- Christopher Wright 303 447 2496 x 107 www.netinfra.com We'll take care of it. Net Infrastructure has definitely helped our company, even though we're not in the US, Net Infrastructure has been a key part in the success of our business. Juan Carlos Saravia -Original Message- From: Jeff D. Hamann [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 9:02 AM To: [EMAIL PROTECTED] Subject: [PHP] force refresh? can i force a browser to refresh using php. jeff. -- Jeff D. Hamann Hamann, Donald Associates, Inc. PO Box 1421 Corvallis, Oregon USA 97339-1421 Bus. 541-753-7333 Cell. 541-740-5988 [EMAIL PROTECTED] www.hamanndonald.com -- 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
Re: [PHP] Help with Logical 'OR'
For sake of efficiency, many languages will do what is called Short Circuit in a situation like this. Let's look at a simple truth table for an OR using two conditions (T=true, F=false): T || T = T T || F = T F || T = T F || F = F In the first two cases, it is only necessary to evaluate the first condition because since they are true, the entire statement will be true. In case number 3, since the first condition was false, the second condition needs to be evaluated to determine whether or not the entire statement is true. In case 4, both statements are evaluated (for the same reason as case 3). If you need BOTH statements to be evaluated, chances are that you want an AND condition, not an OR condition. A simple truth table for an AND using two conditions: T T = T T F = F F T = F F F = F In the case of the AND, it is always necessary to evaluate both conditions as both conditions need to be true in order for the entire statement to be true. If any condition in a set of AND conditions is false, the value of the entire expression is also false. HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 X289 [EMAIL PROTECTED] - Original Message - From: jv [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 28, 2002 3:04 PM Subject: [PHP] Help with Logical 'OR' It seems that only the first condition is being evaluated. I know that if both of the following conditions are false then the second set of statements should get read, and that's what happens, but when I set $name to true and $text to false (true||false) then the first set gets read. Shouldn't both conditions be true in order for the first set of statements be read? Why would the first set of statements get read when the conditions are (true||false)? Thanks in advance for your help. james if ($name || $text) { $text = stripslashes($text); print Hello $name\nbr; print You said:\nbr $text\n; }else{ print Sorry, but you seem to have left one or more entries blank.br\n; print Please return to a href=\/prac/form.html\form/a\n; print and complete the inputbr\n; } ** -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] OOP Problem
Hi there! It sounds like you do not have mysql support compiled into PHP. You didn't say if you were using PHP on Windows or Linux so you might want to read the documentation for the respective version that you have downloaded to find out how to compile MySQL support into your PHP installation. HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 X289 [EMAIL PROTECTED] - Original Message - From: Charles [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 22, 2002 10:25 AM Subject: [PHP] OOP Problem Hi, i have create a simple php class to learn how to oop programming, like this: class mysqldb { var $dbconn; function OpenCon($DBHOST,$DBUSER,$DBPASS){ $this-dbconn = mysql_connect($DBHOST,$DBUSER,$DBPASS); } } this is a simple example... but when i inherit the class, php give me a error, call to undefined function: mysql_connect() php think that mysql_connect is my private function ? Charles Ps. sorry my poor english -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] MySQL and PHP
What is the error that you are getting? --Sam - Original Message - From: Brandon Orther [EMAIL PROTECTED] To: PHP User Group [EMAIL PROTECTED] Sent: Thursday, January 17, 2002 5:25 PM Subject: [PHP] MySQL and PHP Hello, I am trying to use mysql through php. When I try to run the following query it does nothing. I am trying to figure out if it is the query or php I am having a problem with. Does anyone see a problem with the below query? (Note: This is for mysql) QUERY: INSERT INTO page_properties (page_name,open_menu,top_image,title_image,side_images) VALUES(30daypolicy,comp_info2,top_aboutus,titlebar_aboutus,30da y); Thanx for your help, Brandon -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Re:[PHP] Mysql
Even though this is OT as it is not a PHP question it is an easy one :) Please see the following URL: http://www.mysql.com/documentation/mysql/bychapter/ It is the MySQL manual broken out by chapter. You will find the next URL particularly useful as it is the syntax for the create table command: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#CREATE_TABLE HTH --Sam On Tue, 15 Jan 2002 03:46:47 +0300 -=LukA=- [EMAIL PROTECTED] wrote: Hello php-general, Hi everybody Please help me. If i want to create a table in some database what should I do. The database is on server. -- Best regards, -=LukA=- mailto:[EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] does this work?
I think it will really help if you post more of your code. It is obvious that the parse error is not contained within the lines of code that you pasted :) I think more of your code will reveal the answer rather quickly :) HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 X289 [EMAIL PROTECTED] - Original Message - From: Erik Price [EMAIL PROTECTED] To: Kevin Stone [EMAIL PROTECTED] Cc: PHP (E-mail) [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 4:43 PM Subject: Re: [PHP] does this work? I tried that... I get the same error (same line and everything). As a side note, I haven't ever had to quote the first argument in mysql_query() before... This is quite a conundrum, eh? Erik On Friday, January 11, 2002, at 04:25 AM, Kevin Stone wrote: Hmm I believe that the mysql_query() function requires quotes around the query statement even it it is being passed as a variable.. mysql_query($tempsql, $db); -Kevin It seems that I have a parse error somewhere in the following code (since that's the only code in my script, it's a test script): // arraytest.php $tempsql = SELECT COUNT(*) AS count FROM divisions; $tempresult = mysql_query($tempsql, $db); $temprow = mysql_fetch_array($tempresult); echo $temprow[count]; Yet, it works fine in the mysql client. Thus, I am led to believe that PHP is not capable of constructing the same kinds of SQL statements that can be constructed in the mysql client. Is this the case? Erik PS: what I am -really- trying to do is dynamically fill in a select listbox with options that correspond to all of the records in a given table. Like so: form select ?php foreach ($record_id_and_record_name_pair_pulled_from_mysql_query) { print(option value=\${record_id}\${record_name}/option); } ? /select /form but I am unsure of how to grab multiple values from the mysql_query() and load them into an array. Has anyone done this before? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: php-list- [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] ora_numrows() function
I just wanted to verify the functionality of the ora_numrows() function. On the ora_numrows() manual page it reads that the function returns the number of rows in a result set, but in the ora_getcolumn() documentation it reads that the ora_numrows() function returns the current row number. Could someone please give me a quick clarification? Thanks :) --Sam Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 X289 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] PHP FRAMES Question
In your printf statement, you are targetting sub_detl whereas in your frameset you name the frame sub_dtl. Naturally, these values should match. HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 X289 [EMAIL PROTECTED] - Original Message - From: Miles Thompson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 15, 2001 12:41 PM Subject: [PHP] PHP FRAMES Question This has probably been dealt with before, but I'm unable to get my link to open in the target frame, it always opens in the same frame. This line of code: printf(a href=\ %s?member_id=%s target=sub_detl \ %s /a \n, $target_url, $myrow[member_id], $myrow[member_id]); typically expands, when the mouse pointer is placed over it, to: http://hostname/sitename/adm_sub_dtl.php?member_id=T0003 target=sub_detl This is the code for the page which creates the framesets .. HTML HEAD TITLESubscriber Administration/TITLE /HEAD FRAMESET rows=70%,30% FRAME name=sub_lst src=adm_sub_lst.php scrolling=auto FRAME name=sub_dtl src=adm_sub_dtl.php scrolling=auto /FRAMESET /HTML I don't see any mysteries here, and it appears syntactically correct. Any suggestions will be welcome - Miles Thompson -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] PHP on fu!$#@ing PWS
I am going to make the assumption that you did not download the installer from the following URL (only the zip package).. http://www.php.net/downloads.php If you downloaded both the zip package and the installer and are still having a problem, please post the error message(s) that you are receiving. HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 X289 [EMAIL PROTECTED] - Original Message - From: German Benzano [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 22, 2001 11:19 AM Subject: [PHP] PHP on fu!$#@ing PWS How do I run *.php on PWS I download php4, edit php.ini reg and NOTHING! Please someone HELP ME! My OS is Win 98 PWS 4.0 (Sorry by my poor English, I speak spanish 8o( /G£rmÅn// German Benzano [EMAIL PROTECTED] Montevideo - Uruguay -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Spam messages (Was: FREE S E X O
...but then what do you do about the people who have legitimate questions who don't want to subscribe to the list? This is a fairly high traffic list and not everyone wants that much mail coming at them just to have the occasional one-off question answered. Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 X289 [EMAIL PROTECTED] - Original Message - From: Carl W. Brown [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 18, 2001 11:23 AM Subject: [PHP] Spam messages (Was: FREE S E X O Most lists that I subscribe to block all messages except from subscribers. This whould be a great feature for the PHP lists. The PHP lists are the worst spamming lists. Carl -Original Message- From: The Doctor [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 8:03 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-I18N] Re: [PHP] FREE S E X O 20935 Anti-spam filters needed on php list. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] can you pls tell me where is php ./configure file in linux 7.1
Chances are that since it was installed as part of your RH install, there isn't a configure script. I would scrap the RPM and go to www.php.net and download the source tarball. That includes the configure script that you are looking for, which will allow you to include whatever you would like as part of the PHP install. HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 X289 [EMAIL PROTECTED] - Original Message - From: Caleb Carvalho [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 1:33 PM Subject: [PHP] can you pls tell me where is php ./configure file in linux 7.1 hi, am still having problem to compile my sybase, i have linux 7.1 and php was installed during installation process, i can't find the ./configure file.. php-4.0.4pl1-9 pls help Caleb Carvalho LoadRunner/APM -- --- Enterprise Testing and Performance Management Solutions -- --- Mercury Interactive 410 Frimley Business Park Frimley, Surrey. GU16 7ST United Kingdom Telephone : +44 (0)1276 808300 _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] test for empty $result??
Then you can use: if (mysql_num_rows($result) == 0) { stuff here } This will check the number of rows returned from your query. If zero, then do somethingmodify as you need. HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 X289 [EMAIL PROTECTED] -Original Message- From: Andrew [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 1:45 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP] test for empty $result?? thansk, but $result here is a Resource ID, and will be present even if the result set associated with it is null. best, a -Original Message- From: Jeff Lewis [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 1:43 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP] test for empty $result?? Just use: if (!$result){ code here } Jeff -Original Message- From: Andrew [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 1:34 PM To: [EMAIL PROTECTED] Subject: [PHP] test for empty $result?? I know that this has been discussed before, but I cannot find the threads so... I have a function that does a mysql_query and want to break if the SQL query didn't return any rows in $result. empty(), isset() will not work, for obvious reasons. Can anyone suggest an alternative? $sql=select row from table where field = \1\; $link_id = mysql_connect($hostname, $username, $password); mysql_select_db($database, $link_id); $result = mysql_query ($sql, $link_id) or die; //this doesn't work...right? if (empty($result)) break; best, andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Newbie Question: mysqldump via PHP
I would say that you have a permission problem with where PHP is trying to write the file to. Try outputting the file to /tmp/db.dump and see if you have the same problem. HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 X289 [EMAIL PROTECTED] -Original Message- From: Tony Frasketi [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 1:56 PM To: [EMAIL PROTECTED] Subject: [PHP] Newbie Question: mysqldump via PHP Hello listers I'm trying to implement a mySQL database dump via PHP4 on a unix system as follows... -- $result = exec(mysqldump -umyname --password=mypassword tablename db.dump,$xarray,$status); echo status[$status]br; -- I get the following error PHP error message... status[127] and the file 'db.dump' has been created but it has 0 bytes. -rw-r--r-- 1 nobody nobody 0 Sep 4 13:27 db.dump Although I can execute the mysqldump program from the unix shell and I get... -rw-r--r-- 1 myname myname 23704 Sep 4 13:18 db.dump My questions are... 1. Can the mysqldump program be executed via PHP or not and if not can you please explain why? 2. Is there another way of doing this via PHP? Thanks in advance Tony Frasketi P.S. Please answer direct, since I'm only subscribed to the digest. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Newbie Question: mysqldump via PHP
Have you tried putting in the fully qualified pathname to the mysqldump executable? /usr/somepath/mysqldump rest of your command here HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 X289 [EMAIL PROTECTED] -Original Message- From: Tony Frasketi [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 2:28 PM To: Sam Masiello Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Newbie Question: mysqldump via PHP Hi Sam Thanks for the reply. I had the permission set for 777 so that should allow access to the directory for writing from PHP, should it not? Also I tried specifying /tmp/db.dump in the command and had the tmp directory permission also set for 777 but still get same results. The file get written but it's still set to zero bytes. Any other suggestions would be greatly appreciated. Sam Masiello wrote: I would say that you have a permission problem with where PHP is trying to write the file to. Try outputting the file to /tmp/db.dump and see if you have the same problem. HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 X289 [EMAIL PROTECTED] -Original Message- From: Tony Frasketi [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 1:56 PM To: [EMAIL PROTECTED] Subject: [PHP] Newbie Question: mysqldump via PHP Hello listers I'm trying to implement a mySQL database dump via PHP4 on a unix system as follows... -- $result = exec(mysqldump -umyname --password=mypassword tablename db.dump,$xarray,$status); echo status[$status]br; -- I get the following error PHP error message... status[127] and the file 'db.dump' has been created but it has 0 bytes. -rw-r--r-- 1 nobody nobody 0 Sep 4 13:27 db.dump Although I can execute the mysqldump program from the unix shell and I get... -rw-r--r-- 1 myname myname 23704 Sep 4 13:18 db.dump My questions are... 1. Can the mysqldump program be executed via PHP or not and if not can you please explain why? 2. Is there another way of doing this via PHP? Thanks in advance Tony Frasketi P.S. Please answer direct, since I'm only subscribed to the digest. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Newbie Question: mysqldump via PHP
You could do: which mysqldump (without the quotes, of course :) ). This is provided that mysqldump is in your path (if you can enter just mysqldump from the command line, then it is). HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 X289 [EMAIL PROTECTED] -Original Message- From: Tony Frasketi [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 2:53 PM To: Sam Masiello Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Newbie Question: mysqldump via PHP Hi Sam No I haven't tried this since I'm on a virtual server and don't know where mysqldump is located. I tried doing a phpinfo() to see if I could get the mysqldump location from there but I didn't see it in the mysql section of the phpinfo listing. Do you know of a unix shell command I could use to get the location of mysqldump? Tony Sam Masiello wrote: Have you tried putting in the fully qualified pathname to the mysqldump executable? /usr/somepath/mysqldump rest of your command here HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 X289 [EMAIL PROTECTED] -Original Message- From: Tony Frasketi [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 2:28 PM To: Sam Masiello Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Newbie Question: mysqldump via PHP Hi Sam Thanks for the reply. I had the permission set for 777 so that should allow access to the directory for writing from PHP, should it not? Also I tried specifying /tmp/db.dump in the command and had the tmp directory permission also set for 777 but still get same results. The file get written but it's still set to zero bytes. Any other suggestions would be greatly appreciated. Sam Masiello wrote: I would say that you have a permission problem with where PHP is trying to write the file to. Try outputting the file to /tmp/db.dump and see if you have the same problem. HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 X289 [EMAIL PROTECTED] -Original Message- From: Tony Frasketi [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 1:56 PM To: [EMAIL PROTECTED] Subject: [PHP] Newbie Question: mysqldump via PHP Hello listers I'm trying to implement a mySQL database dump via PHP4 on a unix system as follows... -- $result = exec(mysqldump -umyname --password=mypassword tablename db.dump,$xarray,$status); echo status[$status]br; -- I get the following error PHP error message... status[127] and the file 'db.dump' has been created but it has 0 bytes. -rw-r--r-- 1 nobody nobody 0 Sep 4 13:27 db.dump Although I can execute the mysqldump program from the unix shell and I get... -rw-r--r-- 1 myname myname 23704 Sep 4 13:18 db.dump My questions are... 1. Can the mysqldump program be executed via PHP or not and if not can you please explain why? 2. Is there another way of doing this via PHP? Thanks in advance Tony Frasketi P.S. Please answer direct, since I'm only subscribed to the digest. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] fix my query please
It has outer joins: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#JOI N HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Martín Marqués [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 4:35 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject:Re: [PHP] fix my query please On Mar 28 Ago 2001 17:29, Jeremy Morano wrote: an somebody please fix up my query. $connection = @mysql_connect(l, c, c) or die(Couldn't connect.); $db = @mysql_select_db($db_name, $connection) or die(Couldn't select database.); $sql = SELECT distinct users.uid , users.username FROM users LEFT OUTER JOIN picks using(id) Am I an ignorant, or MySQL doesn't have OUTER JOINs Where users.uid picks.user_id ; [snip] Saludos... :-) -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] order of update??
The order doesn't matter, but perhaps you might want to put single quotes around your $a at the end of your SQL statement. You didn't mention the error that you were getting, but this might help nonetheless :) update tablename set x='$x', y='$y', z='$z' where a='$a'; HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Gerard Samuel [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 3:00 PM To: PHP Subject:[PHP] order of update?? My seem stupid to some, but when running update tablename set x='$x', y='$y', z='$z' where a=$a; Does it matter if it the set were in backwards order ie z, y, x ?? Just curious, Im having a problem and I dont know if its because of the order Thanks -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Re: order of update??
Why can't you update ? What error message are you getting? Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Gerard Samuel [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 3:28 PM To: PHP Subject:Re: [PHP] Re: order of update?? Im currently hacking away at a current setup that uses php/mysql on a user table. I have successfully inserted and selected from it, but I cannot update. Yes there were quotes, but thanks for letting me know that the order didn't matter, that narrows my list of possibilities down. Talk to you all later. trini0 [EMAIL PROTECTED] wrote: Gerard Samuel [EMAIL PROTECTED] wrote: My seem stupid to some, but when running update tablename set x='$x', y='$y', z='$z' where a=$a; Does it matter if it the set were in backwards order ie z, y, x ?? the order does not matter. (although unless you're sure $a is an integer value, you may want to wrap it in quotes, too.) jim -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Sort a an array?
Instead of trying to sort the result AFTER it returns from the query, you could use an ORDER BY clause in your query to sort the results prior to trying to output it? You could change your query to something like: SELECT * FROM tablename ORDER BY fieldname HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Allen May [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 11:32 AM To: [EMAIL PROTECTED] Subject:[PHP] Sort a an array? I want to sort a result set from a mySQL query (see code below). I can't figure out how to properly sort the $result in the while loop. I just want to alphabatize the search result. Any suggestions how to do this? Thanks -Allen [EMAIL PROTECTED] (remove _nospam to reply) * $query = select * from $table; $result = mysql_query($query); print form name=\JobDesc\ method=\post\ action=\jobdesc.php\\n; print select name=\wilber\\n; while ($row = mysql_fetch_array($result)) : print option value=\; print $row[Jobtitle]; print \; print $row[Jobtitle]; print /option\n; endwhile; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] mysql_numrows
I believe the function you want is mysql_num_rows, not mysql_numrows HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: AJDIN BRANDIC [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 9:35 AM To: [EMAIL PROTECTED] Subject:[PHP] mysql_numrows Hi I'm trying to get number of rows from a query. All works fine until the result is 0. Then query executes fine, returns 0 rows but mysql_numrows failes. $query=select * from mytable; $result=mysql_query($query) or die(select failed); $num_rows=mysql_numrows($result) or die(select count failed); Displays selec count failed but it should just return 0 so $numrows=0. If or die bit is removed, then all works fine. Any way around this problem? Regards Ajdin -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] get value
There might be an easier way to do it, but this should work: Change your SELECT statement to SELECT count(*) as c other criteria here After $result = @mysql_query($sql,$connection) or die(Couldn't execute query.); Do this: $mycount = mysql_result($result, 0, 'c') ; $mycount should now be the value held from your count in the SQL statement. HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Jeremy Morano [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 4:07 PM To: [EMAIL PROTECTED] Subject:[PHP] get value hi,,, can someone tell me how to access the value of count? please? - $db = @mysql_select_db($db_name, $connection) or die(Couldn't select database.); $sql = SELECT count(*) FROM $table_name, company Where company.uid = user.companyUid and company.company = '$PHP_AUTH_USER' ; $result = @mysql_query($sql,$connection) or die(Couldn't execute query.); -- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] New lists (was [PHP] Attitude of B van Ouwerkerk)
I think the problem with spreading out discussions that can be as broad as the PHP discussion is that you still tend to have people gravitate towards some of the more general or higher level discussion groups regardless of whether or not it should fall into the newbie category or not. This is for a couple of reasons: 1) Newbies may think that their newbie group is read mainly by newbies...so their question either might not get answered at all or will not receive the thorough answer they were hoping for. 2) Being a newbie, they might think that their question is worthy (for lack of a better term) of higher level discussion because, to them, it is a very difficult problem to solve. ...not to mention that questions would then be spammed across multiple mailing lists anyway. Either way, we would still need a PHP General Forum, so I am not convinced that creating more specialized mailing lists would accomplish much more than creating MORE mail traffic (from the spammed questions) and alienating people who used the more specialized lists because most everyone else is still mainly reading the General Forum. My 2 copper pieces worth. Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Darren Henderson [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 10:41 AM To: B. van Ouwerkerk Cc: [EMAIL PROTECTED] Subject:[PHP] New lists (was [PHP] Attitude of B van Ouwerkerk) On Tue, 31 Jul 2001, B. van Ouwerkerk wrote: There's nothing wrong with being a newbie.. the only newbie-problem I see/have is the lazy one.. ask ask ask ask without taking the time to read the manual or to do a search in the archive. Sure there are newbies who read the manual.. get some tutorials.. thats good. They should get all the support they need.. Unfortunately this kind of thing happens on all the mailing lists I've seen that are devoted to questions. The real problem here is that the list is simply too busy. I can do no more then skim the subject lines and then usually delete all of it unless something jumps out at me. It might be helpful if some new mailing lists were created, it wouldn't be a perfect solution but it would help if there were some degree of self selecting behavior possible. Currenty all questions go to php-general. If there were, say, a php-newuser and a php-questions list then perhaps php-general could be used for slightly higher level discussions. Actually its probably too late to save php-general, hard to get people to change. Maybe a new list that caters to a higher level of discussion, say php-authoring or the like? Just a thought. So much tends to get lost or over looked in high volume mailing lists. Darren Henderson [EMAIL PROTECTED] [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] SQL syntax error in PHP script. dunno what's wrong
You will need to put single quotes around your variables in your SQL statement. Like this: $sql = UPDATE TABLE seminar SET title='$title',speaker='$speaker',event_date='$tdate',time='$time',bldg='$bu ilding' ,rm='$room' WHERE id='$id'; Without the quotes, SQL doesn't know that Something Amazing is supposed to go together in the same string. HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Chris Worth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 01, 2001 12:36 PM To: [EMAIL PROTECTED] Subject:[PHP] SQL syntax error in PHP script. dunno what's wrong hey gang. here is my sql statement from my php script. $sql = UPDATE TABLE seminar SET title=$title,speaker=$speaker,event_date=$tdate,time=$time,bldg=$building ,rm=$room WHERE id=$id; it appears just like that in my code. here is the $sql string echoed to the screen to verify the variables. UPDATE TABLE seminar SET title=Something amazing,speaker=Mr. Black,event_date=2001-08-05,time=11:00:am,bldg=BCC ,rm=201 WHERE id=48 all of the variable are valid. here is my error. 1064: You have an error in your SQL syntax near 'TABLE seminar SET title=Something amazing,speaker=Mr. Black,event_date=2001-08' at line 1 I'm baffled. and I couldn't find error 1064 in the mysql manual.pdf either. any ideas. I know this is going to turn out to be something silly. thanks, chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Installing PHP probs
Exactly what error are you getting? The install is pretty straight forward. Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Kyle Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 01, 2001 9:26 PM To: [EMAIL PROTECTED] Subject:[PHP] Installing PHP probs Can someone quide me through the process of installing PHP on a windows system (my computer) because ive followed what it says in the doc files but it doesnt work so anyone who has done it, please help! -lk6- http://www.StupeedStudios.f2s.com Home of the burning lego man! ICQ: 115852509 MSN: [EMAIL PROTECTED] AIM: legokiller666 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] HELP!! What wrong with this code...
You need to put backslashes before your quotes in your echo statement. Like this: echo P align=centerYour feedback has been sent to a href=\mailto:$address\;$name/a/P; HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Steve Wright [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 12:13 PM To: PHP List Subject:[PHP] HELP!! What wrong with this code... Hey, i am getting an error passed back for this line of code, the rest of the code is below: echo P align=centerYour feedback has been sent to a href=mailto:$address;$name/a/P; the error is: Parse error: parse error, expecting `','' or `';'' in /www/customers/stevewrightonline.co.uk/form/do_sendform.php on line 20 Does anyone know y this is?? If i remove the a href tags it works fine. Can you not use links properly in PHP?? -- ?php $name = Steven Wright; $address =[EMAIL PROTECTED]; $recipient = $address; $subject = Auto Form; $mailheaders = From: Auto Form $address \n; $mailheaders = Reply-To: $sender_email\n\n; /*The Message*/ $msg = Sender:\t mailto:$sender_email \t $sender_name\n\n; $msg = Message:\t$message\n\n; /*Mail to Me*/ mail($recipient, $subject, $msg, $mailheaders); /*Onscreen confirmation of sending*/ echo HTMLHEADTITLEForm Sent!/TITLE/HEADBODY; echo H1 align=centerThank You, $sender_name/H1; echo P align=centerYour feedback has been sent to a href=mailto:$address;$name/a/P; echo /BODY/HTML; ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Please Please Pleeeeaaaaaaaaaasssssssseeeeeee
Didn't we go through this the other day? :) :) There are lots of sites available with LOTS of scripts you can look at that do very practical things. Scripts that I am sure some of us have even used on occasion (I know *I* have!). Besideshow is someone sending you one of their scripts hands on for you? :) --Sam -Original Message- From: Kyle Smith [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 8:48 PM To: [EMAIL PROTECTED] Subject:[PHP] Please Please Plaaeee Can everybody please send me a simple script they have made it doesnt matter what, i just need some material to learn from, i learn better hands on. -legokiller666- http://www.StupeedStudios.f2s.com New address new site ICQ: 115852509 MSN: [EMAIL PROTECTED] AIM: legokiller666 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Hack on Server.
I think the following link might shed some more light on the situation: http://news.cnet.com/news/0-1003-200-6604515.html HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 [EMAIL PROTECTED] On Fri, 20 Jul 2001 10:12:25 +1000 Brian White [EMAIL PROTECTED] wrote: Maybe the hacker got into the httpd.conf and set the auto-prepend setting to a file that contained the message. Brian At 00:34 20/07/2001 +0300, [EMAIL PROTECTED] wrote: Hi Jean-Francois! On Thu, 19 Jul 2001, Jean-Francois Jauvin wrote: Hi, my server with php on it has been hacked or something., what appened is every PHP pages displayed a certain message like Hacked by blah blah blah None of the HTML pages were affected, only the PHP ones but the scripts were not altered, I've shut down IIS, reinstalled PHP, and Ah, IIS, the magic word. Maybe you have been hacked by the Bady worm, I saw it in action in the test lab :) -- teodor -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] - Brian White Step Two Designs Pty Ltd - SGML, XML HTML Consultancy Phone: +612-93197901 Web: http://www.steptwo.com.au/ Email: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] php- something that i don't understand
Pardon my ignorance if you can really do it this way (because I have never seen it done like this): In line 4, I wasn't aware that you could call mysql_connect() without any parameters. Can you? HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Yassel Omar Izquierdo Souchay [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 4:38 PM To: [EMAIL PROTECTED] Subject:[PHP] php- something that i don't understand Hey guys here is my code 4: mysql_connect() or die (Problemas conectandose a la base de datos); 5: $query=select * from info where FirstName='$FirstName' and 6: LastName='$LastName' and email='$email'; 7: $result = mysql_db_query(users, $query); *8: $r=mysql_fetch_array($result); 9: $count=$r[count]; and i follow redcieving this message Warning: Supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\PhpAndMysqlTest\test2\reg1.php3 on line 8 thanks for your answers Yassel -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] PHP irc chatrooms
Try #php :) Lots of people hanging out in there all the time. HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Bernie Kruger [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 8:46 AM To: [EMAIL PROTECTED] Subject:[PHP] PHP irc chatrooms Hi, Does anyone know of any PHP related chatrooms? Tx Bernie -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Easy question...grabbing variables...
If you want to pass more than one variable via GET, you need to use an ampersand () character for the variables after the first one (still using a question mark for the first). So in your case, you can have this: http://wwbl.hyrum.net/send_email.php?to=4from=25 Then within your send_email.php script, you can access $from which will have the value 25 upon entry to your script. HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Jeff Lewis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 11, 2001 10:22 AM To: [EMAIL PROTECTED] Subject:[PHP] Easy question...grabbing variables... Um, been using PHP for awhile now and don' even know how to grab these: http://wwbl.hyrum.net/send_email.php?to=4;from=25 I have usually only passed one variable before so all I've need to do is $toID=$to but how do I get from? I know I should know this but I am either having a major brain fart or missed this in PHP 101 ;) Jeff -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Accesing Oracle
Sounds like you need to recompile PHP with Oracle support. Recompile PHP with the -with-oracle flag when running the configure script to include the Oracle functions. HTH Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Kike [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 10:22 AM To: [EMAIL PROTECTED] Subject:[PHP] Accesing Oracle Hi all, I've just installed Orcale 8.1.7 in a linux server in my lan. I'm trying to access to the server from another computer with apache and i get the next: Fatal error: Call to undefined function: ora_logon() in /usr/local/apache/htdocs. Where can i find docs to configure boths machines to access to the oracle server? Thanks a lot. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Parse error help!
Perhaps you want something like this: $Msg = $H.$NL.$R.$NL.$D; HTH Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Taline Makssabo [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 11:18 AM To: [EMAIL PROTECTED] Subject:[PHP] Parse error help! Thanks for all the help guys but one more minor issue, i am not receiving the email that someone accessed my page...why?? ? Function AccessHit() { $NL = \n; $H = getLastHost(); $R = getLastRef(); $To = [EMAIL PROTECTED]; $Sub = Page Accessed; $D = Date(D d M y h:ia,time()); $Msg = $H + $NL + $R + $NL + $D; mail($To,$Sub,$Msg); } ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Blank Field Values
Did you echo out $CharacterName before your SQL statement to ensure that it is being set? Or your $SQL variable before calling odbc_do? This might provide you with some insight as to why the query doesn't return anything. HTH Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Jeff Pearson [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 1:05 PM To: php Subject:[PHP] Blank Field Values OK. Ive been beating my head over this code for a bit. I would appreciate it if a fresh set of eyes would take a look at this for me. I have the following code; SCRIPT language=PHP $connection = odbc_pconnect(XXX,X,XXX); $SQL = SELECT * FROM Bios WHERE CharacterName = '; $SQL .= $CharacterName; $SQL .= '; $QueryResult = odbc_do($connection, $SQL); $NumberofRows = odbc_num_rows($QueryResult); $ID = odbc_result($QueryResult, ID); $NumberofFields = odbc_num_fields($QueryResult); if ($NumberofRows != 0) { $counter = 1; do { $CurrentFieldName = odbc_field_name($QueryResult, $counter); $CurrentFieldValue = odbc_result($QueryResult, $CurrentFieldName); echo $CurrentFieldName; echo =; echo $CurrentFieldValue; echo ,; $counter = $counter + 1; } while ($counter = $NumberofFields); echo endoffields=end; } else { echo No records for that character; } /SCRIPT It results in the following output; ID=,CharacterName=,RealName=,FormerAlias=,CurrentAlias=,FormerOccupations=,C urrentOccupation=,MilitaryExperience=,Education=,LegalStatus=,Identity=,Plac eofOrigin=,MaritalStatus=,KnownRelatives=,KnownConfidants=,Pets=,KnownAllies =,MajorEnemies=,BaseofOperations=,Transportation=,PastGroupAffiliates=,Curre ntGroupAffiliates=,Income=,Height=,Weight=,EyeColor=,HairColor=,OtherFeature s=,IntelligenceLevel=,Strength=,SpeedReactions=,Stamina=,Agility=,FightingSk ills=,SpecialSkills=,Handicaps=,OtherPowersandSkills=,Background=,endoffield s=end If I run the query with Access, it comes up with the expected row of information I'm looking for. Can anyone see why Im getting empty values back? Any help would be GREATLY appreciated. Jeff Pearson -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] How do I have a Authentication box pop up?
See the following URL in the manual: http://www.php.net/manual/en/features.http-auth.php HTH Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Brandon Orther [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 1:48 PM To: PHP User Group Subject:[PHP] How do I have a Authentication box pop up? Hello, How to I make the browser pop up a authentication box? Thanks Brandon -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] MySQL and LIKE?
Why not do something like: SELECT myTable.col FROM myTable, otherTable WHERE myTable.id = otherTable.ID AND (otherTable.data LIKE a.% OR otherTable.data LIKE s.% OR otherTable.data = io.bean) HTH Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Jason Caldwell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 5:40 PM To: [EMAIL PROTECTED] Subject:[PHP] MySQL and LIKE? I'm trying to create a multiple pattern search using LIKE (in mySQL) -- the following doesn't seem to work and was wondering if someone knew of an easy efficient way of adding multiple search criteria. SELECT myTable.col FROM myTable, otherTable WHERE myTable.id = otherTable.ID AND otherTable.data LIKE (a.% or s.% or io.bean); So LIKE (a.% or s.% or io.bean);- doesn't seem to work like this. Thanks. Jason -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] multiple connects
Well, you won't have two persistent connections to the same database (for the same username/password). So, as long as you use the link identifier as the third argument to the mysql_query function (or mysql...whichever you are using), that is guarantee enough. HTH Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Randy Johnson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 1:08 PM Cc: [EMAIL PROTECTED] Subject:[PHP] multiple connects how do I make sure the right connection is being used when I have 2 persistent connections. is there any documentation on this ? thanks Randy -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Close Window script
You need to do this using Javascript since it is a client side function. window.close() is the function you are looking for. HTH Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Wee Chua [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 2:46 PM To: PHP (E-mail) Subject:[PHP] Close Window script Hi all, Can anyone tell me how to write a script to close the current opened window with hyperlink? Thank you. Calvin Chua Systems Analyst InterClean Equipment, Inc. 734-975-2967 www.InterClean.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] scramble the code
Perhaps we could all better assist you if you posted the code for your form ("X"-ing out any sensitive material that you wouldn't want us to see)...or maybe the URL that the form is at so we can see it for ourselves? HTH Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Scott Fletcher [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 10:30 AM To: [EMAIL PROTECTED] Subject:Re: [PHP] scramble the code Um, well, it show up on Internet Explorer and Netscape Navigator and Netscape. Oh well. Scott ""Scott Fletcher"" [EMAIL PROTECTED] wrote in message 9ahuft$612$[EMAIL PROTECTED]">news:9ahuft$612$[EMAIL PROTECTED]... Well, mine does!!! Scott ""Joe Sheble (Wizaerd)"" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... This isn't quite accurate. WHen a form's method is set to "GET" (which BTW is the form's default method) the variables and their values are passed along the URL. If your form's method is set to "POST" then nothing should get passed along on the URL. If you see all your data in the URL, you're not using a POST method or the forms action is specified as a url with parameters. At 09:06 AM 4/5/01 -0400, Scott Fletcher wrote: For the data in the "post", when the user type in the data and press the submit button, the data is then carry over to the nextpage.html. In the URL bar, I can clearly see the data, so is there to scramble hte data where anyone won't see it in the URL box at the top of the web browser? Thanks, Scott .php.net -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Delete Problem
Correct me if I am wrong, but I thought that using IN needed to be followed by a comma separated list (with each value individually separated from the others) like this: $query="DELETE FROM EmailAddress WHERE Email NOT IN ('value1', 'value2', ., 'value_n')" ; if you want to use a comma separated list, you can use the find_in_set function: $query="DELETE FROM EmailAddress WHERE !find_in_set(Email, 'value1,value2,value3, ,value_n') " ; HTH Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, March 30, 2001 7:15 AM To: [EMAIL PROTECTED] Subject:[PHP] Delete Problem Hi, Can anyone see a problem with this? ? $dbase="Failed_Signups"; // Connect to MySQL $Connect=mysql_connect("", "", ""); $www_domain="select Failed_Signups.EmailAddress.Email from Failed_Signups.EmailAddress left join www_domain_net.Members on Failed_Signups.EmailAddress.Email=www_domain_net.Members.EmailAddress where www_domain_net.Members.EmailAddress is null"; $www_domainRESULT=mysql_query($www_domain); $www_domain_rows=mysql_num_rows($www_domainRESULT); for ($a=0; $a$www_domain_rows; $a++) { $www_domain_Array = mysql_fetch_array($www_domainRESULT); printf("%s", $www_domain_Array['Email']); $inlist .= sprintf("%s", $www_domain_Array['Email']); if($a $www_domain_rows - 1) { $inlist .= ", "; } } echo"$inlist"; $query="DELETE FROM EmailAddress WHERE Email NOT IN $inlist"; $query1=mysql_db_query($dbase, $query) or die("Problem1"); // Close MySQL Connection mysql_close($Connect); ? It keeps stopping on $query1 thanks Ade -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Oracle, Win2000, Apache, OCI
It sounds like PHP was not compiled with the -with-oracle directive when the configure script was run. This will compile in support for the PHP Oracle functions. HTH Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Brooks, Ken [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 4:53 PM To: '[EMAIL PROTECTED]' Subject:[PHP] Oracle, Win2000, Apache, OCI I have seen -many- messages and spent an entire day reading, and haven't found what I'm looking for so i hope this is the correct place to ask. When I try to make an ora_logon or ocilogon, I get the error: Fatal error: Call to undefined function: ora_logon() Is this an incorrect PHP setup or is this due to the fact that I don't have Oracle 8.1.6 installed? (I have 7.x) I have uncommented the php_oracle and php_oci8.dll lines in the php.ini file. Do I need to do more than that? (I am using the latest php4 windows binary). thanks, --= kkeeeetthh bbrrkkss IRIS Admin =-- Email--: [EMAIL PROTECTED] 302.793.5750 --Voice -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Oracle, Win2000, Apache, OCI
After reading my last post, I realized that I am a dope :) You DO need to compile in Oracle support, but you don't do it with -with-oracle. That is in Linux :) Sorry about that! Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Sam Masiello [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 5:13 PM To: Brooks, Ken; [EMAIL PROTECTED] Subject:RE: [PHP] Oracle, Win2000, Apache, OCI It sounds like PHP was not compiled with the -with-oracle directive when the configure script was run. This will compile in support for the PHP Oracle functions. HTH Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Brooks, Ken [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 4:53 PM To: '[EMAIL PROTECTED]' Subject:[PHP] Oracle, Win2000, Apache, OCI I have seen -many- messages and spent an entire day reading, and haven't found what I'm looking for so i hope this is the correct place to ask. When I try to make an ora_logon or ocilogon, I get the error: Fatal error: Call to undefined function: ora_logon() Is this an incorrect PHP setup or is this due to the fact that I don't have Oracle 8.1.6 installed? (I have 7.x) I have uncommented the php_oracle and php_oci8.dll lines in the php.ini file. Do I need to do more than that? (I am using the latest php4 windows binary). thanks, --= kkeeeetthh bbrrkkss IRIS Admin =-- Email--: [EMAIL PROTECTED] 302.793.5750 --Voice -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] $PATH_INFO
I would have to be inclined to say that you couldn't do that. None of the examples that I have ever seen do it that way, and from a perspective of how a URL is built, how would the browser ever know that you are trying to access index.php/somevar/somevalue as opposed to thinking that "somevalue" is supposed to be the name of a page? I am sure someone will chime in if this is wrong, but I would doubt that it isof course, I guess the best way to find out is to try it :) -- Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] On 2001.02.27 11:10:57 -0500 Data Driven Design wrote: I've got a page that I'm currently working on that grabs a couple of variable from $PATH_INFO and uses them for db queries. The page is currently called content.php. My question is this, when I replace my index file with this will http://www.mydomain.com/somevar/someothervar be the same as http://www.mydomain.com/index.php/somevar/someothervar It could make things easier for me if it is. Data Driven Design PO Box 1084 Holly Hill, Florida 32117 http://www.datadrivendesign.com http://www.rossidesigns.net -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Using a variable in a variable
Why not just use an array? $testtext[1] = "value1" ; $testtext[2] = "value2" ; etc.. -- Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] On 2001.02.13 16:06:54 -0500 Brandon Orther wrote: Hello, Is there a way to use a variable in the middle of a variable? ## START EXAMPLE ## ? $test1text = ""; $test2text = ""; $test3text = ""; $count = 3; $i = 0; do{ $test$itext = "$i"; }while($i $count); ? ## END EXAMPLE ## $test($i)text = "$i"; ^^--I want this variable to get bigger while the loop is going but I can't figure out how to make the $test#text variable to read it correctly. I hope someone can understand what I am saying. Thank you, Brandon Orther WebIntellects Design/Development Manager [EMAIL PROTECTED] 800-994-6364 www.webintellects.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Getting ASPELL to work?
When you compile PHP, you also need to include the --with-aspell flag (similar to how you did to include MySQL support). HTH -- Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] On 2001.02.07 14:19:38 -0500 Nicholas Pappas wrote: Is there a secret to get the 'aspell_*' functions to work? I tried running one and got a 'unsupported function' error. :( I am running a RH7.0 system with PHP3. Aspell is installed on the system, but I did not do anything special at compile time (except MySQL support). Is there a compile time tag I need to set in order to get the aspell functions to work (couldn't find on in the docs). Many thanks for any help!! Nick -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Listbox Data Entry
You need to be sure that you are defining the select list similar to this: SELECT NAME="mylist[]" SIZE="3" MULTIPLE The size field can be whatever you want to show, but you need to use the brackets in the NAME attribute to indicate an array, then treat the data submitted as an array after the form is posted. HTH Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: iGuru [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001 9:56 AM To: [EMAIL PROTECTED] Subject:[PHP] Listbox Data Entry Hello I have a little problem. I have a listbox (multiline combo box) on my web page. When I sellect multiple items from the list box and submit the for to enter the values of the listbox items in the database, then only last selected item of the listbox is entered in the MySQL database. Does anyone know what to do? Thanks in advance, Tahir -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] How do I to declare a function or procedure in PHP???
Hello Bruno! See the following URL in the PHP manual: http://www.php.net/distributions/bigmanual.html#functions HTH Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Bruno Freire [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 11:40 AM To: '[EMAIL PROTECTED]' Subject:[PHP] How do I to declare a function or procedure in PHP??? Please , I don't know how to declare a functionhow is the scope?? In C++ is for example... Void test(int a, int b) { . } But... In php HOW DO I DECLARE A FUNCTION OR PROCEDURE BrunoBrazil -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] mysql_insert_id()
When you are using mysql_insert_id, you don't want to pass it the result of your previous SQL statement as in: $result = mysql"mydb", "My SQL statement", $my_connect) ; $last_id = mysql_insert_id($result) Rather, you want to pass it the link identifier from your mysql_connect like: $result = mysql("mydb", "My SQL statement", $my_connect) ; $last_id = mysql_insert_id($my_connect) HTH Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Boget, Chris [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 3:50 PM To: Php (E-mail) Subject:[PHP] mysql_insert_id() I'm having intermittent problems with this function. Most of the time, it returns the proper value. However, sometimes it doesn't return anything at all even when the insert query executes without error and I can see the new data in the database. I try to get the last insert id both by supplying the link-resource and not but still get the same results. When I echo out the link-resource (what mysql() returns), all I'm gettins is a numerical one (1). What gives? Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] mysql_insert_id()
You probably stated this in your previous post, but what is the result from your call to mysql() ? Is this call failing so that when you get to mysql_insert_id(), the id doesnt exist? HTH Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Boget, Chris [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 4:20 PM To: 'Sam Masiello'; Php (E-mail) Subject: RE: [PHP] mysql_insert_id() When you are using mysql_insert_id, you don't want to pass it the result of your previous SQL statement as in: $result = mysql"mydb", "My SQL statement", $my_connect) ; $last_id = mysql_insert_id($result) This is what it sounds like it's looking for in the documentation. It could be just how I'm reading it. :p Rather, you want to pass it the link identifier from your mysql_connect like: $result = mysql("mydb", "My SQL statement", $my_connect) ; $last_id = mysql_insert_id($my_connect) Tried this, too, with no luck. :( I'm using mysql_pconnect() and mysql_connect() and neither seems to help my situation. Chris
RE: [PHP] mysql_insert_id()
Instead of checking if(!$id), perhaps you would be better off to check the result of your query (which in this example was successful, since you got a return from mysql() ). Also, what is the last_insert_id() function that you are referencing in your $insertIDQuery string? As for things getting messed up when two queries hit the system at the same time, you shouldnt need to worry about that either because the two people coming in would have different values for the $link variable and since mysql_insert_id goes off of the link identifier of the connection (which will be different for the two different people running queries), you should not have a conflict. HTH Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Boget, Chris [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 4:49 PM To: 'Sam Masiello'; Php (E-mail) Subject: RE: [PHP] mysql_insert_id() You probably stated this in your previous post, but what is the result from your call to mysql() ? Is this call failing so that when you get to mysql_insert_id(), the id doesn't exist? I did. It's returning a numerical one (1). What I'm doing now is as follows. It's getting me the value but I'm so afraid that if 2 queries get sent almost simultaneously it's going to screw everything up... $link = mysql_pconnect( "localhost", "thisuser", "thatpass" ); $result = mysql( $dbname, $dbquery ); $id = mysql_insert_id( $link ); if( !$id ) { $id = mysql_insert_id(); } if( !$id ) $insertIDQuery = "SELECT last_insert_id()"; // get values from above query, etc., etc. } You get the gist of it... I cannot believe this stupid thing won't work otherwise... And it's not consistent when it works and doesn't. Very odd. *sigh* Chris
RE: [PHP] ID value
If you are using mysql as your database, you can use mysql_insert_id. See http://www.php.net/manual/en/function.mysql-insert-id.php for more info :) HTH Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Robert Morrissey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 10:17 AM To: [EMAIL PROTECTED] Subject:[PHP] ID value Hi, I wonder whether anyone can shed some light onto this for me... Say I have this example insert: $sql = "INSERT INTO songs (id,name,url) VALUES ('','Foobar','test.php?id=id)"; The id is autoincrement so obviously left blank, yet I'd like to put it into the url where id is. How do I go about dragging back the id even though it is being created (I suppose) while the statement is being made -- is it possible or do I have to do something hackish? Sorry if that's a simple problem... Regards, Robert Morrissey -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] mcal installation
Since you didn't mention it specifically, I thought I should ask: Did you also download the mcal library or did you only include -with-mcal when you compiled PHP? Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: johnny p. [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 3:27 PM To: [EMAIL PROTECTED] Subject:[PHP] mcal installation Hi, I am working on a site that requires extensive calendar math on it and read about PHP and using mcal with it. I tried configuring mcal to work with it and was wondering if anyone has had any success getting it to work. I followed all the steps I could find, but I have no idea how to set up individual user directories or even if the thing works. I don't even get any errors or output. I make the mcal function calls and... nothing. If anyone has any experience with getting this installed and configured, I would be much appreciated. thanks, johnny p. --- John Patton, CTO [EMAIL PROTECTED] Gameloop, Inc. http://www.gameloop.com Austin, TX 512-699-5534 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] mcal installation
Did you restart your web server after recompiling PHP? Please be more specific on the steps that you did along the way (perhaps do them again and copy and paste your command lines to the screen so we can see exactly what you did). More often than not, people say "I followed all of the steps in the manual", but then learn to find out that they either did something wrong or skipped a step along the way. Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: johnny p. [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 4:18 PM To: Sam Masiello; [EMAIL PROTECTED] Subject:RE: [PHP] mcal installation yes. I installed both the libraries. I followed all the directions on the mcal web site for installing it. johnny p. -Original Message----- From: Sam Masiello [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 3:17 PM To: johnny p.; [EMAIL PROTECTED] Subject: RE: [PHP] mcal installation Since you didn't mention it specifically, I thought I should ask: Did you also download the mcal library or did you only include -with-mcal when you compiled PHP? Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: johnny p. [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 3:27 PM To: [EMAIL PROTECTED] Subject: [PHP] mcal installation Hi, I am working on a site that requires extensive calendar math on it and read about PHP and using mcal with it. I tried configuring mcal to work with it and was wondering if anyone has had any success getting it to work. I followed all the steps I could find, but I have no idea how to set up individual user directories or even if the thing works. I don't even get any errors or output. I make the mcal function calls and... nothing. If anyone has any experience with getting this installed and configured, I would be much appreciated. thanks, johnny p. --- John Patton, CTO [EMAIL PROTECTED] Gameloop, Inc. http://www.gameloop.com Austin, TX 512-699-5534 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] php'ed mysql query
If you are going to do a comparison from one of the fields in your table, doesn't the field name need to be on the left hand side of the comparison? So instead of "where '$zip1' = zip", shouldn't it be "zip '$zip1'" (et al for the other comparisons in your query) . HTH Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Christopher Allen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 2:25 PM To: php Subject:[PHP] php'ed mysql query Hello, Can anyone tell me why this query errors out? It works from the mysql client command line just fine $query1 = "select * from zip_base where '$zip1' = zip '$zip1' = CONCAT (SUBSTRING(zip , '1' , LENGTH (zip) - LENGTH (range) ), range)"; Christopher C. M. Allen -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]