OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
From: php-general-digest-helplists.php.net
Date: Wed Mar 21 2001 - 09:58:26 CST

  • Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

    php-general Digest 21 Mar 2001 15:58:26 -0000 Issue 580

    Topics (messages 44867 through 44963):

    Re: Cache
            44867 by: Matt Stone
            44868 by: Tyrone Mills
            44869 by: Matt Stone

    PDF reading via IE5.5
            44870 by: Dennis Moore
            44902 by: Stewart Taylor

    PHP/MySQL & Control Structures -> if (mysql_query())
            44871 by: Mike Gifford
            44874 by: David Robley
            44879 by: Mike Gifford
            44886 by: Don Read
            44887 by: David Robley

    Email validation
            44872 by: Mike Gifford
            44873 by: Jason Murray

    Professional Selling SkillMap(tm)
            44875 by: Frontline Learning

    session.gc_maxlifetime
            44876 by: Peter Houchin
            44937 by: Yasuo Ohgaki

    banner exchange, how to?
            44877 by: Ed Lazor
            44878 by: Gfunk
            44908 by: Mark Maggelet

    Booking with Date/Time in mySQL : My Code!!
            44880 by: Thomas Edison Jr.

    Re: Booking by Date/Time in mySQL
            44881 by: Thomas Edison Jr.
            44882 by: Thomas Edison Jr.

    header redirection
            44883 by: dean.aaddesign.com
            44885 by: Jason Murray
            44946 by: Jason Stechschulte
            44948 by: Yasuo Ohgaki

    Booking by Date/Time in mySQL : my CoDe!!
            44884 by: Thomas Edison Jr.

    Re: Create a Bulletin Board
            44888 by: mwaples.waples.net
            44956 by: John Huggins

    Re: update two frames at once?
            44889 by: Kathleen A. Ferraro

    Newsletter kindaa thing
            44890 by: Dhaval Desai
            44891 by: John LYC
            44892 by: David Robley

    Re: email an ms-word attachment (please)
            44893 by: php3.developersdesk.com
            44953 by: Jen Hall
            44962 by: Grant Walters

    PHP post
            44894 by: Paul Juliano
            44895 by: David Robley
            44906 by: Dezider Góra
            44932 by: Tobias Talltorp

    Perl and PHP
            44896 by: Calin Rotaru
            44935 by: Yasuo Ohgaki

    Re: presentation software used by Rasmus Lerdorf
            44897 by: php3.developersdesk.com

    Header Problem
            44898 by: KPortsmout.aol.com
            44899 by: Rasmus Lerdorf
            44939 by: Pierre-Yves Lemaire

    Re: fatal: Symbol referencing errors.
            44900 by: Jimmy Lantz

    Re: Problems connecting to remote mySQL server
            44901 by: almir
            44907 by: Floyd Piedad

    Date solved! And now TIME problems : Booking by Date/Time
            44903 by: Thomas Edison Jr.

    Optional Parameter ?
            44904 by: Jack Sasportas
            44905 by: Stewart Taylor
            44912 by: Neil Kimber
            44919 by: Rudolf Visagie

    sorri- Non-php question
            44909 by: John LYC

    Re: Dynamically build a form from mySQL table
            44910 by: Tim Ward

    Finding every even 100
            44911 by: Nicklas af Ekenstam
            44913 by: Stewart Taylor
            44959 by: Rick St Jean

    Post -vs- Get
            44914 by: Jack Sasportas
            44916 by: Stewart Taylor
            44926 by: Michael Hall
            44949 by: Yasuo Ohgaki

    can you have two sql statements on the same page.
            44915 by: Matt Davis
            44918 by: Jack Sasportas
            44921 by: Jeff Armstrong

    Re: Editing Variables from another script.
            44917 by: techzeus.pacific.net.sg

    function mail()
            44920 by: Eric Tonicello
            44931 by: Tobias Talltorp

    apache problem on startup w/ libmhash
            44922 by: Dean Hall
            44934 by: Yasuo Ohgaki
            44940 by: Dean Hall
            44942 by: Dean Hall
            44943 by: Dean Hall

    Re: Attachment problem with web based mail - CODE SAMPLE
            44923 by: Grant Walters

    Re: Attachment problem with web based mail
            44924 by: Grant Walters

    Response.Write [OK]
            44925 by: AJDIN BRANDIC
            44927 by: Jon Haworth
            44928 by: AJDIN BRANDIC
            44930 by: techzeus.pacific.net.sg
            44933 by: Matt Williams
            44938 by: AJDIN BRANDIC

    Lostpassword script Error
            44929 by: techzeus.pacific.net.sg

    Sessions help please
            44936 by: KPortsmout.aol.com
            44945 by: Hardy Merrill
            44947 by: Jeff Armstrong

    file height and width
            44941 by: george

    Re: [PHP-DB] Transmitting Arrays
            44944 by: Rudolf Visagie

    Re: Setting up mail() for WinXX
            44950 by: Yasuo Ohgaki

    OCI8 server errors -> client
            44951 by: Hardy Merrill

    Re: Status on ISAPI PHP
            44952 by: Yasuo Ohgaki

    Session Help for newbie plz
            44954 by: insight

    New Site for PHP Beginners
            44955 by: Jeff Oien

    Re: [Q] Parser behavior in a string
            44957 by: Tim Ward
            44958 by: Tim Ward

    PHP Verbindung zu mysql
            44960 by: denis mettler
            44961 by: denis mettler
            44963 by: Julie Meloni

    Administrivia:

    To subscribe to the digest, e-mail:
            php-general-digest-subscribelists.php.net

    To unsubscribe from the digest, e-mail:
            php-general-digest-unsubscribelists.php.net

    To post to the list, e-mail:
            php-generallists.php.net

    ----------------------------------------------------------------------

    attached mail follows:


    That goes in the PHP code no?

    -----Original Message-----
    From: Tyrone Mills [mailto:t_millstelus.net]
    Sent: Wednesday, 21 March 2001 1:56 PM
    To: Matt Stone; PHPlist
    Subject: RE: [PHP] Cache

    Hi Matt,

    For a very extensive solution, check this out:

    http://www.zend.com/codex.php?id=435&single=1

    Or, if you just want all your pages to be forced to load all the time
    regardless...

            header("Cache-Control: no-cache, must-revalidate");
            header("Pragma: no-cache");
            header("Expires: Mon,26 Jul 1997 05:00:00 GMT");

    -----Original Message-----
    From: Matt Stone [mailto:mattplanetveggie.com]
    Sent: Tuesday, March 20, 2001 7:39 PM
    To: PHPlist
    Subject: [PHP] Cache

    Hi,
    This might be a little of topic...
    I am having real trouble with cached PHP pages, they just never seem to
    refresh... I have dissabled my local cache (IE5.5 Win2k) to the best of my
    knowledge (suggestions on how to do this properly welcome) but are still
    having trouble.
    I am not sure whether it is my local cache my ISP's cache. Anyhow, can
    anyone suggest a tag or something for me to put in my page so it refreshes
    and bypasses the cache? It is getting _REALLY_ annoying :\
    Thanks,

    Matt Stone

    --
    PHP General Mailing List (http://www.php.net/)
    To unsubscribe, e-mail: php-general-unsubscribelists.php.net
    For additional commands, e-mail: php-general-helplists.php.net
    To contact the list administrators, e-mail: php-list-adminlists.php.net
    

    -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribelists.php.net For additional commands, e-mail: php-general-helplists.php.net To contact the list administrators, e-mail: php-list-adminlists.php.net

    attached mail follows:


    Yup, at the beginning of your PHP script. Sorry, I should have mentioned that... :)

    -----Original Message----- From: Matt Stone [mailto:mattplanetveggie.com] Sent: Tuesday, March 20, 2001 8:04 PM To: Tyrone Mills; PHPlist Subject: RE: [PHP] Cache

    That goes in the PHP code no?

    -----Original Message----- From: Tyrone Mills [mailto:t_millstelus.net] Sent: Wednesday, 21 March 2001 1:56 PM To: Matt Stone; PHPlist Subject: RE: [PHP] Cache

    Hi Matt,

    For a very extensive solution, check this out:

    http://www.zend.com/codex.php?id=435&single=1

    Or, if you just want all your pages to be forced to load all the time regardless...

    header("Cache-Control: no-cache, must-revalidate"); header("Pragma: no-cache"); header("Expires: Mon,26 Jul 1997 05:00:00 GMT");

    -----Original Message----- From: Matt Stone [mailto:mattplanetveggie.com] Sent: Tuesday, March 20, 2001 7:39 PM To: PHPlist Subject: [PHP] Cache

    Hi, This might be a little of topic... I am having real trouble with cached PHP pages, they just never seem to refresh... I have dissabled my local cache (IE5.5 Win2k) to the best of my knowledge (suggestions on how to do this properly welcome) but are still having trouble. I am not sure whether it is my local cache my ISP's cache. Anyhow, can anyone suggest a tag or something for me to put in my page so it refreshes and bypasses the cache? It is getting _REALLY_ annoying :\ Thanks,

    Matt Stone

    --
    PHP General Mailing List (http://www.php.net/)
    To unsubscribe, e-mail: php-general-unsubscribelists.php.net
    For additional commands, e-mail: php-general-helplists.php.net
    To contact the list administrators, e-mail: php-list-adminlists.php.net
    

    -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribelists.php.net For additional commands, e-mail: php-general-helplists.php.net To contact the list administrators, e-mail: php-list-adminlists.php.net

    -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribelists.php.net For additional commands, e-mail: php-general-helplists.php.net To contact the list administrators, e-mail: php-list-adminlists.php.net

    attached mail follows:


    No prob, that works fine. Thanks so much :)

    -----Original Message----- From: Tyrone Mills [mailto:t_millstelus.net] Sent: Wednesday, 21 March 2001 2:04 PM To: Matt Stone; PHPlist Subject: RE: [PHP] Cache

    Yup, at the beginning of your PHP script. Sorry, I should have mentioned that... :)

    -----Original Message----- From: Matt Stone [mailto:mattplanetveggie.com] Sent: Tuesday, March 20, 2001 8:04 PM To: Tyrone Mills; PHPlist Subject: RE: [PHP] Cache

    That goes in the PHP code no?

    -----Original Message----- From: Tyrone Mills [mailto:t_millstelus.net] Sent: Wednesday, 21 March 2001 1:56 PM To: Matt Stone; PHPlist Subject: RE: [PHP] Cache

    Hi Matt,

    For a very extensive solution, check this out:

    http://www.zend.com/codex.php?id=435&single=1

    Or, if you just want all your pages to be forced to load all the time regardless...

    header("Cache-Control: no-cache, must-revalidate"); header("Pragma: no-cache"); header("Expires: Mon,26 Jul 1997 05:00:00 GMT");

    -----Original Message----- From: Matt Stone [mailto:mattplanetveggie.com] Sent: Tuesday, March 20, 2001 7:39 PM To: PHPlist Subject: [PHP] Cache

    Hi, This might be a little of topic... I am having real trouble with cached PHP pages, they just never seem to refresh... I have dissabled my local cache (IE5.5 Win2k) to the best of my knowledge (suggestions on how to do this properly welcome) but are still having trouble. I am not sure whether it is my local cache my ISP's cache. Anyhow, can anyone suggest a tag or something for me to put in my page so it refreshes and bypasses the cache? It is getting _REALLY_ annoying :\ Thanks,

    Matt Stone

    --
    PHP General Mailing List (http://www.php.net/)
    To unsubscribe, e-mail: php-general-unsubscribelists.php.net
    For additional commands, e-mail: php-general-helplists.php.net
    To contact the list administrators, e-mail: php-list-adminlists.php.net
    

    -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribelists.php.net For additional commands, e-mail: php-general-helplists.php.net To contact the list administrators, e-mail: php-list-adminlists.php.net

    -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribelists.php.net For additional commands, e-mail: php-general-helplists.php.net To contact the list administrators, e-mail: php-list-adminlists.php.net

    attached mail follows:


    I have searched long and hard to resolve this issue. I've tried many variations for the header tag. However, I cannot seem to get it to work with IE5.5.

    I am trying to read an Acrobat created PDF file that I uploaded into my MySQL database.

    The problem occurs when I print the data via IE5.5.

    <?php

    header("Content-type: application/pdf"); header("Content-Disposition: attachment; filename=$name");

    print $data;

    ?>

    All I get is echoing of the binary to the browser.

    Any ideas or suggestions?

    /dkm

    attached mail follows:


    Try,

    header("Content-type: application/pdf"); header("Location:$filename");

    -Stewart

    -----Original Message----- From: Dennis Moore [mailto:dennisdkmoore.com] Sent: 21 March 2001 04:14 To: php-generallists.php.net Subject: [PHP] PDF reading via IE5.5

    I have searched long and hard to resolve this issue. I've tried many variations for the header tag. However, I cannot seem to get it to work with IE5.5.

    I am trying to read an Acrobat created PDF file that I uploaded into my MySQL database.

    The problem occurs when I print the data via IE5.5.

    <?php

    header("Content-type: application/pdf"); header("Content-Disposition: attachment; filename=$name");

    print $data;

    ?>

    All I get is echoing of the binary to the browser.

    Any ideas or suggestions?

    /dkm

    -- 
    PHP General Mailing List (http://www.php.net/)
    To unsubscribe, e-mail: php-general-unsubscribelists.php.net
    For additional commands, e-mail: php-general-helplists.php.net
    To contact the list administrators, e-mail: php-list-adminlists.php.net
    

    attached mail follows:


    Hello,

    I'd like the presense or absense of information within a database to be involved in an if statement, however I'm having trouble getting it to work. I've set up the following:

    $same_Email_query = mysql_query("SELECT Email FROM phPetition WHERE Email='" . $Email . "'"); if($same_Email_query){ $error = 1; $error_html .= "This email \"" . $Email . "\" has already been used to sign the petition.<br><br>\n"; }

    In this case, I'd like the mysql_query to search the database for the instance of the submitted $Email and if there is a duplicate entry in the database, then I'd like the if() statement to return an error (as lised above).

    Any idea what I'm doing wrong?

    In a similar way I'm trying to query the database for instances of the same IPAddress:

    $sameIP_query = mysql_query("SELECT FirstName,LastName,CityState,IPAddress FROM phPetition WHERE IPAddress='" . getenv('REMOTE_ADDR') . "' ORDER BY LastName"); if ($sameIP_query) { echo "The following individuals have signed this petition from the same IP: " . getenv('REMOTE_ADDR'); while ($sameIP_array = mysql_fetch_array($sameIP_query)) { echo "<LI>" . stripslashes($individuals_array["FirstName"]) . " " . stripslashes($individuals_array["LastName"]) . " from " . stripslashes($individuals_array["CityState"]); } }

    If the database already has entries which have been submitted from the same IPAddress, I'd like to have those names and numbers listed.

    The previous version of this code is published and available here: http://openconcept.ca/guide-petition.phtml

    Thanks.

    Mike

    --
    Mike Gifford, OpenConcept Consulting, http://openconcept.ca
    Offering everything your organization needs for an effective web site.
    Latest Featured Site: http://www.lornenystrom.org/
    No problem can be solved with the same thinking that created it - A.Einstein
    

    attached mail follows:


    On Wed, 21 Mar 2001 14:58, Mike Gifford wrote: > Hello, > > I'd like the presense or absense of information within a database to be > involved in an if statement, however I'm having trouble getting it to > work. I've set up the following: > > $same_Email_query = mysql_query("SELECT Email FROM phPetition WHERE > Email='" . $Email . "'"); > if($same_Email_query){ > $error = 1; > $error_html .= "This email \"" . $Email . "\" has already been used to > sign the petition.<br><br>\n"; > } > > In this case, I'd like the mysql_query to search the database for the > instance of the submitted $Email and if there is a duplicate entry in > the database, then I'd like the if() statement to return an error (as > lised above). > > Any idea what I'm doing wrong?

    $same_Email_query is a pointer to a result set from the query and will always be true if the query succeeded - where succeeded means something like 'returned 0 or more matching rows'

    What you need to do is check how many matching rows are returned by your query; if there are zero rows, the value doesn't exist in the database.

    > In a similar way I'm trying to query the database for instances of the > same IPAddress: > > $sameIP_query = mysql_query("SELECT > FirstName,LastName,CityState,IPAddress FROM phPetition WHERE > IPAddress='" . getenv('REMOTE_ADDR') . "' ORDER BY LastName"); if > ($sameIP_query) { > > echo "The following individuals have signed this petition from the same > IP: " . getenv('REMOTE_ADDR'); > while ($sameIP_array = mysql_fetch_array($sameIP_query)) { > echo "<LI>" . stripslashes($individuals_array["FirstName"]) . " " . > stripslashes($individuals_array["LastName"]) . " from " . > stripslashes($individuals_array["CityState"]); > } > }

    Shouldn't $individuals_array[ be $sameIP_array[ ? Consider using extract; if nothing else it makes code easier to read :-)

    > If the database already has entries which have been submitted from the > same IPAddress, I'd like to have those names and numbers listed. > > The previous version of this code is published and available here: > http://openconcept.ca/guide-petition.phtml > > Thanks. > > Mike

    -- 
    David Robley                        | WEBMASTER & Mail List Admin
    RESEARCH CENTRE FOR INJURY STUDIES  | http://www.nisu.flinders.edu.au/
    AusEinet                            | http://auseinet.flinders.edu.au/
                Flinders University, ADELAIDE, SOUTH AUSTRALIA
    

    attached mail follows:


    Hi David,

    I counted the number of rows using mysql_numrows(), but I've been told that count() is way faster. Unfortunately, I can't seem to get count working.. Any ideas?

    <?php echo mysql_numrows(mysql_query("select * FROM phPetition",$db));

    // This should be faster, but doesn't seem to work // echo count(mysql_query("select * FROM phPetition",$db)); ?>

    David Robley wrote: > $same_Email_query is a pointer to a result set from the query and will > always be true if the query succeeded - where succeeded means something > like 'returned 0 or more matching rows' > What you need to do is check how many matching rows are returned by your > query; if there are zero rows, the value doesn't exist in the database.

    Great advice. This worked, therefore eliminating duplicates:

    $same_Email_query = mysql_numrows(mysql_query("SELECT Email FROM phPetition WHERE Email='" . $Email . "'")); if($same_Email_query!=0){ $error = 1; $error_html .= "This email \"" . $Email . "\" has already been used to sign the petition.<br><br>\n"; }

    > Shouldn't $individuals_array[ be $sameIP_array[ ? Consider using extract; > if nothing else it makes code easier to read :-)

    This was a neat little solution with the extract code. I found that it started to mess up my existing scripts so I threw it in a function to keep the variables from getting mixed up.

    <? function recent_signatures () { $individuals_query = mysql_query("SELECT * FROM phPetition ORDER BY ID DESC LIMIT 0,5"); while ($individuals_array = mysql_fetch_array($individuals_query)) { echo "<LI>" . stripslashes($individuals_array["FirstName"]) . " " . stripslashes($individuals_array["LastName"]) . " from " . stripslashes($individuals_array["CityState"]); $last_email=$individuals_array["Email"]; }

    $sameIP_query = mysql_query("SELECT FirstName,LastName,CityState,IPAddress FROM phPetition WHERE IPAddress='" . getenv('REMOTE_ADDR') . "' ORDER BY LastName"); if (mysql_numrows($sameIP_query) != 0) { echo "<p>The following individuals have signed this petition from the same IP: " . getenv('REMOTE_ADDR') . "<br>"; while ($sameIP_array = mysql_fetch_array($sameIP_query)) { extract ($sameIP_array); echo "<LI>" . stripslashes($FirstName) . " " . stripslashes($LastName) . " from " . stripslashes($CityState); // echo "<LI>" . stripslashes($sameIP_array["FirstName"]) . " " . stripslashes($sameIP_array["LastName"]) . " from " . stripslashes($sameIP_array["CityState"]); } } } recent_signatures (); ?>

    Thanks Again.

    Mike

    -- 
    Mike Gifford, OpenConcept Consulting, http://openconcept.ca
    Offering everything your organization needs for an effective web site.
    Latest Featured Site: http://www.lornenystrom.org/
    No problem can be solved with the same thinking that created it - A.Einstein
    

    attached mail follows:


    On 21-Mar-01 Mike Gifford wrote: > Hi David, > > I counted the number of rows using mysql_numrows(), but I've been told that > count() is way faster. Unfortunately, I can't seem to get count working.. > Any > ideas? > > <?php > echo mysql_numrows(mysql_query("select * FROM phPetition",$db)); > > // This should be faster, but doesn't seem to work > // echo count(mysql_query("select * FROM phPetition",$db)); > ?> >

    ;)

    $result= mysql_query("select count(*) as cnt FROM phPetition",$db)); if ($result) { $row = mysql_fetch_object($result); echo 'count: ', $row->cnt, '<br>'; }  Regards,

    -- 
    Don Read                                         dreadtexas.net
    -- If you are going to sin, sin against God, not the bureaucracy. 
                      God will forgive you but the bureaucrats won't. 
    

    attached mail follows:


    On Wed, 21 Mar 2001 16:15, Mike Gifford wrote: > Hi David, > > I counted the number of rows using mysql_numrows(), but I've been told > that count() is way faster. Unfortunately, I can't seem to get count > working.. Any ideas? > > <?php > echo mysql_numrows(mysql_query("select * FROM phPetition",$db)); > > // This should be faster, but doesn't seem to work > // echo count(mysql_query("select * FROM phPetition",$db)); > ?>

    Who told you that? Refer them to the manual which will tell them that count will 'count the elements in a variable' or in other words tell you how many elements an array has. mysql_numrows is the way to go here.

    Oh, hang on, maybe they mean the SQL count - "SELECT COUNT(*) as numrows FROM phPetition" and then look at the value of numrows

    Yes, this can be quicker (for varying values of quicker) depending on the number of rows in the table, the way the table is indexed etc etc. But if it would mean another call to the database over and above another query then you may be offsetting any savings you get. For the case of one or zero rows, it's probably insignificant. Unless you are running this on an old Altos 8086 or somesuch?

    In a nutshell, if something is giving you a noticable slowdown, it probably isn't that difference.

    -- 
    David Robley                        | WEBMASTER & Mail List Admin
    RESEARCH CENTRE FOR INJURY STUDIES  | http://www.nisu.flinders.edu.au/
    AusEinet                            | http://auseinet.flinders.edu.au/
                Flinders University, ADELAIDE, SOUTH AUSTRALIA
    

    attached mail follows:


    Hello Again,

    Can anyone tell me what the best form of Email validation there is? It needs to be quick & as open to - and . as possible.

    I've seen the following:

    <? if (eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*[a-z0-9-]+(\.[a-z0-9-]+)*$", $Email)) { $error = 1; $error_html .= "This email address is invalid: " . $Email; echo $error_html; } ?>

    But this one looks quite impressive too:

    <? function checkaddress($mail) { if ( !ereg( "^([0-9,a-z,A-Z]+) ([.,_] ([0-9,a-z,A-Z]+))*[] ([0-9,a-z,A-Z]+)([.,_,-]([0-9,a-z,A-Z] +))*[.]([0-9,a-z,A-Z]){2}([0-9,a-z,A-Z])?$", $mail ) ) { return false; } else { return true; } } ?>

    Not sure which is the best.

    Mike

    -- 
    Mike Gifford, OpenConcept Consulting, http://openconcept.ca
    Offering everything your organization needs for an effective web site.
    Latest Featured Site: http://www.lornenystrom.org/
    No problem can be solved with the same thinking that created it - A.Einstein
    

    attached mail follows:


    > Can anyone tell me what the best form of Email validation > there is? It needs to be quick & as open to - and . as possible.

    We use this one on www.inww.com:

    <? Function validEmail($emailaddress) { // Decides if the email address is valid. Checks syntax and MX records, // for total smartass value. Returns "valid", "invalid-mx" or // "invalid-form". // Validates the email address. I guess it works. *shrug* if (eregi("^[0-9a-z]([-_.]?[0-9a-z])*[0-9a-z]([-.]?[0-9a-z])*\\.[a-z]{2,3}$", $emailaddress, $check)) { //if ( getmxrr(substr(strstr($check[0], ''), 1), $validate_email_temp) ) if ( checkdnsrr(substr(strstr($check[0], ''), 1), "ANY") ) { return "valid"; } else { return "invalid-mx"; } } else { return "invalid-form"; } } ?>

    Jason

    -- 
    Jason Murray
    jasonmmelbourneit.com.au
    Web Design Team, Melbourne IT
    Fetch the comfy chair!
    

    attached mail follows:


    You and I have not met, but because you’re a respected business professional with an interest in improving employee productivity, I would like to offer you a free preview of the Professional Selling SkillMap(tm). This new assessment and skill development resource from Frontline Learning can help you bring added value to your current sales training initiatives by targeting each salesperson's individual development needs.

    This is a truly unique approach to sales training, and if you're open to learning more, please read on. If this is NOT an area of interest for you, I won't take up any more of your time, and I wish you continued success.

    Please note - upon receipt of this message you have automatically been removed from our email marketing list. You will not receive further communication from Frontline Learning unless your proactively respond to the message that follows.

    Kindest regards,

    David Kirkeby VP, Business Development Frontline Learning

    MORE ABOUT THE PROFESSIONAL SELLING SKILLMAP™...

    The Professional Selling SkillMap™ Assessment and Development Guidebook helps salespeople, sales managers and trainers pinpoint the specific selling skills, habits and attitudes they should focus on for improved performance. It includes an assessment of selling skills in 20 categories, providing a graphical representation of each individual’s unique selling strengths and growth opportunities.

    (Please note: Additional SkillMap titles are available on the following topics: Emotional Intelligence, Customer Service, Team Building and Professional Communication)

    The Professional Selling SkillMap can be easily integrated into your existing sales training program or used as a stand-alone training tool for facilitated group training sessions, self-paced individual learning and one-on-one coaching.

    Based upon extensive research and field validation, the assessment measures strengths and growth opportunities in the following skill categories:

    · Product Knowledge · Time Management · Building Rapport · Active Listening · Presenting Benefits · Handling Objections · Prospecting · Handling Adversity · Gaining Commitment · Confirming Needs · Handling Rejection · Self-Motivation · Self-Coaching · Integrity · Reducing Buyer’s Remorse · Sales Cycle Management · Asking Tactical Questions · Asking Strategic Questions · Territory Management · Continuous Learning

    Upon completion of the Assessment, a Development Guidebook provides helpful sales tips, methods and strategies focused on each respondent’s specific development needs.

    A Facilitation and Coaching Guide provides detailed instructions for administering the Assessment along with 20 fully scripted 1-hour workshops (one for each skill category) including handouts, overhead masters and PowerPoint® presentations. Audio programs are available for each skill category to provide post-training skill reinforcement or enhance the effectiveness of self-paced learning and one-on-one coaching.

    SkillMaps and other learning resources are available exclusively through our network of Affiliates - you can visit www.frontlinelearning.com for more information on the Professional Selling SkillMap and our Affiliate program. You can request a free preview at: http://www.frontlinelearning.com/contactus1.htm

    I appreciate the time you've taken to read through this, and again, wish you continued success.

    Sincerely,

    David Kirkeby dkirkebyfrontlinelearning.com 763-404-9555

    Please note - upon receipt of this message you have automatically been removed from our email marketing list. You will not receive further communication from Frontline Learning unless you proactively respond to this message.

    attached mail follows:


    what is the standard with setting the amount of time in session.gc_maxlifetime it has defaulted to 1440 (24 mins) is that considered long enough?

    Peter Houchin peterhsunrentals.com.au ========================================================= _____ __ /\ /_/_/_\ / |_/ \ /_/_/_ __ __ __ __ / \ \_/_/_\ /_/ /_/ /_/ /_/ \ _ / ___\_\_\/ /_/_/_/ /_//\/_/ \_/ \/\_/ \_//_/_/ /_/_/_/ /_/ \/_/ v ________ ________________________________________ /_/_/_/_/ /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ /_/_ _/_/ ______ __ __ /_/ ____ __ ______ /_/_/_/_/ /_/_/_/ /_/ /_/ /_/ /_/\_\ /_/ /_/_/_/ /_/ \_\ /_/ _/ /_//\/_/ /_/ /_/__\_\ /_/___ _\_\_\ /_/ \_\/_/_/_/ /_/ \/_/ /_/ /_/ \_\/_/_/_//_/_/_/ ========================================================= Telephone : (03) 9329 1455 Facsimile : (03) 9329 6755 ************* We rent the dot in .COM! **************

    attached mail follows:


    It depends on your requirement. For me 1440 sec is too short. I'll set it to little over 1 hour because login timeout is 1 hour.

    If you have login/logout system using session, the value better to be larger than login timeout.

    Regards,

    PS: You might want to set gc probability around 10%. Depends on your requirement, though.

    --
    Yasuo Ohgaki
    

    ""Peter Houchin"" <peterhvfsa.com.au> wrote in message news:NFBBJNAGDIPHLCGPBLKDCEBPCBAA.peterhsunrentals.com.au... > what is the standard with setting the amount of time in > session.gc_maxlifetime it has defaulted to 1440 (24 mins) is that considered > long enough? > > Peter Houchin > peterhsunrentals.com.au > ========================================================= > _____ __ /\ > /_/_/_\ / |_/ \ > /_/_/_ __ __ __ __ / \ > \_/_/_\ /_/ /_/ /_/ /_/ \ _ / > ___\_\_\/ /_/_/_/ /_//\/_/ \_/ \/\_/ > \_//_/_/ /_/_/_/ /_/ \/_/ v > ________ ________________________________________ > /_/_/_/_/ /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > /_/_ _/_/ ______ __ __ /_/ ____ __ ______ > /_/_/_/_/ /_/_/_/ /_/ /_/ /_/ /_/\_\ /_/ /_/_/_/ > /_/ \_\ /_/ _/ /_//\/_/ /_/ /_/__\_\ /_/___ _\_\_\ > /_/ \_\/_/_/_/ /_/ \/_/ /_/ /_/ \_\/_/_/_//_/_/_/ > ========================================================= > Telephone : (03) 9329 1455 Facsimile : (03) 9329 6755 > ************* We rent the dot in .COM! ************** > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net >

    attached mail follows:


    Hi =)

    I'd like to setup a banner exchange with some friends. Some of them don't have PHP access, so I'm trying to come up with something that will work for everyone. I checked one site that's running a banner exchange and saw them using a cgi script like this:

    <a href="http://www.site.com/exchange.cgi?ad=NonSSI&page=XX"> <img src="http://www.site.com/exchange.cgi?id=siteB&page=XX"> </a>

    Looking at that, it suggests the cgi script is some how sending image data to be used for displaying the banner ad. Then, on top of that, it's some how routing the visitor to the correct location when they click on the ad. I don't see how they are doing it and figured I'd ask here to see if anyone has any ideas.

    If you're not sure of how they did it, any ideas on how to accomplish what I'm after?

    I came across another site that had the following code and some how they have it working as well. It would be cool to figure out how they did it.

    <IFRAME SRC="http://www.lemnet.com/banners/show/?user=qatlantis" HEIGHT="77" WIDTH="470" SCROLLING="no" MARGINHEIGHT="0" MARGINWIDTH="0" FRAMEBORDER="0"></IFRAME> <ILAYER SRC="http://www.lemnet.com/banners/show/?user=qatlantis" HEIGHT="77" WIDTH="470"></ILAYER> <br> <br>

    attached mail follows:


    you can use a cookie that's sent with the image, or better yet put the whole thing in an <iframe>

    Well that's how i'd do it at least.

    ---------------------------------------------------------------------------- Gfunk - joshgfunk007.com http://www.gfunk007.com/ ----------------------------------------------------------------------------

    ----- Original Message ----- From: "Ed Lazor" <osmosisatfantasy.com> To: <php-generallists.php.net> Sent: Wednesday, March 21, 2001 4:27 PM Subject: [PHP] banner exchange, how to?

    > Hi =) > > I'd like to setup a banner exchange with some friends. Some of them don't > have PHP access, so I'm trying to come up with something that will work for > everyone. I checked one site that's running a banner exchange and saw them > using a cgi script like this: > > <a href="http://www.site.com/exchange.cgi?ad=NonSSI&page=XX"> > <img src="http://www.site.com/exchange.cgi?id=siteB&page=XX"> > </a> > > Looking at that, it suggests the cgi script is some how sending image data > to be used for displaying the banner ad. Then, on top of that, it's some > how routing the visitor to the correct location when they click on the > ad. I don't see how they are doing it and figured I'd ask here to see if > anyone has any ideas. > > If you're not sure of how they did it, any ideas on how to accomplish what > I'm after? > > I came across another site that had the following code and some how they > have it working as well. It would be cool to figure out how they did it. > > <IFRAME SRC="http://www.lemnet.com/banners/show/?user=qatlantis" > HEIGHT="77" WIDTH="470" SCROLLING="no" MARGINHEIGHT="0" MARGINWIDTH="0" > FRAMEBORDER="0"></IFRAME> > <ILAYER SRC="http://www.lemnet.com/banners/show/?user=qatlantis" > HEIGHT="77" WIDTH="470"></ILAYER> <br> <br> > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net >

    attached mail follows:


    On Tue, 20 Mar 2001 21:27:14 -0800, Ed Lazor (osmosisatfantasy.com) wrote: >Hi =) > >I'd like to setup a banner exchange with some friends. Some of them >don't >have PHP access, so I'm trying to come up with something that will >work for >everyone. I checked one site that's running a banner exchange and >saw them >using a cgi script like this: > ><a href="http://www.site.com/exchange.cgi?ad=NonSSI&page=XX">

    this script logs the clickthrough and redirects to the page using header("Location: $url")

    ><img src="http://www.site.com/exchange.cgi?id=siteB&page=XX">

    this script logs the impression and redirects (or passes thru) to the banner

    it's really not very hard you can do the whole thing in about 20 lines of code.

    ></a> > >Looking at that, it suggests the cgi script is some how sending >image data >to be used for displaying the banner ad. Then, on top of that, it's >some >how routing the visitor to the correct location when they click on >the >ad. I don't see how they are doing it and figured I'd ask here to >see if >anyone has any ideas. > >If you're not sure of how they did it, any ideas on how to >accomplish what >I'm after? > >I came across another site that had the following code and some how >they >have it working as well. It would be cool to figure out how they >did it. > ><IFRAME SRC="http://www.lemnet.com/banners/show/?user=qatlantis" >HEIGHT="77" WIDTH="470" SCROLLING="no" MARGINHEIGHT="0" >MARGINWIDTH="0" >FRAMEBORDER="0"></IFRAME> ><ILAYER SRC="http://www.lemnet.com/banners/show/?user=qatlantis" >HEIGHT="77" WIDTH="470"></ILAYER> <br> <br> > > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-general-unsubscribelists.php.net >For additional commands, e-mail: php-general-helplists.php.net >To contact the list administrators, e-mail: php-list- >adminlists.php.net

    attached mail follows:


    Jeff, following is the code as it comes out in my page...can u tell me what i'm doin wrong, besides the fact that i have to replace that famous "uh ohh i got a row back()" with an actual snippet :

    <?php $db = mysql_connect("localhost","root"); mysql_select_db("nidc_intranet",$db); $realsdate="$syear"."-"."$smonth"."-"."$stdate"; $realedate="$eyear"."-"."$emonth"."-"."$endate"; $realstime="$shh".":"."$smm"." "."$sttime"; $realetime="$ehh".":"."$emm"." "."$entime";

    $result = mysql_query("select * from booking where ('$realsdate'>=sdate and '$realsdate'<=edate) or ('$realedate'>=sdate and '$realedate'<=edate)",$db);

    if (uh_ohh_I_got_a_row_back()) { echo "Someone else is sleeping in the bed! No can do!"; } else { $sql = "INSERT INTO booking (room,sdate,edate,stime,etime,purpose,reserved) VALUES ('$rooms','$realsdate','$realedate','$realstime','$realetime','$purpose','$res')"; $result = mysql_query($sql) or Die ("An unexpected error occured. Please go back and book again."); echo "<font face=helvetica size=2 color=#140057><b>Thank you! <font color=#ff0000>$rooms</font>, has been booked from <font color=#ff0000>$realsdate</font> to <font color=#ff0000>$realedate</font>. <br><br> ** Entries will be deleted 2 weeks after the End Date. "; } ?>

    Cheers, T. Edison jr.

    ===== Rahul S. Johari (Director) ****************************************** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : abraxastechyahoo.com Tel : 91-4546512/4522124 *******************************************

    __________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/

    attached mail follows:


    Mr. Armstrong, i'm trying hard to get the message, and i've got most of it and i'm gonna give it a whirl...

    only place where i'm seeing a dizzy question mark is this : if (uh_ohh_I_got_a_row_back())

    right, now what exactly do i put in here that tells me uh ohh, i got a row back!!!! The logic is neat and pretty understandable. i'm only having problem in raw codin. but i'm tryin.

    I think i'm gonna suff in a code and see if it works, and i'll share the stuff with you....

    cheers n thanks, T. Edison jr.

    --- Jeff Armstrong <jeff.armstrongpirum.com> wrote: > the logic goes: > > $start = some_start_date_a_keen_punter_entered(); > $end = the_date_he_wants_to_leave(); > > select * from booking where > ('$start'>=startdate and '$start'<=enddate) or > ('$end'>=startdate and '$end'<=enddate) > > if (uh_ohh_I_got_a_row_back()) > echo "Someone else is sleeping in the bed! No can > do!", > "Cheap discounts for those willing to share a > bed!", > "Are you gorgeous??"; > else > print "You got it!" > insert good bits into database here > > > Of course this is not guaranteed safe, as you can > end up > with double bookings in the pico seconds between the > select > and the insert - but hey, how many hits a second do > you expect. > > > Regards > Jeff's Granny > > > -----Original Message----- > From: Thomas Edison Jr. > [mailto:thomasedisonjryahoo.com] > Sent: Tuesday, March 20, 2001 5:08 PM > To: Jeff Armstrong > Cc: php-generallists.php.net > Subject: RE: SV: [PHP] Booking by Date/Time in mySQL > > > I do get your message Jeff, but tell me, after > having > used the following code .. > > select * from booking where > ('$start'>=startdate and '$start'<=enddate) or > ('$end'>=startdate and '$end'<=enddate) > > what code should be written to actually insert > booking > data into the table? Because this is basically > picking > up data or booking from the Table that fall in this > period. What i want to do is to check if any booking > has been made for this period that i'm inserting > now.... > > T. Edison jr. > > --- Jeff Armstrong <jeff.armstrongpirum.com> wrote: > > One problem is that you are only checking the > first > > booking. > > select * from booking where room='room' > > gives ALL bookings, and you look like you are just > > testing > > the FIRST one. > > > > why not turn it round and do: > > select * from booking where > > ('$start'>=startdate and '$start'<=enddate) or > > ('$end'>=startdate and '$end'<=enddate) > > > > This lets mySQL do the test for you. > > If it returns a row you already have a booking. > > > > > > -----Original Message----- > > From: Thomas Edison Jr. > > [mailto:thomasedisonjryahoo.com] > > Sent: Tuesday, March 20, 2001 11:50 AM > > To: Peter Chr. Hansen > > Cc: php-generallists.php.net > > Subject: Re: SV: [PHP] Booking by Date/Time in > mySQL > > > > > > Peter, > > > > what do you mean by Newdate between date1 & > date2?? > > the logic i'm using is that i'm checkin if the new > > Start Date & End date lies between the old Start > > Date > > & End Date or not. If it does, than entry is > denied, > > else booking is succesfull. But things are not > > running, following is the code i'm using ... > > ---------- > > <?php > > $db = mysql_connect("localhost","root"); > > mysql_select_db("nidc_intranet",$db); > > > > > $realsdate="$syear"."-"."$smonth"."-"."$stdate"; > > > $realedate="$eyear"."-"."$emonth"."-"."$endate"; > > $realstime="$shh".":"."$smm"." "."$sttime"; > > $realetime="$ehh".":"."$emm"." "."$entime"; > > > > $result = mysql_query("SELECT * FROM booking where > > room='$rooms',$db); > > if ($myrow = mysql_fetch_array($result)) { > > do { > > if ($realsdate>=$myrow[sdate]) && > > ($realsdate<=$myrow[edate]) && > > ($realedate>=$myrow[sdate]) && > > ($realedate<=$myrow[edate]) { > > echo "Sorry"; > > } > > else { > > > > $sql = "INSERT INTO booking > > (room,sdate,edate,stime,etime,purpose,reserved) > > VALUES > > > ('$rooms','$realsdate','$realedate','$realstime','$realetime','$purpose','$r > > es')"; > > $result = mysql_query($sql) or Die ("An > > unexpected > > error occured. Please go back and book again."); > > echo "<font face=helvetica size=2 > > color=#140057><b>Thank you! <font > > color=#ff0000>$rooms</font>, has been booked from > > <font color=#ff0000>$realsdate</font> to <font > > color=#ff0000>$realedate</font>. > > <br><br> > > ** Entries will be deleted 2 weeks after the > End > > Date. > > "; > > } > > } while ($myrow = mysql_fetch_array($result)); > > } > > ?> > > ------------ > > > > Regards, > > T. Edison jr. > > > > --- "Peter Chr. Hansen" <PCHschilling.dk> wrote: > > > Can't you use " > > > Newdate between date1 and date2 > > > > > > > > > -----Oprindelig meddelelse----- > > > Fra: Thomas Edison Jr. > > > [mailto:thomasedisonjryahoo.com] > > > Sendt: 20. marts 2001 12:25 > > > Til: php-generallists.php.net > > > Emne: [PHP] Booking by Date/Time in mySQL > > > > > > > > > I'm facing this problem. > > > I have made a room booking application. > > > There is a Start Date & Time and End Date & Time > > of > > > Booking a room. > > > > > > Problem is that once booked, you can't book a > room > > > with a date or time that falls between an > Already > > > booked Date & Time. > > > > > > For example, if someone's booked a room from 3rd > > > March > > > to 10th March between 4:00 p.m. to 12:00 p.m. , > > you > > > can't book the same room for the any date > between > > > 3rd > > > March to 10th March and between 4 pm & 12 pm. > > > > > > How do i do that? > > > > > > Regards, > > > T. Edison jr. > > > > > > > > > ===== > > > Rahul S. Johari (Director) > > > ****************************************** > > > Abraxas Technologies Inc. > > > Homepage : http://www.abraxastech.com > > > Email : abraxastechyahoo.com > > > Tel : 91-4546512/4522124 > > > ******************************************* > > > > > > > __________________________________________________ > === message truncated ===

    ===== Rahul S. Johari (Director) ****************************************** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : abraxastechyahoo.com Tel : 91-4546512/4522124 *******************************************

    __________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/

    attached mail follows:


    Mr. Armstrong, i'm trying hard to get the message, and i've got most of it and i'm gonna give it a whirl...

    only place where i'm seeing a dizzy question mark is this : if (uh_ohh_I_got_a_row_back())

    right, now what exactly do i put in here that tells me uh ohh, i got a row back!!!! The logic is neat and pretty understandable. i'm only having problem in raw codin. but i'm tryin.

    I think i'm gonna suff in a code and see if it works, and i'll share the stuff with you....

    cheers n thanks, T. Edison jr.

    --- Jeff Armstrong <jeff.armstrongpirum.com> wrote: > the logic goes: > > $start = some_start_date_a_keen_punter_entered(); > $end = the_date_he_wants_to_leave(); > > select * from booking where > ('$start'>=startdate and '$start'<=enddate) or > ('$end'>=startdate and '$end'<=enddate) > > if (uh_ohh_I_got_a_row_back()) > echo "Someone else is sleeping in the bed! No can > do!", > "Cheap discounts for those willing to share a > bed!", > "Are you gorgeous??"; > else > print "You got it!" > insert good bits into database here > > > Of course this is not guaranteed safe, as you can > end up > with double bookings in the pico seconds between the > select > and the insert - but hey, how many hits a second do > you expect. > > > Regards > Jeff's Granny > > > -----Original Message----- > From: Thomas Edison Jr. > [mailto:thomasedisonjryahoo.com] > Sent: Tuesday, March 20, 2001 5:08 PM > To: Jeff Armstrong > Cc: php-generallists.php.net > Subject: RE: SV: [PHP] Booking by Date/Time in mySQL > > > I do get your message Jeff, but tell me, after > having > used the following code .. > > select * from booking where > ('$start'>=startdate and '$start'<=enddate) or > ('$end'>=startdate and '$end'<=enddate) > > what code should be written to actually insert > booking > data into the table? Because this is basically > picking > up data or booking from the Table that fall in this > period. What i want to do is to check if any booking > has been made for this period that i'm inserting > now.... > > T. Edison jr. > > --- Jeff Armstrong <jeff.armstrongpirum.com> wrote: > > One problem is that you are only checking the > first > > booking. > > select * from booking where room='room' > > gives ALL bookings, and you look like you are just > > testing > > the FIRST one. > > > > why not turn it round and do: > > select * from booking where > > ('$start'>=startdate and '$start'<=enddate) or > > ('$end'>=startdate and '$end'<=enddate) > > > > This lets mySQL do the test for you. > > If it returns a row you already have a booking. > > > > > > -----Original Message----- > > From: Thomas Edison Jr. > > [mailto:thomasedisonjryahoo.com] > > Sent: Tuesday, March 20, 2001 11:50 AM > > To: Peter Chr. Hansen > > Cc: php-generallists.php.net > > Subject: Re: SV: [PHP] Booking by Date/Time in > mySQL > > > > > > Peter, > > > > what do you mean by Newdate between date1 & > date2?? > > the logic i'm using is that i'm checkin if the new > > Start Date & End date lies between the old Start > > Date > > & End Date or not. If it does, than entry is > denied, > > else booking is succesfull. But things are not > > running, following is the code i'm using ... > > ---------- > > <?php > > $db = mysql_connect("localhost","root"); > > mysql_select_db("nidc_intranet",$db); > > > > > $realsdate="$syear"."-"."$smonth"."-"."$stdate"; > > > $realedate="$eyear"."-"."$emonth"."-"."$endate"; > > $realstime="$shh".":"."$smm"." "."$sttime"; > > $realetime="$ehh".":"."$emm"." "."$entime"; > > > > $result = mysql_query("SELECT * FROM booking where > > room='$rooms',$db); > > if ($myrow = mysql_fetch_array($result)) { > > do { > > if ($realsdate>=$myrow[sdate]) && > > ($realsdate<=$myrow[edate]) && > > ($realedate>=$myrow[sdate]) && > > ($realedate<=$myrow[edate]) { > > echo "Sorry"; > > } > > else { > > > > $sql = "INSERT INTO booking > > (room,sdate,edate,stime,etime,purpose,reserved) > > VALUES > > > ('$rooms','$realsdate','$realedate','$realstime','$realetime','$purpose','$r > > es')"; > > $result = mysql_query($sql) or Die ("An > > unexpected > > error occured. Please go back and book again."); > > echo "<font face=helvetica size=2 > > color=#140057><b>Thank you! <font > > color=#ff0000>$rooms</font>, has been booked from > > <font color=#ff0000>$realsdate</font> to <font > > color=#ff0000>$realedate</font>. > > <br><br> > > ** Entries will be deleted 2 weeks after the > End > > Date. > > "; > > } > > } while ($myrow = mysql_fetch_array($result)); > > } > > ?> > > ------------ > > > > Regards, > > T. Edison jr. > > > > --- "Peter Chr. Hansen" <PCHschilling.dk> wrote: > > > Can't you use " > > > Newdate between date1 and date2 > > > > > > > > > -----Oprindelig meddelelse----- > > > Fra: Thomas Edison Jr. > > > [mailto:thomasedisonjryahoo.com] > > > Sendt: 20. marts 2001 12:25 > > > Til: php-generallists.php.net > > > Emne: [PHP] Booking by Date/Time in mySQL > > > > > > > > > I'm facing this problem. > > > I have made a room booking application. > > > There is a Start Date & Time and End Date & Time > > of > > > Booking a room. > > > > > > Problem is that once booked, you can't book a > room > > > with a date or time that falls between an > Already > > > booked Date & Time. > > > > > > For example, if someone's booked a room from 3rd > > > March > > > to 10th March between 4:00 p.m. to 12:00 p.m. , > > you > > > can't book the same room for the any date > between > > > 3rd > > > March to 10th March and between 4 pm & 12 pm. > > > > > > How do i do that? > > > > > > Regards, > > > T. Edison jr. > > > > > > > > > ===== > > > Rahul S. Johari (Director) > > > ****************************************** > > > Abraxas Technologies Inc. > > > Homepage : http://www.abraxastech.com > > > Email : abraxastechyahoo.com > > > Tel : 91-4546512/4522124 > > > ******************************************* > > > > > > > __________________________________________________ > === message truncated ===

    ===== Rahul S. Johari (Director) ****************************************** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : abraxastechyahoo.com Tel : 91-4546512/4522124 *******************************************

    __________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/

    attached mail follows:


    Why wouldn't this redirect? The query works, but the page won't redirect. I have used the same two lines successfully on other pages. I'm very tired, it's probably obvious.

    <?php // assuming $uid, $itemid, $week, $cur_wk in querystring

    //connect to db $db = mysql_connect ("localhost","user","password"); mysql_select_db("mydb",$db);

    //update item - weekX to Taken and record buyer $sql = "update items set week" . $week . " = 'T', buyerID = " . $uid . " where itemID = " . $itemid; $result = mysql_query($sql);

    $redirurl = "bid.php?uid=" . $uid . "&itemid=" . $itemid; header ($redirurl); ?>

    G'Night Dean

    attached mail follows:


    > Why wouldn't this redirect?

    Because you need to do this:

    <? header ("Location: $redirurl"); ?>

    Jason

    attached mail follows:


    On Tue, Mar 20, 2001 at 10:05:06PM -0800, deanaaddesign.com wrote: > Why wouldn't this redirect? The query works, but the page won't redirect. I > have used the same two lines successfully on other pages. I'm very tired, > it's probably obvious. > > <?php > // assuming $uid, $itemid, $week, $cur_wk in querystring > > //connect to db > $db = mysql_connect ("localhost","user","password"); > mysql_select_db("mydb",$db); > > //update item - weekX to Taken and record buyer > $sql = "update items set week" . $week . " = 'T', buyerID = " . $uid . > " where itemID = " . $itemid; > $result = mysql_query($sql); > > $redirurl = "bid.php?uid=" . $uid . "&itemid=" . $itemid; > header ($redirurl); > ?>

    It appears your code is missing the "Location: " part of the header.

    -- 
    Jason Stechschulte
    jpstechunoh.edu
    --
    It's getting harder and harder to think out loud.  One of these days
    someone's gonna go off and kill Thomas a'Becket for me...
                 -- Larry Wall in <199709242015.NAA10312wall.org>
    

    attached mail follows:


    "Jason Stechschulte" <jpstechunoh.edu> wrote in message news:20010321085311.A2581unwosrv3.unoh.edu... > On Tue, Mar 20, 2001 at 10:05:06PM -0800, deanaaddesign.com wrote: SNIP > > > > $redirurl = "bid.php?uid=" . $uid . "&itemid=" . $itemid; > > header ($redirurl); > > ?> > > It appears your code is missing the "Location: " part of the header.

    In addition to this, you probably better off using absolute URI. (Unless you are using Apache) Refer to RFC for details.

    --
    Yasuo Ohgaki
    

    attached mail follows:


    Mr. Jeff, following is the code i'm using in my page, could you tell me what i'm doing wrong, besides of course the famous "uh ohh i got a row back()" code that needs to be replaced....

    <?php $db = mysql_connect("localhost","root"); mysql_select_db("nidc_intranet",$db); $realsdate="$syear"."-"."$smonth"."-"."$stdate"; $realedate="$eyear"."-"."$emonth"."-"."$endate"; $realstime="$shh".":"."$smm"." "."$sttime"; $realetime="$ehh".":"."$emm"." "."$entime";

    $result = mysql_query("select * from booking where ('$realsdate'>=sdate and '$realsdate'<=edate) or ('$realedate'>=sdate and '$realedate'<=edate)",$db);

    if (uh_ohh_I_got_a_row_back()) { echo "Someone else is sleeping in the bed! No can do!"; } else { $sql = "INSERT INTO booking (room,sdate,edate,stime,etime,purpose,reserved) VALUES ('$rooms','$realsdate','$realedate','$realstime','$realetime','$purpose','$res')"; $result = mysql_query($sql) or Die ("An unexpected error occured. Please go back and book again."); echo "<font face=helvetica size=2 color=#140057><b>Thank you! <font color=#ff0000>$rooms</font>, has been booked from <font color=#ff0000>$realsdate</font> to <font color=#ff0000>$realedate</font>. <br><br> ** Entries will be deleted 2 weeks after the End Date. "; } ?>

    cheers, T. Edison jr.

    ===== Rahul S. Johari (Director) ****************************************** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : abraxastechyahoo.com Tel : 91-4546512/4522124 *******************************************

    __________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/

    attached mail follows:


    Jimmy Bäckström wrote: > > Yo! > I'm thinking of writing a bulletin board and I wonder about threads. I want the board to be built on threads but I don't know how to do it. I want it to look something like this: > > subject 1 > | > |__ reply1 to 'subject 1' > | | > | |__ reply1 to 'reply1 to subject 1' > | | > | |__ reply2 to 'reply1 to subject 1' > | > |__ reply2 to 'subject 1' > > This is important to me so I'm thankful for any help I can get! > > //Broder

    I did it this way for a vbulletin/ubb style board which also does threading

    thread table has in it a coloumn thread_counter

    messages table has a column thread_order

    So say there is thread 1 thread counter goes to 1 order is 1

    2nd post someone replies to 1

    order is 1.2 (2 comes from thread counter)

    3rd post - a reply to 2nd post

    order is 1.2.3

    4th post - someone replies to 2nd post

    order is 1.2.4

    and so on and so on so you can get a threaded view in one sql call. Im using postggresql., interbase and sybase and to do the creation of thread orders I use triggers. Working out the ordering directly in php would really suck - you could get problems with concurrent updates. I never considered MYsql because of it's lack of triggers, stored procedures etc etc People say these are uneccessary but I tend to disagree. They save you a ton of clunky php and help speed things up.

    attached mail follows:


    You mean something like this:

    http://www.astronomy.net/forums/

    > -----Original Message----- > From: Jimmy Bäckström [mailto:broder_bchello.se] > Sent: Tuesday, March 20, 2001 4:54 PM > To: PHP General List > Subject: [PHP] Create a Bulletin Board > > > Yo! > I'm thinking of writing a bulletin board and I wonder about > threads. I want the board to be built on threads but I don't know > how to do it. I want it to look something like this: > > subject 1 > | > |__ reply1 to 'subject 1' > | | > | |__ reply1 to 'reply1 to subject 1' > | | > | |__ reply2 to 'reply1 to subject 1' > | > |__ reply2 to 'subject 1' > > This is important to me so I'm thankful for any help I can get! > > //Broder >

    attached mail follows:


    Jeanne,

    Your script example looks very promising. I have spent two solid days trying to solve this problem. I think what you have provided will be a big help. I am having trouble getting the navigation frame to update, though. I'm not sure what I'm missing. Do you have a working example?

    Best,

    Kathie

    ------------------------------ Kathleen A. Ferraro Senior Curriculum Specialist Office of Medical Education Scaife M211 University of Pittsburgh Pittsburgh, PA 15261 USA

    attached mail follows:


    Hi

    I have a database in whih I have a lot of emails. What I want to do is basically a small newsletter kindaa thing which is to be mailed to all the emails which I am goingto pick from the database.

    If I use

    while($r=mysql_fetch_array($result) { $email = $r['email']; } and then use the mail() function to email. It will just go to one person . I want it to go to all the ppl in the list.

    Thank YOu Dhaval Desai

    Thank yOu

    __________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/

    attached mail follows:


    while($r=mysql_fetch_array($result) $to .=$r['email'].",";

    mail($to,....);

    Dhaval Desai wrote:

    > Hi > > I have a database in whih I have a lot of emails. What > I want to do is basically a small newsletter kindaa > thing which is to be mailed to all the emails which I > am goingto pick from the database. > > If I use > > while($r=mysql_fetch_array($result) > { > $email = $r['email']; > } > and then use the mail() function to email. It will > just go to one person . I want it to go to all the ppl > in the list. > > Thank YOu > Dhaval Desai > > Thank yOu > > __________________________________________________ > Do You Yahoo!? > Get email at your own domain with Yahoo! Mail. > http://personal.mail.yahoo.com/ > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net

    attached mail follows:


    On Wed, 21 Mar 2001 17:01, Dhaval Desai wrote: > Hi > > I have a database in whih I have a lot of emails. What > I want to do is basically a small newsletter kindaa > thing which is to be mailed to all the emails which I > am goingto pick from the database. > > If I use > > while($r=mysql_fetch_array($result) > { > $email = $r['email']; > } > and then use the mail() function to email. It will > just go to one person . I want it to go to all the ppl > in the list. >

    Well, doing it that way you would end up sending an email to each person on the list. Altenatively you could loop through the email addresses and build a cc or bcc to use in the mail() function. Either way, things might slow down a bit if you have a significant number of addresses. Somewhere out there is an email class that might help.

    Alternatively you could use your database to build a 'subscription list' for something like majordomo.

    -- 
    David Robley                        | WEBMASTER & Mail List Admin
    RESEARCH CENTRE FOR INJURY STUDIES  | http://www.nisu.flinders.edu.au/
    AusEinet                            | http://auseinet.flinders.edu.au/
                Flinders University, ADELAIDE, SOUTH AUSTRALIA
    

    attached mail follows:


    Addressed to: Jen Hall <jhallconovertuttle.com> php-generallists.php.net

    ** Reply to note from Jen Hall <jhallconovertuttle.com> Tue, 20 Mar 2001 19:59:26 -0500 > > Hi there > I am trying to build an application where a user can use an > HTML form, fill out some fields, select a file from their > hard drive, and have it emailed as an attachment with the > contents of the form. (essentially, fill in your name and > address, use my module to attach ms-word file of your > resume, send email of all).

    > I am able to make it work with an image as the attachment, > but when I select an MS-WORD document, which is the goal of > this application, it still thinks it's an image, and doesn't > work properly.

    Emailing a .doc file is a VERY BAD idea. VB for applications which is embedded in word is very powerful. What happens when some hacker decides to use your page to send a vba script like the naked wife virus thru your program?

    Oh, here is a resume... lets take a look.

    Open the attachemnt.

    A burst of network activity while the vb script sends a copy of itself to everyone in the victim's address book.

    Then the hard drive light comes on as the program deletes a bunch of important files from the \windows\system directory.

    Finally the computer crashes because windows can't run without the missing files. Even though the machine won't boot, the computer forensics people recover the email, and trace it back to you.

    The victim's lawyers come knocking on your door asking for damages because you let some hacker release a virus thru your program that wiped out several computers at the victim's company, some of their customers, as well as several of his friends.

    You are forced out of business because the damages are more than the value of your entire company.

    Not good.

    Don't believe me? How about one of them:

    http://www.gcn.com/state/vol5_no11/enterprise/491-1.html

    http://members.door.net/kls/virusinfo.htm

    http://venus.soci.niu.edu/~cudigest/CUDS11/cud1120.html

    http://www.jwolsen.com/wtip035.htm

    Want more? - search for 'macro virus' on your favorite search engine.

    NEVER send .doc, .exe, .com, .bat or .vbs files as attachments, and never - ever open them if one is sent to you. Not even from someone you trust. Melissa, Anna and Naked Wife all depend on the fact that the virus often comes from a trusted individual as part of their tactics, and it works! Are you sure your anti-virus software is up to date?

    Rick Widmer Internet Marketing Specialists http://www.developersdesk.com

    attached mail follows:


    Hi Rick I have advised my client of all of the risk you mention. They still want to go ahead. They feel that the bulk of their website visitors are trustworthy (huge assumption on their part), and they tell me they will assume all responsibility for virus checking, etc.

    I still need to know how to do it - technically - to allow an attachment of the kind they desire....

    thanks -jen .

    php3developersdesk.com wrote:

    > Addressed to: Jen Hall <jhallconovertuttle.com> > php-generallists.php.net > > ** Reply to note from Jen Hall <jhallconovertuttle.com> Tue, 20 Mar 2001 19:59:26 -0500 > > > > Hi there > > I am trying to build an application where a user can use an > > HTML form, fill out some fields, select a file from their > > hard drive, and have it emailed as an attachment with the > > contents of the form. (essentially, fill in your name and > > address, use my module to attach ms-word file of your > > resume, send email of all). > > > > I am able to make it work with an image as the attachment, > > but when I select an MS-WORD document, which is the goal of > > this application, it still thinks it's an image, and doesn't > > work properly. > > Emailing a .doc file is a VERY BAD idea. VB for applications which is > embedded in word is very powerful. What happens when some hacker > decides to use your page to send a vba script like the naked wife virus > thru your program? > > Oh, here is a resume... lets take a look. > > Open the attachemnt. > > A burst of network activity while the vb script sends a > copy of itself to everyone in the victim's address book. > > Then the hard drive light comes on as the program deletes > a bunch of important files from the \windows\system directory. > > Finally the computer crashes because windows can't run > without the missing files. Even though the machine won't > boot, the computer forensics people recover the email, and > trace it back to you. > > The victim's lawyers come knocking on your door asking for > damages because you let some hacker release a virus thru > your program that wiped out several computers at the victim's > company, some of their customers, as well as several of > his friends. > > You are forced out of business because the damages are more > than the value of your entire company. > > Not good. > > Don't believe me? How about one of them: > > http://www.gcn.com/state/vol5_no11/enterprise/491-1.html > > http://members.door.net/kls/virusinfo.htm > > http://venus.soci.niu.edu/~cudigest/CUDS11/cud1120.html > > http://www.jwolsen.com/wtip035.htm > > Want more? - search for 'macro virus' on your favorite search engine. > > NEVER send .doc, .exe, .com, .bat or .vbs files as attachments, and > never - ever open them if one is sent to you. Not even from someone you > trust. Melissa, Anna and Naked Wife all depend on the fact that the > virus often comes from a trusted individual as part of their tactics, > and it works! Are you sure your anti-virus software is up to date? > > Rick Widmer > Internet Marketing Specialists > http://www.developersdesk.com

    attached mail follows:


    > php3developersdesk.com wrote: > > > Addressed to: Jen Hall <jhallconovertuttle.com> > > php-generallists.php.net > > > > ** Reply to note from Jen Hall <jhallconovertuttle.com> Tue, > 20 Mar 2001 19:59:26 -0500 > > > > > > Hi there > > > I am trying to build an application where a user can use an > > > HTML form, fill out some fields, select a file from their > > > hard drive, and have it emailed as an attachment with the > > > contents of the form. (essentially, fill in your name and > > > address, use my module to attach ms-word file of your > > > resume, send email of all). > > > > > > > I am able to make it work with an image as the attachment, > > > but when I select an MS-WORD document, which is the goal of > > > this application, it still thinks it's an image, and doesn't > > > work properly. > > > > Emailing a .doc file is a VERY BAD idea. VB for applications which is > > embedded in word is very powerful. What happens when some hacker > > decides to use your page to send a vba script like the naked wife virus > > thru your program? > > > > Oh, here is a resume... lets take a look. > > > > Open the attachemnt. > > > > A burst of network activity while the vb script sends a > > copy of itself to everyone in the victim's address book. > > > > Then the hard drive light comes on as the program deletes > > a bunch of important files from the \windows\system directory. > > > > Finally the computer crashes because windows can't run > > without the missing files. Even though the machine won't > > boot, the computer forensics people recover the email, and > > trace it back to you. > > > > The victim's lawyers come knocking on your door asking for > > damages because you let some hacker release a virus thru > > your program that wiped out several computers at the victim's > > company, some of their customers, as well as several of > > his friends. > > > > You are forced out of business because the damages are more > > than the value of your entire company. > > > > Not good. > > > > Don't believe me? How about one of them: > > > > http://www.gcn.com/state/vol5_no11/enterprise/491-1.html > > > > http://members.door.net/kls/virusinfo.htm > > > > http://venus.soci.niu.edu/~cudigest/CUDS11/cud1120.html > > > > http://www.jwolsen.com/wtip035.htm > > > > Want more? - search for 'macro virus' on your favorite search engine. > > > > NEVER send .doc, .exe, .com, .bat or .vbs files as attachments, and > > never - ever open them if one is sent to you. Not even from someone you > > trust. Melissa, Anna and Naked Wife all depend on the fact that the > > virus often comes from a trusted individual as part of their tactics, > > and it works! Are you sure your anti-virus software is up to date? > > > > Rick Widmer > > Internet Marketing Specialists > > http://www.developersdesk.com > > Hi Rick > I have advised my client of all of the risk you mention. > They still want to go ahead. They feel that the bulk of their > website visitors are > trustworthy (huge assumption on their part), and they tell me > they will assume all > responsibility for virus checking, etc. > > I still need to know how to do it - technically - to allow an > attachment of the kind they > desire.... >

    If you check my post on RE: [PHP] Attachment problem with web based mail - CODE SAMPLE from earlier today you will find the code that will send the file. You can always virus scanners the document before you send it (even on a Unix box).

    Regards

    Grant Walters Brainbench 'Most Valuable Professional' for Unix Admin Walters & Associates, P O Box 13-043 Johnsonville, Wellington, NEW ZEALAND Telephone: +64 4 4765175, CellPhone 025488265, ICQ# 23511989

    attached mail follows:


    Hello,

    How would I simulate an http post in PHP. Something like the equivalent of this:

    <form action="process.php" method=POST> <input type=submit><br> <textarea name=data> <?= $some_values => </textarea> </form>

    And how would I be able to read the resulting page.

    __________________________________ www.edsamail.com

    attached mail follows:


    On Wed, 21 Mar 2001 17:45, Paul Juliano wrote: > Hello, > > How would I simulate an http post in PHP. Something like the > equivalent of this: > > <form action="process.php" method=POST> > <input type=submit><br> > <textarea name=data> > <?= $some_values => > </textarea> > </form> > > And how would I be able to read the resulting page.

    You might find more info here:

    http://marc.theaimsgroup.com/?l=php-general&m=97813345106366&w=2

    -- 
    David Robley                        | WEBMASTER & Mail List Admin
    RESEARCH CENTRE FOR INJURY STUDIES  | http://www.nisu.flinders.edu.au/
    AusEinet                            | http://auseinet.flinders.edu.au/
                Flinders University, ADELAIDE, SOUTH AUSTRALIA
    

    attached mail follows:


    You could use curl functions to do this. Search the manual for curl functions, and enable curl extension in php. hth Dezider

    David Robley wrote:

    > On Wed, 21 Mar 2001 17:45, Paul Juliano wrote: > > Hello, > > > > How would I simulate an http post in PHP. Something like the > > equivalent of this: > > > > <form action="process.php" method=POST> > > <input type=submit><br> > > <textarea name=data> > > <?= $some_values => > > </textarea> > > </form> > > > > And how would I be able to read the resulting page. > > You might find more info here: > > http://marc.theaimsgroup.com/?l=php-general&m=97813345106366&w=2 > > -- > David Robley | WEBMASTER & Mail List Admin > RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/ > AusEinet | http://auseinet.flinders.edu.au/ > Flinders University, ADELAIDE, SOUTH AUSTRALIA > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net

    attached mail follows:


    No can do...

    You can send a post to another page, but not go to that page.

    In order to go to the page the form was was posted, the information must come from the client. You can use javascript for this, but it is not a very stable solution.

    // Tobias

    ""Paul Juliano"" <pauledsamail.com.ph> wrote in message news:ee31c9ab21f0073b6459167fe52c5c41news.php.net... > Hello, > > How would I simulate an http post in PHP. Something like the equivalent > of this: > > <form action="process.php" method=POST> > <input type=submit><br> > <textarea name=data> > <?= $some_values => > </textarea> > </form> > > And how would I be able to read the resulting page. > > __________________________________ > www.edsamail.com > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net >

    attached mail follows:


    Hello

    Is possible to execute a file which was write in Perl from inside a PHP file? If yes, how can I do that?

    attached mail follows:


    I'm not sure what you really want to do, but you can use system() (or others) to execute something on your web server. (You may not be able to do that. It depends on server config)

    Regards,

    --
    Yasuo Ohgaki
    

    "Calin Rotaru" <calinitcnet.ro> wrote in message news:01032109363500.01148zion.itcnet.ro... > Hello > > Is possible to execute a file which was write in Perl from inside a PHP file? > If yes, how can I do that? > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net >

    attached mail follows:


    Addressed to: "Henkie" <deckard_007nospamdeja.com> php-generallists.php.net

    ** Reply to note from "Henkie" <deckard_007nospamdeja.com> Tue, 20 Mar 2001 09:37:22 -0000 > > Hi, > > Recently, I saw a presentation by Rasmus Lerdorf about php. He used > netscape and php scripts as presentation software and it looked really cool. > Does someone know if this is somewhere available ?

    Try here:

    http://conf.php.net/

    Rick Widmer Internet Marketing Specialists http://www.developersdesk.com

    attached mail follows:


    Hi,

    I`m having whats probably a very basic problem but just can`t get my head around it this late in the day, anyone have any idea why this won`t work?

    $URL="domain.com";

    header ("Location: http://www.$URL/members/index.php");

    $URL changes so I can`t write it directly into the header line, anyone?

    attached mail follows:


    Should work just fine.

    On Wed, 21 Mar 2001 KPortsmoutaol.com wrote:

    > Hi, > > I`m having whats probably a very basic problem but just can`t get my head > around it this late in the day, anyone have any idea why this won`t work? > > $URL="domain.com"; > > header ("Location: http://www.$URL/members/index.php"); > > $URL changes so I can`t write it directly into the header line, anyone? > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net >

    attached mail follows:


    Hello, Yes this should work, but if like me, you still have no redirection and you are working with IE 4.0, put exit; after header. $URL="domain.com"; header ("Location: http://www.$URL/members/index.php"); exit;

    I have not seen this anywhere, but putting exit; after a redirection was the only way to get my redirection with header to work.

    py

    ----- Original Message ----- From: Rasmus Lerdorf <rasmusphp.net> To: <KPortsmoutaol.com> Cc: <php-generallists.php.net> Sent: Wednesday, March 21, 2001 7:45 AM Subject: Re: [PHP] Header Problem

    > Should work just fine. > > On Wed, 21 Mar 2001 KPortsmoutaol.com wrote: > > > Hi, > > > > I`m having whats probably a very basic problem but just can`t get my head > > around it this late in the day, anyone have any idea why this won`t work? > > > > $URL="domain.com"; > > > > header ("Location: http://www.$URL/members/index.php"); > > > > $URL changes so I can`t write it directly into the header line, anyone? > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > > For additional commands, e-mail: php-general-helplists.php.net > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net >

    attached mail follows:


    Hi, I was wondewring if someone know the reason to the error below, I'm no Unix guru and my sysadm says he cant get ldap to work due to this, is there anyone who tell me what to tell him to get it to work? greetings Jimmy Lund Sweden

    //ERROR ENCLOSED BELOW.

    gcc -DSOLARIS2=260 -I/usr/local/src/php-4.0.0 -I/usr/local/src/php-4.0.0/Zend -I/usr/local/src/php-4.0.0/Zend -I/usr/local/src/php-4.0.0 `./apaci` -o httpd buildmark.o modules.o modules/php4/libphp4.a modules/extra/libextra.a modules/standard/libstandard.a main/libmain.a ./os/unix/libos.a ap/libap.a -R/usr/ucblib -R/usr/local/ldap-3.3/lib -R/usr/local/mysql-3.22.32/lib/mysql -L/usr/ucblib -L/usr/local/ldap-3.3/lib -L/usr/local/mysql-3.22.32/lib/mysql -Lmodules/php4 -L../modules/php4 -L../../modules/php4 -lmodphp4 -ldb -lpam -ldl -lmysqlclient -lresolv -lresolv -lm -ldl -lcrypt -lnsl -lsocket -lsocket -lsocket -lnsl -lldap -llber -lavl -lldbm -lldif -llthread -lphp4 Undefined first referenced symbol in file ldap_module modules.o ld: fatal: Symbol referencing errors. No output written to httpd collect2: ld returned 1 exit status

    attached mail follows:


    the only problem could be that yourUserwebhost do not have same permisions for this db as yourUseryourHost, check them if you can

    -almir

    "Floyd Piedad" <piedadakasia.com> schrieb im Newsbeitrag news:3AB80A08.AFAF082Cakasia.com... > Hi Almir, > > Yes I checked the names and they are correct. Yes I am able to connect using > the command prompt from the remote server as I am able to list the databases, > tables, etc. remotely. > > Thanks, > > Floyd > > almir wrote: > > > when you connect to server issue > > "show databases" -query then look inside what you can see some servers are > > case sensitive > > i hope that will help, > > and are you sure that you are connected , it could be that you may not > > connect at all because of firewalls or something like that > > -almir > > > > "Floyd Piedad" <piedadakasia.com> schrieb im Newsbeitrag > > news:3AB764B6.C4B8713Aakasia.com... > > > I am trying to connect to a remote mySQL server through PHP but I get a > > > mySQL error of "Unknown Database". I can connect to the remote mySQL > > server > > > using the mysql command but not with PHP. > > > > > > 1. How can I debug what the problem is? > > > 2. Do I need to specify the Port parameter in PHP? > > > 3. Which mySQL error logs do I examine to help me out - the one on the > > local > > > machine or on the remote machine? > > > 4. And where is the mySQL error logs anyway? > > > > > > I tried other lists but no help there. I hope this list helps! > > > > > > Thanks all, > > > > > > Floyd Piedad > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > > > For additional commands, e-mail: php-general-helplists.php.net > > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > > For additional commands, e-mail: php-general-helplists.php.net > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net >

    attached mail follows:


    Hi Almir,

    Here is more info: Server1: where my database resides Server2: where my script resides On Server1: I can access the database using mysql command and PHP. On Server2: I can access the database using mysql -hserver1 .... I can show all the tables, select data, etc. BUT, when running PHP script on this server, (mysql_connect("server1",user,password)) all that happens is that it still connects to the mysql in Server2 and not in Server1.

    I really cannot understand why. Being able to access Server1 using Server2 mysql command verifies my access rights right?

    I am about to give up on this!

    Thanks,

    Floyd

    almir wrote:

    > the only problem could be that yourUserwebhost do not have same permisions > for this db as yourUseryourHost, check them if you can > > -almir > > "Floyd Piedad" <piedadakasia.com> schrieb im Newsbeitrag > news:3AB80A08.AFAF082Cakasia.com... > > Hi Almir, > > > > Yes I checked the names and they are correct. Yes I am able to connect > using > > the command prompt from the remote server as I am able to list the > databases, > > tables, etc. remotely. > > > > Thanks, > > > > Floyd > > > > almir wrote: > > > > > when you connect to server issue > > > "show databases" -query then look inside what you can see some servers > are > > > case sensitive > > > i hope that will help, > > > and are you sure that you are connected , it could be that you may not > > > connect at all because of firewalls or something like that > > > -almir > > > > > > "Floyd Piedad" <piedadakasia.com> schrieb im Newsbeitrag > > > news:3AB764B6.C4B8713Aakasia.com... > > > > I am trying to connect to a remote mySQL server through PHP but I get > a > > > > mySQL error of "Unknown Database". I can connect to the remote mySQL > > > server > > > > using the mysql command but not with PHP. > > > > > > > > 1. How can I debug what the problem is? > > > > 2. Do I need to specify the Port parameter in PHP? > > > > 3. Which mySQL error logs do I examine to help me out - the one on the > > > local > > > > machine or on the remote machine? > > > > 4. And where is the mySQL error logs anyway? > > > > > > > > I tried other lists but no help there. I hope this list helps! > > > > > > > > Thanks all, > > > > > > > > Floyd Piedad > > > > > > > > > > > > -- > > > > PHP General Mailing List (http://www.php.net/) > > > > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > > > > For additional commands, e-mail: php-general-helplists.php.net > > > > To contact the list administrators, e-mail: > php-list-adminlists.php.net > > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > > > For additional commands, e-mail: php-general-helplists.php.net > > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > > For additional commands, e-mail: php-general-helplists.php.net > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net

    attached mail follows:


    i was able to succesfully check for start dates & end dates before feeding new booking in the database using the following code :

    <?php $db = mysql_connect("localhost","root"); mysql_select_db("nidc_intranet",$db); $realsdate="$syear"."-"."$smonth"."-"."$stdate"; $realedate="$eyear"."-"."$emonth"."-"."$endate"; $realstime="$shh".":"."$smm".":"."00"." "."$sttime"; $realetime="$ehh".":"."$emm".":"."00"." "."$entime";

    $result = mysql_query("select * from booking where ('$realsdate'>=sdate and '$realsdate'<=edate) or ('$realedate'>=sdate and '$realedate'<=edate)",$db);

    if (mysql_num_rows($result)) { ?> <script language="javascript"> alert('Sorry, the room is already booked for the period. Please choose a different period'); history.go(-1); </script> <? } else { $sql = "INSERT INTO booking (room,sdate,edate,stime,etime,purpose,reserved) VALUES ('$rooms','$realsdate','$realedate','$realstime','$realetime','$purpose','$res')"; $result = mysql_query($sql) or Die ("An unexpected error occured. Please go back and book again."); echo "<font face=helvetica size=2 color=#140057><b>Thank you! <font color=#ff0000>$rooms</font>, has been booked from <font color=#ff0000>$realsdate</font> to <font color=#ff0000>$realedate</font>. <br><br> ** Entries will be deleted 2 weeks after the End Date. "; } ?>

    But now - TIME problems. I have to check for the same on TIME as well - the problem is - he needs to check for the TIME in that Particular row only...and not as a whole. For eg :- if there's a Booking from 1st August 2001 1:00 p.m. to 1st August 2001 3:00 p.m. (same day), and if someone wants to make a booking for the same day from 4:00 p.m. to 6:00 p.m., my code doesn't allow that. Because he checks for the DATE - and as soon as he will find 1st August, he won't allow a booking to be made for that same day. What do i do?? I know the changes have to be made here :

    $result = mysql_query("select * from booking where ('$realsdate'>=sdate and '$realsdate'<=edate) or ('$realedate'>=sdate and '$realedate'<=edate)",$db);

    but i dodn't know what changes. Please HELP!!

    Cheers, T. Edison jr.

    ===== Rahul S. Johari (Director) ****************************************** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : abraxastechyahoo.com Tel : 91-4546512/4522124 *******************************************

    __________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/

    attached mail follows:


    Is it possible to have a function that looks something like

    function print_this( $value1, $value2, $maybe3) {

    do whatever;

    }

    that would expect $value1, $value2 BUT would not care if $maybe3 came in or not ? and not give an error message that there is a missing paramter ?

    I know I can do a condition within the function, but just want to see if there is a more technical approach as in from php to ignore that optional per say variable.

    I did look in my PHP book by wrox, but no luck.

    Thanks !!!

    attached mail follows:


    You can give $maybe3 a default value which will be used if it is not passed in the function call. You can only do this for the last parameter in the function.

    function print_this ($value1, $value2, $maybe3=false) { do whatever if ($maybe != false) do whatever with $maybe }

    -Stewart

    -----Original Message----- From: Jack Sasportas [mailto:jackinnovativeinternet.com] Sent: 21 March 2001 08:42 To: php Subject: [PHP] Optional Parameter ?

    Is it possible to have a function that looks something like

    function print_this( $value1, $value2, $maybe3) {

    do whatever;

    }

    that would expect $value1, $value2 BUT would not care if $maybe3 came in or not ? and not give an error message that there is a missing paramter ?

    I know I can do a condition within the function, but just want to see if there is a more technical approach as in from php to ignore that optional per say variable.

    I did look in my PHP book by wrox, but no luck.

    Thanks !!!

    -- 
    PHP General Mailing List (http://www.php.net/)
    To unsubscribe, e-mail: php-general-unsubscribelists.php.net
    For additional commands, e-mail: php-general-helplists.php.net
    To contact the list administrators, e-mail: php-list-adminlists.php.net
    

    attached mail follows:


    Alternatively, you can use the approach below. There are different benefits from each approach. The following approach is particularly useful if you want an unlimited number of parameters (like elipses in C).

    function print_this ($value1, $value2) {

    if (3==func_num_args()) { $maybe3=func_get_arg(2); // args are counted from 0 up }

    .. .. }

    -----Original Message----- From: Stewart Taylor [mailto:Stewart.Tayloruk.thalesgroup.com] Sent: 21 March 2001 08:53 To: 'Jack Sasportas'; 'php-generallists.php.net' Subject: RE: [PHP] Optional Parameter ?

    You can give $maybe3 a default value which will be used if it is not passed in the function call. You can only do this for the last parameter in the function.

    function print_this ($value1, $value2, $maybe3=false) { do whatever if ($maybe != false) do whatever with $maybe }

    -Stewart

    -----Original Message----- From: Jack Sasportas [mailto:jackinnovativeinternet.com] Sent: 21 March 2001 08:42 To: php Subject: [PHP] Optional Parameter ?

    Is it possible to have a function that looks something like

    function print_this( $value1, $value2, $maybe3) {

    do whatever;

    }

    that would expect $value1, $value2 BUT would not care if $maybe3 came in or not ? and not give an error message that there is a missing paramter ?

    I know I can do a condition within the function, but just want to see if there is a more technical approach as in from php to ignore that optional per say variable.

    I did look in my PHP book by wrox, but no luck.

    Thanks !!!

    --
    PHP General Mailing List (http://www.php.net/)
    To unsubscribe, e-mail: php-general-unsubscribelists.php.net
    For additional commands, e-mail: php-general-helplists.php.net
    To contact the list administrators, e-mail: php-list-adminlists.php.net
    

    -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribelists.php.net For additional commands, e-mail: php-general-helplists.php.net To contact the list administrators, e-mail: php-list-adminlists.php.net

    attached mail follows:


    Or you can use an array: function print_this( $ArrayValues ) {

    do whatever using count($ArrayValues) to determine the bounds of the array;

    }

    -----Original Message----- From: Neil Kimber [mailto:neil.kimberflytxt.com] Sent: 21 March 2001 11:44 To: Stewart Taylor; 'Jack Sasportas'; php-generallists.php.net Subject: RE: [PHP] Optional Parameter ?

    Alternatively, you can use the approach below. There are different benefits from each approach. The following approach is particularly useful if you want an unlimited number of parameters (like elipses in C).

    function print_this ($value1, $value2) {

    if (3==func_num_args()) { $maybe3=func_get_arg(2); // args are counted from 0 up }

    .. .. }

    -----Original Message----- From: Stewart Taylor [mailto:Stewart.Tayloruk.thalesgroup.com] Sent: 21 March 2001 08:53 To: 'Jack Sasportas'; 'php-generallists.php.net' Subject: RE: [PHP] Optional Parameter ?

    You can give $maybe3 a default value which will be used if it is not passed in the function call. You can only do this for the last parameter in the function.

    function print_this ($value1, $value2, $maybe3=false) { do whatever if ($maybe != false) do whatever with $maybe }

    -Stewart

    -----Original Message----- From: Jack Sasportas [mailto:jackinnovativeinternet.com] Sent: 21 March 2001 08:42 To: php Subject: [PHP] Optional Parameter ?

    Is it possible to have a function that looks something like

    function print_this( $value1, $value2, $maybe3) {

    do whatever;

    }

    that would expect $value1, $value2 BUT would not care if $maybe3 came in or not ? and not give an error message that there is a missing paramter ?

    I know I can do a condition within the function, but just want to see if there is a more technical approach as in from php to ignore that optional per say variable.

    I did look in my PHP book by wrox, but no luck.

    Thanks !!!

    --
    PHP General Mailing List (http://www.php.net/)
    To unsubscribe, e-mail: php-general-unsubscribelists.php.net
    For additional commands, e-mail: php-general-helplists.php.net
    To contact the list administrators, e-mail: php-list-adminlists.php.net
    

    -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribelists.php.net For additional commands, e-mail: php-general-helplists.php.net To contact the list administrators, e-mail: php-list-adminlists.php.net

    -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribelists.php.net For additional commands, e-mail: php-general-helplists.php.net To contact the list administrators, e-mail: php-list-adminlists.php.net

    attached mail follows:


    Sorry guys... this is not a php question... but this is by far the best web resource i have seem...so here goes..

    does anyone here know of any mailing list for perl or JAVA...? any great web resrcs/website?

    anyway, so far.. i still think php official website provides the best resource for their language as compare to the other languages...

    thanks john

    attached mail follows:


    $result = mysql_db_query("FocusDynamics", "SHOW COLUMNS FROM items"); while($field = mysql_fetch_array($result)) { $thisfield = $field["field"]; echo("<tr>"); echo("<td>$thisfield</td><td><input type=text ... name=$thisfield></td>"); echo("</tr>"); }

    I'm assuming mysql. You may want to play around with analysing $field["type"] to get the right input attributes. There may be a slicker way, but I think this is pretty straight forward and the "SHOW COLUMNS" query isn't going to be slow.

    ... also this untested so please treat as pseudo code.

    Tim Ward Senior Systems Engineer

    Please refer to the following disclaimer in respect of this message: http://www.stivesdirect.com/e-mail-disclaimer.html

    > -----Original Message----- > From: Martin E. Koss [mailto:mekmek.co.uk] > Sent: 20 March 2001 18:06 > To: php-generallists.php.net > Subject: Dynamically build a form from mySQL table > > > Hi, > I've been trying to figure this out by looking through the code in > phpMyAdmin but I'm not getting very far. There's probably > some help about it > somewhere. > > What I want to do is dynamically generate a form where I get > a table row > containing the field name in one cell and the input field in > the next cell, > for example: > > $DatabaseName = "FocusDynamics"; > $TableName = "Items"; > > // open the table and get all field names, sizes, etc., > > // for each Field name, print something like: > > PRINT "<tr>\n"; > PRINT "<td>$FieldName</td>\n"; > PRINT "<td><input type=\"text\" name=\"$FieldName\" > value=\"$FieldValue\" > maxlength=\"FieldSize\"></td>\n"; > PRINT "</tr>"; > > How do I get all this info from the table? > > Thanks for any help. > > > Martin E. Koss > M: 07946-706459 > E: mekmek.co.uk > >

    attached mail follows:


    Hi

    Propably a really simple question, but my math skills are not up to speed anymore:

    How do I find out if an int is an even 100? I.e. 100, 200, 1200, 9900 etc. I could always divide by 100 and have a look at the result and se if it has any decimals but I'm guessing this could be done prettier using modulus. Right?

    - Nille

    attached mail follows:


    If the number divided by 100 hundred has no remainder e.g. if (($num % 100) == 0) even_100 = true;

    -Stewart

    -----Original Message----- From: Nicklas af Ekenstam [mailto:nnille.org] Sent: 21 March 2001 09:38 To: php-generallists.php.net Subject: [PHP] Finding every even 100

    Hi

    Propably a really simple question, but my math skills are not up to speed anymore:

    How do I find out if an int is an even 100? I.e. 100, 200, 1200, 9900 etc. I could always divide by 100 and have a look at the result and se if it has any decimals but I'm guessing this could be done prettier using modulus. Right?

    - Nille

    -- 
    PHP General Mailing List (http://www.php.net/)
    To unsubscribe, e-mail: php-general-unsubscribelists.php.net
    For additional commands, e-mail: php-general-helplists.php.net
    To contact the list administrators, e-mail: php-list-adminlists.php.net
    

    attached mail follows:


    $i % 100 = 0

    At 10:37 AM 3/21/01 +0100, Nicklas af Ekenstam wrote: >Hi > >Propably a really simple question, but my math skills are not up to speed >anymore: > >How do I find out if an int is an even 100? I.e. 100, 200, 1200, 9900 etc. >I could always divide by 100 and have a look at the result and se if it >has any decimals but I'm guessing this could be done prettier using >modulus. Right? > >- Nille > > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-general-unsubscribelists.php.net >For additional commands, e-mail: php-general-helplists.php.net >To contact the list administrators, e-mail: php-list-adminlists.php.net

    ########################################################## # Rick St Jean, # rstjeaninternet.look.ca # President of Design Shark, # http://www.designshark.com/ # Quick Contact: http://www.designshark.com/messaging.ihtml # Tel: 905-684-2952 ##########################################################

    attached mail follows:


    I have written a system with authentication to gain access to individual data. Since I am using the post method the command line has something like

    abc.com?client_no=5

    Now even though if that person emails you that url, you won't gain access to it bascause of authentication that is needed, what can happen is an authorized user could change the 5 in the url to 8, and then see the information that is there which belongs to client 8.

    Because of this I am thinking in this case I should be using the post method instead of the get method.

    Does anyone have a link to a doc that has a good example in both methods along with a good explanation so that I can make sure I understand what it's doing?

    Thanks for your help!

    Jack

    attached mail follows:


    It would be better to use randomly generated strings for your client ids e.g. md5(uniqid(rand())); This would be must harder for another use to guess.

    Even better would be to store your users details in a session variable so that the id will never appear in the url at all.

    e.g. a very basic example.

    session_name("YOURSESSIONID") session_start();

    authenticate etc.. and read user details into $user array/object;

    session_register($user);

    then as long as your using the same browser session and you have

    session_name("YOURSESSIONID"); session_start();

    at the beginning of each page you can access $user.

    If you open a new window you can do something like

    abc.php?session_id=session_id()

    abc.php

    session_id($session_id); session_name("YOURSESSIONID"); session_start()

    and carry on using $user.

    -Stewart

    -----Original Message----- From: Jack Sasportas [mailto:jackinnovativeinternet.com] Sent: 21 March 2001 10:02 To: php Subject: [PHP] Post -vs- Get

    I have written a system with authentication to gain access to individual data. Since I am using the post method the command line has something like

    abc.com?client_no=5

    Now even though if that person emails you that url, you won't gain access to it bascause of authentication that is needed, what can happen is an authorized user could change the 5 in the url to 8, and then see the information that is there which belongs to client 8.

    Because of this I am thinking in this case I should be using the post method instead of the get method.

    Does anyone have a link to a doc that has a good example in both methods along with a good explanation so that I can make sure I understand what it's doing?

    Thanks for your help!

    Jack

    -- 
    PHP General Mailing List (http://www.php.net/)
    To unsubscribe, e-mail: php-general-unsubscribelists.php.net
    For additional commands, e-mail: php-general-helplists.php.net
    To contact the list administrators, e-mail: php-list-adminlists.php.net
    

    attached mail follows:


    > abc.com?client_no=5 > > Now even though if that person emails you that url, you won't gain > access to it bascause of authentication that is needed, what can happen > is an authorized user could change the 5 in the url to 8, and then see > the information that is there which belongs to client 8. > > Because of this I am thinking in this case I should be using the post > method instead of the get method.

    Even then a user could save the source code of your form, alter the POST information, and send it back with the same effect.

    You should probably look at having some kind of individualised authentication scheme rather than a blanket one, using sessions/cookies perhaps. POST alone is not the solution.

    Mick

    attached mail follows:


    Since original poster requests where to look. http://www.php.net/manual/en/language.variables.external.php PHP manual is great reference for PHP programmers. If you haven't read, it is recommended to read.

    Another link in zend.com http://www.zend.com/zend/tut/ There are many useful links in www.zend.com

    You get more links here http://www.php.net/links.php

    --
    Yasuo Ohgaki
    

    "Jack Sasportas" <jackinnovativeinternet.com> wrote in message news:3AB87BFD.EFAEDE83innovativeinternet.com... > I have written a system with authentication to gain access to individual > data. > Since I am using the post method the command line has something like > > abc.com?client_no=5 > > Now even though if that person emails you that url, you won't gain > access to it bascause of authentication that is needed, what can happen > is an authorized user could change the 5 in the url to 8, and then see > the information that is there which belongs to client 8. > > Because of this I am thinking in this case I should be using the post > method instead of the get method. > > Does anyone have a link to a doc that has a good example in both methods > along with a good explanation so that I can make sure I understand what > it's doing? > > Thanks for your help! > > Jack > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net >

    attached mail follows:


    I want to extract 2 sets of data each from different tables in the same db but display the results on the same page at the same time. Can I just have two sql statements like this or do I need to do something else.

    //sql statement 1 $sql1 = "select club_full_name from clubs where club_name = '$id' ";

    //sql statement 2 $sql2 = "select message,message_title from noticeboard where club_name = '$id' ";

    //execute sql1 query and get results $sql_result1 = mysql_query($sql1);

    //execute sql2 query and get results $sql_result2 = mysql_query($sql2);

    /*results variables for data to be displayed*/

    while ($row = mysql_fetch_array($sql_result1)) { $name = $row["club_full_name"];

    }

    How can I put both sets of results in the while statement.

    Any help would be kindly appreciated

    Matt.

    attached mail follows:


    The simple answer would be 2 while statements, but are you trying to mix the results or are you keeping them seperate? By mix there are 2 options

    value_db1 Value_db2 Value_db1

    or

    value_db1 value_db1 value_db2 value_db1

    by the simple answer above it would result in something like Category #1 value_db1 value_db1 value_db1 value_db1 value_db1 Category #2 value_db2 value_db2 value_db2 value_db2 value_db2

    or a side by side thing....

    Also how many records (approx) are you dealing with ? you could bring the value from each table into an array and then dump the values stored in the array.

    Hope this helps...

    Jack

    Matt Davis wrote:

    > I want to extract 2 sets of data each from different tables in the same db > but display the results on the same page at the same time. Can I just have > two sql statements like this or do I need to do something else. > > //sql statement 1 > $sql1 = "select club_full_name from clubs where club_name = '$id' "; > > //sql statement 2 > $sql2 = "select message,message_title from noticeboard where club_name = > '$id' "; > > //execute sql1 query and get results > $sql_result1 = mysql_query($sql1); > > //execute sql2 query and get results > $sql_result2 = mysql_query($sql2); > > /*results > variables for data to be displayed*/ > > while ($row = mysql_fetch_array($sql_result1)) { > $name = $row["club_full_name"]; > > } > > How can I put both sets of results in the while statement. > > Any help would be kindly appreciated > > Matt. > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net

    attached mail follows:


    Matt,

    > put two sets of data in the same while loop...

    If there is some logical relationship between the sets of records then consider adding a join:

    $sql = "select club_full_name,message,messate_title " " from clubs,noticeboard " " where clubs.club_name = noticeboard.club_name and clubs.clubname = '$id' ";

    You can then iterate through this result:

    $sth = mysql_query($sql);

    $last = ''; while ($row = mysql_fetch_array($sql_result1)) { if ( $last != $row[club_full_name] ) { echo "<HR><B>$row["club_full_name"</B><BR>\n"; } echo "$row[message_title]&nbsp;<I>$row[message]</I><BR>\n"; $last = $row["club_full_name"]; }

    Regards Jeff -----Original Message----- From: Matt Davis [mailto:mattroundyourway.co.uk] Sent: Wednesday, March 21, 2001 10:23 AM To: Php Mailing List Subject: [PHP] can you have two sql statements on the same page.

    I want to extract 2 sets of data each from different tables in the same db but display the results on the same page at the same time. Can I just have two sql statements like this or do I need to do something else.

    //sql statement 1 $sql1 = "select club_full_name from clubs where club_name = '$id' ";

    //sql statement 2 $sql2 = "select message,message_title from noticeboard where club_name = '$id' ";

    //execute sql1 query and get results $sql_result1 = mysql_query($sql1);

    //execute sql2 query and get results $sql_result2 = mysql_query($sql2);

    /*results variables for data to be displayed*/

    while ($row = mysql_fetch_array($sql_result1)) { $name = $row["club_full_name"];

    }

    How can I put both sets of results in the while statement.

    Any help would be kindly appreciated

    Matt.

    --
    PHP General Mailing List (http://www.php.net/)
    To unsubscribe, e-mail: php-general-unsubscribelists.php.net
    For additional commands, e-mail: php-general-helplists.php.net
    To contact the list administrators, e-mail: php-list-adminlists.php.net
    

    attached mail follows:


    What are the functions that can achieve that ?

    ----- Original Message ----- From: "Neil Kimber" <neil.kimberflytxt.com> To: <techzeuspacific.net.sg>; "Stewart Taylor" <Stewart.Tayloruk.thalesgroup.com>; <php-generallists.php.net> Sent: Wednesday, March 21, 2001 12:24 AM Subject: RE: [PHP] Editing Variables from another script.

    > Gotya. The why not limit your include file to only contain those values that > are important to you. So you get something like: > > varsdatabase.inc > > $dbhost="xxxxx"; > $dbuser="yyyyy"; > $dbpass="zzzzz"; > > Then, in your PHP code you just rewrite this simple file. That way you don't > have to worry about parsing files etc... Just delete the existing > varsdatabase.inc and build a new one from scratch. It's no longer difficult > because it's only 3 lines long. > > > > > > > > $dbhost='localhost'; > > -----Original Message----- > From: techzeuspacific.net.sg [mailto:techzeuspacific.net.sg] > Sent: 20 March 2001 14:26 > To: Neil Kimber; Stewart Taylor; php-generallists.php.net > Subject: Re: [PHP] Editing Variables from another script. > > > Basically, thats not what I'm going to do. > > I'm making an administrative script such that admins can change the location > and values of the $dbhost, $dbuser, $dbpass in the database.inc with just a > form. > > Kinda tough eh ? > > ----- Original Message ----- > From: "Neil Kimber" <neil.kimberflytxt.com> > To: <techzeuspacific.net.sg>; "Stewart Taylor" > <Stewart.Tayloruk.thalesgroup.com>; <php-generallists.php.net> > Sent: Tuesday, March 20, 2001 10:25 PM > Subject: RE: [PHP] Editing Variables from another script. > > > > It depends upon what your overall aim actually is. > > > > If you want a different value depending upon where this file is being used > > in your site, then you should probably just set the value accordingly in > > that part of the site. > > i.e. > > > > include "database.inc" > > > > . > > > > . > > > > . > > > > . > > > > $dbhost='localhost'; > > > > If you want a different value in the same place based upon a different > > 'user' or other criteria, then you should probably write some logic to > > handle the situation. > > i.e. > > > > include "database.inc"; > > > > if (MYCRITERIA) > > { > > $dbhost='localhost'; > > } > > > > The only reason that I can think of for you wanting to change the physical > > file would be if you are writing some code to generate a release for > > different users. In which case, you'll probably want to build a parser and > > use some kind of templating system. > > > > Neil > > > > -----Original Message----- > > From: techzeuspacific.net.sg [mailto:techzeuspacific.net.sg] > > Sent: 20 March 2001 14:08 > > To: Neil Kimber; Stewart Taylor; php-generallists.php.net > > Subject: Re: [PHP] Editing Variables from another script. > > > > > > What other ways might there be ? > > > > > > ----- Original Message ----- > > From: "Neil Kimber" <neil.kimberflytxt.com> > > To: <techzeuspacific.net.sg>; "Stewart Taylor" > > <Stewart.Tayloruk.thalesgroup.com>; <php-generallists.php.net> > > Sent: Tuesday, March 20, 2001 6:10 PM > > Subject: RE: [PHP] Editing Variables from another script. > > > > > > > Do you mean that you want to alter the physical contents of > > 'database.inc'? > > > This would require you parsing the existing file yourself, writing a new > > > version of the file, altering the relevant line of code, removing the > > > original file and renaming your new file to the original filename. > > > > > > This isn't a good approach, are you sure there isn't a different way for > > you > > > acheive your aims? > > > > > > -----Original Message----- > > > From: techzeuspacific.net.sg [mailto:techzeuspacific.net.sg] > > > Sent: 20 March 2001 10:02 > > > To: Stewart Taylor; php-generallists.php.net > > > Subject: Re: [PHP] Editing Variables from another script. > > > > > > > > > I think you didn't get what I meant, > > > > > > I need a script such that I can change the content of database.inc from > an > > > external script (form or whatever) > > > > > > > > > ----- Original Message ----- > > > From: "Stewart Taylor" <Stewart.Tayloruk.thalesgroup.com> > > > To: <techzeuspacific.net.sg>; <php-generallists.php.net> > > > Sent: Tuesday, March 20, 2001 5:57 PM > > > Subject: RE: [PHP] Editing Variables from another script. > > > > > > > > > > > > > > > > > > include "database.inc" > > > > . > > > > . > > > > . > > > > . > > > > $dbhost='localhost'; > > > > > > > > > > > > > > > > -Stewart > > > > > > > > -----Original Message----- > > > > From: techzeuspacific.net.sg [mailto:techzeuspacific.net.sg] > > > > Sent: 20 March 2001 09:26 > > > > To: Jason Stechschulte > > > > Cc: 'PHP General List. (E-mail)' > > > > Subject: Re: [PHP] Editing Variables from another script. > > > > > > > > > > > > Okay, basically, > > > > > > > > I'm trying to create a script such that it will change the variables > > > inside > > > > of my .inc page. > > > > > > > > Something like > > > > > > > > lets say I have this file called "database.inc" > > > > Inside it I have : > > > > > > > > $dbhost = 'blah' > > > > $dbuser= 'blah' > > > > $dbpass= 'blah' > > > > > > > > I would like to make a script such that I can modify the $variables > into > > > > something else like, $dbhost into localhost. > > > > > > > > How can it be done? > > > > ----- Original Message ----- > > > > From: "Jason Stechschulte" <jpstechunoh.edu> > > > > To: <techzeuspacific.net.sg> > > > > Cc: "'PHP General List. (E-mail)'" <php-generallists.php.net> > > > > Sent: Monday, March 19, 2001 11:03 PM > > > > Subject: Re: [PHP] Editing Variables from another script. > > > > > > > > > > > > > On Sun, Mar 18, 2001 at 01:06:34PM +0800, techzeuspacific.net.sg > > wrote: > > > > > > > > > > > I'm trying to create a form whereby I can edit the variables with > > just > > > > the form. > > > > > > > > > > > > It will be something like a form for me to change the database > > > > details(username,server,password) in a .inc I'm using. > > > > > > > > > > > > Is there anyway for me to pass information into another file's > > > variable > > > > and have it saved in there? > > > > > > > > > > > > If anyone have seen Newspro (CGI) before, when you edit some parts > > in > > > a > > > > form, the information will be saved. How can it be done in PHP? > > > > > > > > > > There is probably a hundred or more ways this can be done. For me > to > > be > > > > > able to give you specifics, you will have to be more specific with > > what > > > > > you are doing and what you have tried. > > > > > > > > > > -- > > > > > Jason Stechschulte > > > > > jpstechunoh.edu > > > > > -- > > > > > Well, I think Perl should run faster than C. :-) > > > > > -- Larry Wall in <199801200306.TAA11638wall.org> > > > > > > > > > > -- > > > > > PHP General Mailing List (http://www.php.net/) > > > > > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > > > > > For additional commands, e-mail: php-general-helplists.php.net > > > > > To contact the list administrators, e-mail: > > php-list-adminlists.php.net > > > > > > > > > > > > > > > > > -- > > > > PHP General Mailing List (http://www.php.net/) > > > > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > > > > For additional commands, e-mail: php-general-helplists.php.net > > > > To contact the list administrators, e-mail: > php-list-adminlists.php.net > > > > > > > > -- > > > > PHP General Mailing List (http://www.php.net/) > > > > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > > > > For additional commands, e-mail: php-general-helplists.php.net > > > > To contact the list administrators, e-mail: > php-list-adminlists.php.net > > > > > > > > > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > > > For additional commands, e-mail: php-general-helplists.php.net > > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > > > > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > > > For additional commands, e-mail: php-general-helplists.php.net > > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > > For additional commands, e-mail: php-general-helplists.php.net > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > > > > > >

    attached mail follows:


    Hi !

    I'm trying to use the function mail().

    <?php mail("testxxx.com", "subject", "message"); ?>

    I get :

    Warning: Failed to Connect in D:\IBOIS\web\test.php on line 1

    I'm using the lastest version of PHP on IIS 4.0

    What's wrong ?

    Should I change the php.ini ?

    If I try to use the snmp library i get lot of errors...

    PLease help.me

    mcfly

    attached mail follows:


    See the SMTP value in your PHP.ini and set it to a valid outgoing mail server

    Another thing I have noticed, perhaps this is only me, is that if the TO-address isn´t valid it will fail. Try to send an email to your own email address...

    // Tobias

    ""Eric Tonicello"" <eric.tonicelloepfl.ch> wrote in message news:99a1hq$tns$1toye.p.sourceforge.net... > Hi ! > > I'm trying to use the function mail(). > > <?php mail("testxxx.com", "subject", "message"); ?> > > I get : > > Warning: Failed to Connect in D:\IBOIS\web\test.php on line 1 > > I'm using the lastest version of PHP on IIS 4.0 > > What's wrong ? > > Should I change the php.ini ? > > If I try to use the snmp library i get lot of errors... > > PLease help.me > > mcfly > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net >

    attached mail follows:


    (Sorry for the cross-post; I'd like to get this solved, as I haven't been able to find a solution for several months.)

    I have installed mhash and libmcrypt (and mcrypt, for that matter), configured php with both of the extensions, and compiled PHP (as a DSO), and apache gives the following error when I attempt to start it:

    Cannot load /usr/local/apache/libexec/libphp4.so into server: libmhash.so.2: cannot open shared object file: No such file or directory

    Here are the details:

    Webserver: - apache-1.3.19 compiled with (- mm-1.1.3) - mod_ssl-2.8.1-1.3.19 (compiled as a static module)

    PHP (DSO): - php-4.0.4pl1 compiled with extensions: - libmcrypt-2.4.7 - mhash-0.8.9

    I installed mcrypt-2.2.6 as well, but I soon realized that the PHP documentation said I should install libmcrypt, not mcrypt. Interestingly, php never complained that libmcrypt was not installed during configure. I'm not a *nix guru, and I don't understand completely how the dynamic linking process works, but this seems wrong.

    Any thoughts? I'm pretty desperate here. :-) Otherwise I'll have to start using the openssl shell command.

    Dean Hall. Apt7.com Web Services

    attached mail follows:


    At first find where is libmhash.so.2. Then edit your ld.so.conf. Then run ldconfig.

    Filename and command name may vary, I can't tell since you didn't mention your OS.

    Alternatively, you can build into PHP if you have static lib. I prefer this way for non standard libs to make sure web server starts up even w/o shared libs.

    Regards,

    --
    Yasuo Ohgaki
    

    ""Dean Hall"" <hallapt7.com> wrote in message news:99a2gd$b2v$1toye.p.sourceforge.net... > (Sorry for the cross-post; I'd like to get this solved, as I haven't been > able to find a solution for several months.) > > I have installed mhash and libmcrypt (and mcrypt, for that matter), > configured php with both of the extensions, and compiled PHP (as a DSO), and > apache gives the following error when I attempt to start it: > > Cannot load /usr/local/apache/libexec/libphp4.so into server: libmhash.so.2: > cannot open shared object file: No such file or directory > > Here are the details: > > Webserver: > - apache-1.3.19 compiled with > (- mm-1.1.3) > - mod_ssl-2.8.1-1.3.19 (compiled as a static module) > > > PHP (DSO): > - php-4.0.4pl1 compiled with extensions: > - libmcrypt-2.4.7 > - mhash-0.8.9 > > I installed mcrypt-2.2.6 as well, but I soon realized that the PHP > documentation said I should install libmcrypt, not mcrypt. Interestingly, > php never complained that libmcrypt was not installed during configure. I'm > not a *nix guru, and I don't understand completely how the dynamic linking > process works, but this seems wrong. > > Any thoughts? I'm pretty desperate here. :-) Otherwise I'll have to start > using the openssl shell command. > > Dean Hall. > Apt7.com Web Services > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net >

    attached mail follows:


    ""Yasuo Ohgaki"" <yohgakihotmail.com> wrote in message news:99a7rf$rer$1toye.p.sourceforge.net... > At first find where is libmhash.so.2. Then edit your ld.so.conf. > Then run ldconfig.

    I'm trying this, and I'll get back to you on whether it works.

    > Filename and command name may vary, I can't tell since you didn't > mention your OS.

    RedHat Linux.

    > Alternatively, you can build into PHP if you have static lib. I prefer this > way for non standard libs to make sure web server starts up even > w/o shared libs.

    Okay, do you mean if PHP is compiled as a static module? It's compiled as a DSO on my box, so this is not an option. I have other modules installed statically and dynamically, and I'd rather not recompile Apache every time a new php comes out.

    Thanks much for your help. I may need more. :-) I've tried modifying ld.so.conf on a previous install, and it didn't help.

    Dean.

    attached mail follows:


    ""Yasuo Ohgaki"" <yohgakihotmail.com> wrote in message news:99a7rf$rer$1toye.p.sourceforge.net... > At first find where is libmhash.so.2. Then edit your ld.so.conf. > Then run ldconfig.

    Well, this seems to have worked. I don't know why it didn't work when I tried doing it a few years ago -- and I really have no idea why /usr/lib and /usr/local/lib were not already in ld.so.conf -- is this a RedHat thing? -- 'cause those directories seem to be pretty standard for shared libraries.

    Thanks for the help. Dean.

    attached mail follows:


    ""Dean Hall"" <hallapt7.com> wrote in message news:99a9kk$hnp$1toye.p.sourceforge.net... > > ""Yasuo Ohgaki"" <yohgakihotmail.com> wrote in message > news:99a7rf$rer$1toye.p.sourceforge.net... > > At first find where is libmhash.so.2. Then edit your ld.so.conf. > > Then run ldconfig. > > Well, this seems to have worked. I don't know why it didn't work when I > tried doing it a few years ago

    Oops, "months", not "years". :-)

    Dean.

    attached mail follows:


    > We hired a developer about a year ago to develop a > web based email system for us in php. The developer > is no longer around, so I am having to pick up > the development on the project...When clicking > on the attachment link of an email in Internet > Explorer 5.5 in Windows 98, I get the save as dialog > and when I select ok, it tries to save the html > page. If I right click and do save target as, it > gets the correct file. This all works correctly in > IE 5.0 and Netscape 4.76, and what's weird is that > it even works as expected in IE 5.5 running on Win2k. > Can anyone offer any suggestions? I'll be glad to send > any code snipplets, or info if anyone can clue me in... > > Jack Davis > Network Admin > Bootheel Internet Services

    I built this a few months ago to handle mail merges with a fixed defied attachment and it seems to work for most email readers I have tried. It is supposed to handle text email clients and MIME clients as well as per the RFC's (It was templated from an outgoing email attachment from Microsoft Outlook so it will probably screw something up somewhere).

    The site variable is a class variable from an included file that contains all sorts of default stuff. class SITE { var $mail_from = "webmasterwalters.co.nz"; var $mail_reply_to = "webmasterwalters.co.nz"; } // END SITE CLASS

    The get page function function get_page($page_name="") { $return=""; if (file_exists($page_name))

    $fp = fopen("$page_name","r"); $return .= fread($fp, filesize($page_name)); fclose($fp); } return $return; }

    The logger function is just a thing thats adds a record to a mysql table to record the event for later use by my contact management/list procesing system.

    function mail_it($subject,$mail_message,$mail_to="Grant.Walterswalters.co.nz",$mail_ attachment="",$from="",$reply_to="") { global $site; if ($from) { $mail_from="From:$from"; } else $mail_from="From:".$site->mail_from; } if ($reply_to) { $mail_reply_to="Reply-To:$reply_to"; } else $mail_reply_to="Reply-To:".$site->mail_reply_to; }

    $rand=md5(rand()); $boundary="----=_NextPart_000_$rand"; $boundary2="----=_NextPart_001_$rand"; $mail_headers = "$mail_from\n$mail_reply_to\n"; $mail_headers .= "Content-Type: multipart/mixed;\n boundary=\"$boundary\""; $mail_headers .= "\nX-Priority: 3 (Normal)\nX-Mailer: Walters And Associates WCDS, Build 1.01\nImportance: Normal"; $mail_body = ""; $mail_body .= " This message is in MIME format. The first part should"; $mail_body .= "be readable text,\n while the remaining parts are"; $mail_body .= "likely unreadable without MIME-aware tools.\n Send mail"; $mail_body .= "to webmasterwalters.co.nz for more information.\n"; $mail_body .= "\n"; $mail_body .= "--".$boundary; $mail_body .= "\n"; $mail_body .= "Content-Type: multipart/alternative;\n boundary=\"$boundary2\"\n"; $mail_body .= "\n"; $mail_body .= "\n"; $mail_body .= "--".$boundary2."\n"; $mail_body .= "Content-Type: text/plain;\n charset=\"iso-8859-1\"\n"; $mail_body .= "Content-Transfer-Encoding: 7bit\n"; $mail_body .= "\n"; $mail_body .= strip_tags($mail_message)."\n"; $mail_body .= "\n"; $mail_body .= "\n"; $mail_body .= "--".$boundary2."\n"; $mail_body .= "Content-Type: text/html;\n charset=\"iso-8859-1\"\n"; $mail_body .= "Content-Transfer-Encoding: quoted-printable\n"; $mail_body .= "\n"; $mail_body .= "$mail_message\n"; $mail_body .= "\n"; $mail_body .= "--".$boundary2."--\n"; $mail_body .= "\n";

    if ($mail_attachment<>"") { $content = get_page($mail_attachment); if ($content) { $mail_body .= "--".$boundary."\n"; $mail_body .= "Content-Type: application/octet-stream\n"; $mail_body .= " name=\"".basename($mail_attachment)."\"\n"; $mail_body .= "Content-Transfer-Encoding: base64\n"; $mail_body .= "Content-Description: \"Mail Attachment\"\n"; $mail_body .= "Content-Disposition: attachment;\n"; $mail_body .= " filename=\"".basename($mail_attachment)."\"\n"; $mail_body .= "\n"; $mail_body .= base64_encode($content)."\n\n"; } } $mail_body .= "--".$boundary."--\n";

    if (mail($mail_to,"$subject",$mail_body,$mail_headers)) { logger(1,"Mail Success","$subject To $mail_to",$mail_message); return TRUE; } else { logger(9,"Mail Failure",$mail_to,$mail_body); return FALSE; } }

    Hope this Helps.

    Regards

    Grant Walters Brainbench 'Most Valuable Professional' for Unix Admin Walters & Associates, P O Box 13-043 Johnsonville, Wellington, NEW ZEALAND Telephone: +64 4 4765175, CellPhone 025488265, ICQ# 23511989

    attached mail follows:


    > We hired a developer about a year ago to develop a > web based email system for us in php. The developer > is no longer around, so I am having to pick up > the development on the project...When clicking > on the attachment link of an email in Internet > Explorer 5.5 in Windows 98, I get the save as dialog > and when I select ok, it tries to save the html > page. If I right click and do save target as, it > gets the correct file. This all works correctly in > IE 5.0 and Netscape 4.76, and what's weird is that > it even works as expected in IE 5.5 running on Win2k. > Can anyone offer any suggestions? I'll be glad to send > any code snipplets, or info if anyone can clue me in... > > Jack Davis > Network Admin > Bootheel Internet Services

    I built this a few months ago and it seems to work for most things I have tried. It is supposed to handle text email clients and MIME clients as well.

    The site variable is a class variable that contains all sorts of stuff. var $mail_from = "webmasterwalters.co.nz"; var $mail_reply_to = "webmasterwalters.co.nz";

    function mail_it($subject,$mail_message,$mail_to="Grant.Walterswalters.co.nz",$mail_ attachment="",$from="",$reply_to="") { global $site; if ($from) { $mail_from="From:$from"; } else $mail_from="From:".$site->mail_from; } if ($reply_to) { $mail_reply_to="Reply-To:$reply_to"; } else $mail_reply_to="Reply-To:".$site->mail_reply_to; }

    $rand=md5(rand()); $boundary="----=_NextPart_000_$rand"; $boundary2="----=_NextPart_001_$rand"; $mail_headers = "$mail_from\n$mail_reply_to\n"; $mail_headers .= "Content-Type: multipart/mixed;\n boundary=\"$boundary\""; $mail_headers .= "\nX-Priority: 3 (Normal)\nX-Mailer: Walters And Associates WCDS, Build 1.01\nImportance: Normal"; $mail_body = ""; $mail_body .= " This message is in MIME format. The first part should"; $mail_body .= "be readable text,\n while the remaining parts are"; $mail_body .= "likely unreadable without MIME-aware tools.\n Send mail"; $mail_body .= "to webmasterwalters.co.nz for more information.\n"; $mail_body .= "\n"; $mail_body .= "--".$boundary; $mail_body .= "\n"; $mail_body .= "Content-Type: multipart/alternative;\n boundary=\"$boundary2\"\n"; $mail_body .= "\n"; $mail_body .= "\n"; $mail_body .= "--".$boundary2."\n"; $mail_body .= "Content-Type: text/plain;\n charset=\"iso-8859-1\"\n"; $mail_body .= "Content-Transfer-Encoding: 7bit\n"; $mail_body .= "\n"; $mail_body .= strip_tags($mail_message)."\n"; $mail_body .= "\n"; $mail_body .= "\n"; $mail_body .= "--".$boundary2."\n"; $mail_body .= "Content-Type: text/html;\n charset=\"iso-8859-1\"\n"; $mail_body .= "Content-Transfer-Encoding: quoted-printable\n"; $mail_body .= "\n"; $mail_body .= "$mail_message\n"; $mail_body .= "\n"; $mail_body .= "--".$boundary2."--\n"; $mail_body .= "\n";

    if ($mail_attachment<>"") { $content = get_page($mail_attachment); if ($content) { $mail_body .= "--".$boundary."\n"; $mail_body .= "Content-Type: application/octet-stream\n"; $mail_body .= " name=\"".basename($mail_attachment)."\"\n"; $mail_body .= "Content-Transfer-Encoding: base64\n"; $mail_body .= "Content-Description: \"Mail Attachment\"\n"; $mail_body .= "Content-Disposition: attachment;\n"; $mail_body .= " filename=\"".basename($mail_attachment)."\"\n"; $mail_body .= "\n"; $mail_body .= base64_encode($content)."\n\n"; } } $mail_body .= "--".$boundary."--\n";

    if (mail($mail_to,"$subject",$mail_body,$mail_headers)) { logger(1,"Mail Success","$subject To $mail_to",$mail_message); return TRUE; } else { logger(9,"Mail Failure",$mail_to,$mail_body); return FALSE; } }

    Regards

    Grant Walters Brainbench 'Most Valuable Professional' for Unix Admin Walters & Associates, P O Box 13-043 Johnsonville, Wellington, NEW ZEALAND Telephone: +64 4 4765175, CellPhone 025488265, ICQ# 23511989

    attached mail follows:


    Hi,

    I have built a shopping cart and have made connection to an Internet payment company. Now once transaction is processed they want from my confirmation page to receive an "[OK]". How can I do this with php3/4?

    Response.Write"[OK]" is what ASP uses, I think???

    Thanks

    Ajdin

    attached mail follows:


    You could investigate www.php.net/echo, I think it's what you're after.

    Cheers Jon

    -----Original Message----- From: AJDIN BRANDIC [mailto:abrandiccoventry.ac.uk] Sent: 21 March 2001 12:05 To: php-generallists.php.net Subject: [PHP] Response.Write [OK]

    Hi,

    I have built a shopping cart and have made connection to an Internet payment company. Now once transaction is processed they want from my confirmation page to receive an "[OK]". How can I do this with php3/4?

    Response.Write"[OK]" is what ASP uses, I think???

    Thanks

    Ajdin

    ********************************************************************** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality'

    **********************************************************************

    attached mail follows:


    You think I need to do something like

    echo'Response.Write[OK]';

    This will print Response.Write [OK] on he screen or????

    Ajdin

    On Wed, 21 Mar 2001, Jon Haworth wrote:

    > You could investigate www.php.net/echo, I think it's what you're after. > > Cheers > Jon > > > -----Original Message----- > From: AJDIN BRANDIC [mailto:abrandiccoventry.ac.uk] > Sent: 21 March 2001 12:05 > To: php-generallists.php.net > Subject: [PHP] Response.Write [OK] > > > Hi, > > I have built a shopping cart and have made connection to an Internet > payment company. Now once transaction is processed they want from my > confirmation page to receive an "[OK]". How can I do this with php3/4? > > Response.Write"[OK]" is what ASP uses, I think??? > > > Thanks > > Ajdin > > > ********************************************************************** > 'The information included in this Email is of a confidential nature and is > intended only for the addressee. If you are not the intended addressee, > any disclosure, copying or distribution by you is prohibited and may be > unlawful. Disclosure to any party other than the addressee, whether > inadvertent or otherwise is not intended to waive privilege or confidentiality' > > ********************************************************************** > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net > >

    attached mail follows:


    no.

    Imagine Response.write as echo.

    so it will be

    echo "OK";

    PHP doesn't parse ASP tags

    ----- Original Message ----- From: "AJDIN BRANDIC" <abrandiccoventry.ac.uk> To: "Jon Haworth" <JHaworthwitanjardine.co.uk> Cc: <php-generallists.php.net> Sent: Wednesday, March 21, 2001 8:24 PM Subject: RE: [PHP] Response.Write [OK]

    > You think I need to do something like > > echo'Response.Write[OK]'; > > This will print Response.Write [OK] on he screen or???? > > Ajdin > > > On Wed, 21 Mar 2001, Jon Haworth wrote: > > > You could investigate www.php.net/echo, I think it's what you're after. > > > > Cheers > > Jon > > > > > > -----Original Message----- > > From: AJDIN BRANDIC [mailto:abrandiccoventry.ac.uk] > > Sent: 21 March 2001 12:05 > > To: php-generallists.php.net > > Subject: [PHP] Response.Write [OK] > > > > > > Hi, > > > > I have built a shopping cart and have made connection to an Internet > > payment company. Now once transaction is processed they want from my > > confirmation page to receive an "[OK]". How can I do this with php3/4? > > > > Response.Write"[OK]" is what ASP uses, I think??? > > > > > > Thanks > > > > Ajdin > > > > > > ********************************************************************** > > 'The information included in this Email is of a confidential nature and is > > intended only for the addressee. If you are not the intended addressee, > > any disclosure, copying or distribution by you is prohibited and may be > > unlawful. Disclosure to any party other than the addressee, whether > > inadvertent or otherwise is not intended to waive privilege or confidentiality' > > > > ********************************************************************** > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > > For additional commands, e-mail: php-general-helplists.php.net > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net >

    attached mail follows:


    > > I have built a shopping cart and have made connection to an Internet > payment company. Now once transaction is processed they want from my > confirmation page to receive an "[OK]". How can I do this with php3/4? > > Response.Write"[OK]" is what ASP uses, I think???

    try

    echo "<script>alert('OK')</script>";

    I think this is the same thing

    M

    attached mail follows:


    OK

    I have done this.

    Thanks guys

    Ajdin

    On Wed, 21 Mar 2001 techzeuspacific.net.sg wrote:

    > no. > > Imagine Response.write as echo. > > so it will be > > echo "OK"; > > PHP doesn't parse ASP tags > > ----- Original Message ----- > From: "AJDIN BRANDIC" <abrandiccoventry.ac.uk> > To: "Jon Haworth" <JHaworthwitanjardine.co.uk> > Cc: <php-generallists.php.net> > Sent: Wednesday, March 21, 2001 8:24 PM > Subject: RE: [PHP] Response.Write [OK] > > > > You think I need to do something like > > > > echo'Response.Write[OK]'; > > > > This will print Response.Write [OK] on he screen or???? > > > > Ajdin > > > > > > On Wed, 21 Mar 2001, Jon Haworth wrote: > > > > > You could investigate www.php.net/echo, I think it's what you're after. > > > > > > Cheers > > > Jon > > > > > > > > > -----Original Message----- > > > From: AJDIN BRANDIC [mailto:abrandiccoventry.ac.uk] > > > Sent: 21 March 2001 12:05 > > > To: php-generallists.php.net > > > Subject: [PHP] Response.Write [OK] > > > > > > > > > Hi, > > > > > > I have built a shopping cart and have made connection to an Internet > > > payment company. Now once transaction is processed they want from my > > > confirmation page to receive an "[OK]". How can I do this with php3/4? > > > > > > Response.Write"[OK]" is what ASP uses, I think??? > > > > > > > > > Thanks > > > > > > Ajdin > > > > > > > > > ********************************************************************** > > > 'The information included in this Email is of a confidential nature and > is > > > intended only for the addressee. If you are not the intended addressee, > > > any disclosure, copying or distribution by you is prohibited and may be > > > unlawful. Disclosure to any party other than the addressee, whether > > > inadvertent or otherwise is not intended to waive privilege or > confidentiality' > > > > > > ********************************************************************** > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > > > For additional commands, e-mail: php-general-helplists.php.net > > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > > For additional commands, e-mail: php-general-helplists.php.net > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net > >

    attached mail follows:


    Hi there, I need some help here.

    I have uploaded all the files necessary into my server. grab it at www.frozened.com/zeus/lostpassword.zip

    This is a lostpassword script whereby when the user inputs his email address, the script will check if his email is a valid email ( testtest.com ) after which it will use the database to search for the email and if there his email is in the db, it will send him a mail telling him so.

    In this script I haven't add the mail() but replaced it with a echo() so that I know that the form has been processed.

    When I run the script and input a 'non-valid' email address ( no sign ), the errormsg will appear as normal but when I type a valid email or a email that is in the database, the form will just clear it self and reappear.

    Mind if someone help me debug (I'm new to PHP).

    Thanks :)

    ------------------------ Zeus ------------------------

    attached mail follows:


    Hi,

    I am going to use sessions to authenticate and protect my pages, this is what I have so far...

    User logs in via form, this is checked via a SQL call, if the correct username and password are entered I run the following:

    session_start(); session_register("UserName","Password"); header ("Location: http://www.domain.com/members/index.php");

    The bit where I get lost is 1) how to authenticate this on each page and 2) How to close the session after the browser has closed. I have tried many tutorials etc but none seem to go into great detail in those areas. Anyone know of any decent tutorials or any snippets I can learn from.

    Thanks

    attached mail follows:


    KPortsmoutaol.com [KPortsmoutaol.com] wrote: > Hi, > > I am going to use sessions to authenticate and protect my pages, this is what > I have so far... > > User logs in via form, this is checked via a SQL call, if the correct > username and password are entered I run the following: > > session_start(); > session_register("UserName","Password");

    You have to register each "field" like this:

    session_register("UserName"); // register UserName as a session var $UserName = $new_value_for_username; // give UserName session var a new value. session_register("Password"); // register Password as a session var $Password = $new_value_of_password; // give Password session var a new value.

    Then in the next script, after you do session_start();, you will have access to those previously registered session variables by just using $UserName and $Password.

    HTH.

    -- 
    Hardy Merrill
    Mission Critical Linux, Inc.
    http://www.missioncriticallinux.com
    

    > header ("Location: http://www.domain.com/members/index.php"); > > The bit where I get lost is 1) how to authenticate this on each page and 2) > How to close the session after the browser has closed. I have tried many > tutorials etc but none seem to go into great detail in those areas. Anyone > know of any decent tutorials or any snippets I can learn from. > > Thanks > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net

    attached mail follows:


    Apologies for the long post.

    I use this approach: (simplified) at the top of every page, before any HTML. Pop it into an include right at the top. I have not included all the util function e.g. LogQuietAlert()

    regards Jeff

    <?php #=========================================================================== ==== # Initialise session array session_start(); if (!isset($sesh)) { session_register('sesh'); $sesh = array(); }

    # If they are not logged in - send them to the /login page if ( !$sesh[_loggedin] and !isUtilityPage()) { $sesh[_target] = TopPage($PHP_SELF); # Remember where they were going gotoPage("/login"); }

    # This is updated by the login function if a login fails # Print it on your page somewhere to let the user know # that their login failed $message = '';

    # I leave the action on my FORMs empty, so the user # will return to the same page when they press SUBMIT # $act is the name of the submit button/link etc if ( $act == 'login' ) { if ( !$UserName || !$Password ) { $message = "Missing Username or Password [From: $REMOTE_ADDR]"; } elseif ( login( $UserName, $Password ) ) { srand((double) microtime() * 1000000); $randval = rand(); setcookie( 'cookUserName', $UserName, time()+(180*86400),'','', 1); # Note that this is a session cookie, not persistant setcookie( 'cookSPID', $randval, 0, '','', 1); $sesh[_cookSPID] = $randval; $sesh[_sslSESH] = $SSL_SESSION_ID; gotoPage($sesh[_target]); } else { $message = "Invalid Username/Password [From: $REMOTE_ADDR]"; } }

    if (!isUtilityPage()) { # Check that the user is not attempting to spoof the session if ( $sesh[_cookSPID] != $cookSPID) { LogQuietAlert("$PHP_SELF $sesh[_email] at $sesh[_client_id] " . "has a cookSPID mismatch: Attempt to spoof session?<BR>"); gotoPage("/login"); } }

    #=========================================================================== ==== function login( $UserName, $Password ) { # Checks username/password global $sesh, $message, $REMOTE_ADDR;

    $sesh[_user] = $UserName; $sesh[_loggedin] = 0; $sesh[_user_id] = ''; $sesh[_role] = ''; $sesh[_name] = ''; $sesh[_client_id] = '';

    if ( !$UserName or !$Password ) { return 0; }

    $UserName = strtolower( $UserName ); $sth = runSQL('get_user_login',array( where => "user='$UserName' and password=PASSWORD('MySalt$Password')" ));

    $rows = mysql_num_rows( $sth ); if (!$rows) { # Invalid UserName/Password - log a quiet alert LogAlert("Login failure: $UserName from $REMOTE_ADDR tried '$Password'<BR>"); $message = "Invalid username/password [from $REMOTE_ADDR]"; return 0; } $rec = mysql_fetch_array( $sth, MYSQL_ASSOC );

    $sesh[_loggedin] = 1; $sesh[_user_id] = $rec[user_id]; $sesh[_email] = $rec[email]; $sesh[_role] = $rec[role]; $sesh[_name] = $rec[name]; $sesh[_client_id] = $rec[client_id];

    return 1; }

    #=========================================================================== ==== function gotoPage( $page = "/index" ) { header("Location: $page"); exit; # Old browsers get no further! } #=========================================================================== ==== function isUtilityPage() { global $PHP_SELF; # returns true if this is a utility page # ie index, login, unavailable or error if ( stristr($PHP_SELF, 'login')) return 1; if ( stristr($PHP_SELF, 'index')) return 1; if ( stristr($PHP_SELF, 'unavail')) return 1; if ( stristr($PHP_SELF, 'error')) return 1; if ( stristr($PHP_SELF, 'disclaimer')) return 1; return 0; } #=========================================================================== ==== ?>

    attached mail follows:


    I want to restrict the height and width of a file a user will upload to the how do I do this, is there a function for this.

    TIA

    --
    george
    chiefmonkeymy_pantswisemonkeydesign.co.uk
    remove my_pants to reply
    

    Ptty's excellent DW tutorial site http://www.thepattysite.com/dreamweaver/ Jhinuk Chowdhury 's DW FAQ http://people.unt.edu/~jhinuk/DW_FAQ.htm

    attached mail follows:


    Try using array variable names in HTML:

    $rs is a statement from a select sql. This code snippet puts the values of the columns returned in an array $field.

    if (OCIFetch($rs)) { for ($i = 0; $i <= $NFields; $i++) { $field[$i] = OCIResult($rs, $i+1); } }

    Somewhere further on the following code gets executed: echo "<table>"; for ($i = 0; $i <= $NFields; $i++) { echo "<tr><td>"; echo "<INPUT TYPE='text' NAME='f[".$i."]' SIZE='".$FieldLen[$i]."' MAXLENGTH='".$FieldLen[$i]."' value='".$field[$i]."'>"; echo "</tr></td>"; }

    You could use a <INPUT TYPE="hidden"> in the above code as well, just to pass the values. When the form is posted the values in f gets sent back as an array. This code comes comes from a script I wrote that updates a database like you want to do.

    Rudolf Visagie rudolfqedi.co.za

    -----Original Message----- From: Mick Lloyd [mailto:mjlconsultingrooms.com] Sent: 21 March 2001 10:20 To: Mark Collin Cc: Database Help PHP Subject: Re: [PHP-DB] Transmitting Arrays

    Mark

    I've had similar problems in the past. It's my understanding that you can't pass arrays between scripts, except when using sessions. They seem to transfer in, for example:

    include("script.php"); require("script.php");

    but not in:

    <a href='script.php?var=$var'>Pass</a>

    but I would love to be corrected on this by a PHP expert!

    Regards

    Mick Lloyd mjlconsultingrooms.com Tel: +44 (0)1684 560224 ----- Original Message ----- From: Mark Collin <fyresprayukgamer.net> To: <php-dblists.php.net> Sent: Tuesday, March 20, 2001 9:44 PM Subject: [PHP-DB] Transmitting Arrays

    > I have a form which dynamically builds a table by taking data out of a mysql > database > > http://www.fyrespray.net/screenshots/admin/modifyscreenshot.php4?pageid=1 > > but i'm having problems whn i try to modify the data i'm trying to put all > the data into arrays serialize it, urlencode it then send it on to the next > page to put it into database and then send back to the original page when > its done, i'm having a problem actually sendig my arrays around though, the > second page doesn't seem to get any data after i have unserialized it and > urlunecoded it. > > anyone have any ideas, i've been fiddleing about a load with the code and > there is a good chance i have totally messed it up now heres the state its > in atm though if you would like to look > > http://www.fyrespray.net/screenshots/admin/modifyscreenshot.txt > http://www.fyrespray.net/screenshots/admin/modify.txt > > (prolly need to save the first page if your browser is picking up the html > bits and making half of a web page up like mine does) > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribelists.php.net > For additional commands, e-mail: php-db-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net >

    attached mail follows:


    Why you are using IP address? (No DNS MX record for the host??) Anyway, SMTP server can work w/ IP address, but many programs tries to look up DNS MX records for SMTP server. I guess PHP trying to get MX records for the IP. I didn't look into code, I can easily be wrong. (SMTP server should have MX record(s), if it is configured properly.)

    Try to use name (i.e. mail.example.com) instead.

    Regards,

    --
    Yasuo Ohgaki
    

    "Todd Cary" <toddaristesoftware.com> wrote in message news:3AB7B2E0.8A2BC3D1aristesoftware.com... > I am getting a "Failed to connect" error when I try to send an email. > In the php.ini, I have the IP of the ISP's mail server e.g. > > SMTP = 209.204.199.1 > > This IP works for other programs I use and for test programs I have > created with Delphi. > > Any suggestions?? > > Many thanks.......... > > Todd > > -- > Todd Cary > Ariste Software > toddaristesoftware.com > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net >

    attached mail follows:


    I have an Oracle client on a webserver talking to an Oracle server through Oracle networking and the PHP OCI8 interface. When an error occurs on the server, the 'message' that OCIError receives on the client is

    Error while trying to retrieve text for error ORA-03113

    This seems to happen with the Oracle "Programmers" client install. There was only one client install that had more stuff than "Programmer" and I think that was "Administrator".

    Why am I not getting proper Oracle error 'message's on the client when the Oracle server has an error? Is this normal, or did I do something wrong?

    TIA.

    -- 
    Hardy Merrill
    Mission Critical Linux, Inc.
    http://www.missioncriticallinux.com
    

    attached mail follows:


    I've recently installed PHP4.0.4 and PHP4.0.5-RC1 for IIS5 (CGI and ISAPI) CGI version works ok so far. However, ISAPI version is very unstable. I haven't use it much, but it is not ready for production use for sure.

    --
    Yasuo Ohgaki
    

    ""Carsten Gehling"" <carstensarum.dk> wrote in message news:01a001c0b151$bd309940$6400a8c0sarum.local... > What is the status on the ISAPI version of PHP? > > Last I looked (4.0.1) it was still rather unstable. > > - Carsten >

    attached mail follows:


    I am looking for help with session handling. I have modified Joe Jarosciak`s password script slightly, so that instead of logging in to d/l files, you login to one or two secure area`s. (depending on the access level of password used)

    How and where can i modify this more, so that a session will be created, and the logged-in users data will be passed over to the two secure area`s??

    e.g. pass the login information to the two secure area pages, so they can evaluate if the user is allowed to view them or not!

    Heres the sript so far:

    <------------------- index.php------------------->

    <html> <head> </head> <body bgcolor="#FFFFFF"> <table border="1" width="100%" bgcolor="#000000" bordercolor="#000000" cellspacing="0"> <tr> <td width="100%"> <p align="center"><b><font size="4" color="#FFFFFF">Authorized Access Only</font></b></td> <form method="POST" action="secure.php"> <center> </tr> </table> <address align="center">&nbsp;</address> <address align="center">&nbsp;</address> <address align="center"><b>Name:</b></address> <address align="center">&nbsp;<input type="text" name="PHP_AUTH_USER" size="20" value=""></address> <address align="center">&nbsp;</address> <address align="center"><b>Password:</b></address> <address align="center"><input type="password" name="PHP_AUTH_PW" size="20" value=""></address> <p align="center"><input type="submit" value="Login" name="B1"> <input type="reset" value="Reset"> </p> </form> </body> </html>

    <--------------------end index.php------------------->

    <---------------------secure.php--------------------->

    <?php

    $auth = false;

    if (isset( $PHP_AUTH_USER ) && isset($PHP_AUTH_PW)) {

    $filename = ("D:\Inetpub\wwwroot\password\vault\passwords.txt"); $fp = fopen( $filename, 'r' ); $file_contents = fread( $fp, filesize( $filename ) ); fclose( $fp );

    $lines = explode ( "\n", $file_contents );

    foreach ( $lines as $line ) {

    list($username,$password,$tc,$fc) = explode(':', $line ); // echo '<br>'; // echo $username; // echo ' : '; // echo $password; // echo '<br>';

    if (( $username == "$PHP_AUTH_USER" ) && ( $password == "$PHP_AUTH_PW" )) { $auth = true; break; } } }

    // ==================Header + IP Checking====================== $updated_from=getenv("REMOTE_ADDR"); print (' <div align="center"> <center><table border="1" cellpadding="0" cellspacing="0" width="667" bgcolor="#000000" bordercolor="#000000"><tr> <td width="100%"> <p align="center"><font color="#FFFFFF" size="0"> Connected from (IP): ');

    print '<font color="#FFFF00">'; print $updated_from;

    print '</font></font><font color="#FFFF00" size="0">&nbsp;</font><font color="#FFFFFF"><font size="0">&nbsp;| <font size="1"> Your username - </font>'; print '<font color="#FFFF00">'; print $PHP_AUTH_USER; print '</font></font></font><font color="#0000FF" size="0">&nbsp;</font><font color="#FFFF00" size="0"> </font></p></td></tr></table></center><br></div>'; // ==================end - Header + IP Checking======================

    // ==================on support or not======================= if (! $auth) { echo '<br> You used username: '; echo $PHP_AUTH_USER; echo '<br> You used password: '; echo $PHP_AUTH_PW; echo '<br>'; echo '<br><center>'; echo '<br>'; echo '<p><font color="#000000"><b>Sorry, but this is wrong. Authorization with right username and password is Required!</b></font></p>'; exit; }

    if (($auth) and ($tc == '1')) { print '<b><font color="#000000" size="1">- You are authorized for access area 1.</font></b><br>' ; }

    if (($auth) and ($fc == '1')) { print '<b><font color="#000000" size="1">- You are authorized for access area 2.</font></b><br>' ; }

    if (($auth) and ($tc == '0')) { print '<b><font color="#FF0000" size="1">- You are not authorized for access area 1.</font></b><br>' ; }

    if (($auth) and ($fc == '0')) { print '<b><font color="#FF0000" size="1">- You are not authorized for access area 2.</font></b><br>' ; } // ==================end -- on support or not=======================

    // ==================buttons=======================

    if (($auth) and ($tc == '1')) { print '<a href="access_area1.htm"><font face="Arial, Helvetica, sans-serif"><b><font size="4" color="#FFFFFF">Area 1</font></b></font> </a><br>'; }

    if (($auth) and ($fc == '1')) { print '<a href="access_area2.htm"><font face="Arial, Helvetica, sans-serif"><b><font size="4" color="#FFFFFF">Area 2</font></b></font> </a>'; } // ==================end buttons=======================

    if ($auth) { echo '<b><center><font size="1">Thank you. You were authorized with right username and password!</font></b>'; }

    ?>

    <-------------------end secure.php--------------------->

    <-----------------access_area1.htm--------------------->

    <html> <head> <title>Access Area 1</title> </head>

    <body bgcolor="#FF6600" text="#000000"> <div align="center"> <table width="40%" border="1" cellspacing="0" cellpadding="0" bgcolor="#FF0000" bordercolor="#000000"> <tr> <td> <div align="center"><b><font face="Arial, Helvetica, sans-serif" size="6">Secure Area 1</font></b></div> </td> </tr> </table> </div> </body> </html>

    <----------------end access_area1.htm------------------>

    <html> <head> <title>Access Area 2</title> </head>

    <body bgcolor="#FF0000" text="#000000"> <div align="center"> <table width="40%" border="1" cellspacing="0" cellpadding="0" bgcolor="#FF6600" bordercolor="#000000"> <tr> <td> <div align="center"><b><font face="Arial, Helvetica, sans-serif" size="6">Secure Area 2</font></b></div> </td> </tr> </table> </div> </body> </html>

    <----------------end access_area2.htm------------------>

    <----------------passwords.txt------------------------->

    joe:19741:1:0: tony:928gt:1:1: murray:fsSS92:1:1: greg:2NNg8ed:1:1: mitch:dopro:0:0: nick:cmuk:1:0: guest:RxegXHNEV9GpM:1:1: tom:JJft54Dcv:0:1:

    <----------------end of passwords.txt------------------>

    Thankyou very much for any help!

    webmasterinsightdesign.co.uk

    attached mail follows:


    PHP >start here Internet resources and book reviews for those just starting out with PHP and MySQL http://www.webdesigns1.com/php/ Jeff Oien

    attached mail follows:


    I just spotted this, so apologies if it's already been answered.

    PHP will try to treat first in $arr[first] as a constant. if it doesn't find a constant with this name it will treat it as a string. There may be an error reporting level which throws this up as an error. $arr['first'] is therefore lees ambiguous and so safer (and may even be a nano second faster).

    Tim Ward Senior Systems Engineer

    Please refer to the following disclaimer in respect of this message: http://www.stivesdirect.com/e-mail-disclaimer.html

    > -----Original Message----- > From: Yasuo Ohgaki [mailto:yohgakihotmial.com] > Sent: 20 March 2001 08:17 > To: php-generallists.php.net > Subject: [Q] Parser behavior in a string > > > I noticed that PHP4 accepts and does not raise error (notice > messages) for > following code. > > $arr = array('first' => 'one'); > $str = "This is first element of array: $arr[first]"; > > Question: Is this expected behavior that PHP parse w/o errors? > > If this is not a expected behavior and subject to change, I'm > not going to use > array w/o ' or " for assoc arrays. Because I log all error > messages for > production system including notice messages. > > Thank you. > > [Note for those who are not familiar with use of {} in PHP] > {} can be used to resolve ambiguity not only for arrays, but > also for variables > in strings. > > $str = "This is first element of array: {$arr['first']}"; // > works as it should. > $str = "This is first element of array: $arr['first']"; // > parse error. > > You can use {} for multi-dimensional array and nested objects > properties in > strings also. > i.e. "Text {$obj->foo->var} Text" works like 'Text '. > $obj->foo->var .' Text'. > > -- > Yasuo Ohgaki > > > >

    attached mail follows:


    I just spotted this, so apologies if it's already been answered.

    PHP will try to treat first in $arr[first] as a constant. if it doesn't find a constant with this name it will treat it as a string. There may be an error reporting level which throws this up as an error. $arr['first'] is therefore lees ambiguous and so safer (and may even be a nano second faster).

    Tim Ward Senior Systems Engineer

    Please refer to the following disclaimer in respect of this message: http://www.stivesdirect.com/e-mail-disclaimer.html

    > -----Original Message----- > From: Yasuo Ohgaki [mailto:yohgakihotmial.com] > Sent: 20 March 2001 08:17 > To: php-generallists.php.net > Subject: [Q] Parser behavior in a string > > > I noticed that PHP4 accepts and does not raise error (notice > messages) for > following code. > > $arr = array('first' => 'one'); > $str = "This is first element of array: $arr[first]"; > > Question: Is this expected behavior that PHP parse w/o errors? > > If this is not a expected behavior and subject to change, I'm > not going to use > array w/o ' or " for assoc arrays. Because I log all error > messages for > production system including notice messages. > > Thank you. > > [Note for those who are not familiar with use of {} in PHP] > {} can be used to resolve ambiguity not only for arrays, but > also for variables > in strings. > > $str = "This is first element of array: {$arr['first']}"; // > works as it should. > $str = "This is first element of array: $arr['first']"; // > parse error. > > You can use {} for multi-dimensional array and nested objects > properties in > strings also. > i.e. "Text {$obj->foo->var} Text" works like 'Text '. > $obj->foo->var .' Text'. > > -- > Yasuo Ohgaki > > > >

    attached mail follows:


    Hi,

    Habe folgendes Problem:

    Suse 7.1 Standardmässig ist Apache mit PHP installiert. Das läuft auch alles solange ich nicht versuche eine DB anzubinden bzw. abzufragen.

    Ich bekomme dann immer folgende Meldung:

    Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /usr/local/httpd/htdocs/dbopen.php3 on line 5

    Leider konnte ich in den Archiven und Manuals nichts finden. Und der Verweis in meiner php3.ini im verzeichnis /etc/httpd/ zu mysql.sock ist auch richtig gesetzt.

    Kann mir da jemand weiterhelfen?

    Besten Dank im voraus. Denis

    attached mail follows:


    Hi Remco,

    That's not the Problem. But I don't have the mysql.sock in this directory.

    Regards Denis

    On Wednesday 21 March 2001 16:36, you wrote: > denis mettler <taipannetcologne.de> writes: > > Hi, > > > > Habe folgendes Problem: > > <snip> > > > Warning: Can't connect to local MySQL server through socket > > '/var/lib/mysql/mysql.sock' (13) in /usr/local/httpd/htdocs/dbopen.php3 > > on line 5 > > As root, do a chmod +x /var/lib/mysql/ > > That might do the trick, as the mysql directory is not always readable > for the 'nobody' user where your HTTPd runs under. > > regards, > Remco

    attached mail follows:


    denis mettler wrote:

    > But I don't have the mysql.sock in this directory.

    Is mysqld running at all?

    +----------------------------------------+ | Julie Meloni (juliethickbook.com) | | | | "PHP Essentials" and "PHP Fast & Easy" | | http://www.thickbook.com | +----------------------------------------+