RE: [PHP] MySQL Date
Shaun,
It should be: date("Y-m-d"). MySQL stores the dates as "-mm-dd", and that function
returns the current date on the format you need.
Check the date() function on the php manual.
--
Un gran saludo/Big regards...
Arturo Barajas, IT/Systems PPG MX (SJDR)
(427) 271-9918, x448
> -Original Message-
> From: shaun [mailto:[EMAIL PROTECTED]
> Sent: Miercoles, 19 de Marzo de 2003 07:19 a.m.
> To: [EMAIL PROTECTED]
> Subject: [PHP] MySQL Date
>
>
> Hi,
>
> I have a date stored in a table in my MySQL Database using a
> DATE type for
> the column.
>
> How can i compare the date in the table to today
>
> e.g.
>
> $today = mysql_result($result, $i, Booking_Date);
>
> if($today = *HELP*){
> echo "you are booked today";
> }else{
> echo "you are free today";
> }
>
> thanks for your help
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] A faster way to Redirect pages
Just clarifying a little.
The header() function doesn't necessarily go at the top. You can make whatever
operations you need, but as long as nothing is echoed to the browser, there's no
problem.
I mean:
--
Un gran saludo/Big regards...
Arturo Barajas, IT/Systems PPG MX (SJDR)
(427) 271-9918, x448
> -Original Message-
> From: Oscar F [mailto:[EMAIL PROTECTED]
> Sent: Lunes, 17 de Marzo de 2003 11:34 a.m.
> To: Poon, Kelvin (Infomart)
> Cc: '[EMAIL PROTECTED]'
> Subject: Re: [PHP] A faster way to Redirect pages
>
>
> Kelvin,
>
> You can use
> header("Location:login.php");
> exit;
> ?>
>
> If you want to do it with PHP. You have to put it at the top of the
> file, since no other information can be sent before the
> Location header.
>
> HTH,
> -Oscar F.
>
> Poon, Kelvin (Infomart) wrote:
>
> >Hi,
> >
> >I know this topic was discussed but I deleted my previous
> mail so I can't go
> >back and review them. My question is, is there a faster way
> to redirect
> >html pages other than just using CONTENT="1;
> >URL=login.php"> ? Is there any way we can do that in php so that it
> >redirect "FASTER"? Right now I set the redirect time to be
> 1 sec, but for
> >some reason it still takes kind of long until it actually
> redirects, I was
> >wondering if there is any other way I can do this faster.
> >
> >
> >THanks a lot everyone,
> >
> >Kelvin
> >
> >
> >
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] SQL DISTINCT with MYSQL
Vernon, Don't know if I get it right, but: SELECT DISTINCT uname, file FROM useronline should do that. I mean, if you have something like: uname file a f1 a f2 a f1 a f2 b f1 b f2 b f1 the query should deliver: uname file a f1 a f2 b f1 b f2 Is that what you're looking for? -- Un gran saludo/Big regards... Arturo Barajas, IT/Systems PPG MX (SJDR) (427) 271-9918, x448 > -Original Message- > From: Vernon [mailto:[EMAIL PROTECTED] > Sent: Jueves, 13 de Marzo de 2003 06:24 p.m. > To: [EMAIL PROTECTED] > Subject: [PHP] SQL DISTINCT with MYSQL > > > I'm setting up a user online system using MySQL where I have > 4 fields, all > of which is working fine. > > I need the information from all the fields but want only > distinct values > based on the uname column. If I use the: > > SELECT DISTINCT uname > FROM useronline > > of course I come back with the values I desire, but only the > user names. > > As I am also tracking the page they are on I need other > columns in the table > as well. So the question is, using an SQL statement, how do I > return only > distinct useronline.uname values from the database as well as the > useronline.file column? > > Thanks > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] foro php
Daniel, Look for phpBB, I think it's one of the best, IMHO. -- Un gran saludo/Big regards... Arturo Barajas, IT/Systems PPG MX (SJDR) (427) 271-9918, x448 > -Original Message- > From: David E.S.V. [mailto:[EMAIL PROTECTED] > Sent: Miercoles, 12 de Marzo de 2003 10:11 a.m. > To: fLIPIS > Cc: [EMAIL PROTECTED] > Subject: [PHP] foro php > > > > hello folks > > do you know any site where I can download a free php foro to install? > > thanks > > David. > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] response.redirect
With header():
header("Location: " . $redirect_to);
--
Un gran saludo/Big regards...
Arturo Barajas, IT/Systems PPG MX (SJDR)
(427) 271-9918, x448
> -Original Message-
> From: Christopher Myatt [mailto:[EMAIL PROTECTED]
> Sent: Viernes, 07 de Marzo de 2003 05:50 p.m.
> To: [EMAIL PROTECTED]
> Subject: [PHP] response.redirect
>
>
> is there any way to do a *response.redirect* call like in asp
> from a php
> script?
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] MySQL Alias and PHP
There are two ways, Either have a "null" record on the area names, with a 0 as ID, or use a LEFT JOIN. The LEFT JOIN clause permits you to have a linked table, and if it doesn't find a match, it returns a NULL. SELECT tbl_1.area_1, areas1.area_name, tbl_1.area_2, areas2.area_name FROM tbl_1 LEFT JOIN tbl_2 areas1 ON tbl_1.area_1 = areas1.id LEFT JOIN tbl_2 areas2 ON tbl_1.area_2 = areas2.id HTH -- Un gran saludo/Big regards... Arturo Barajas, IT/Systems PPG MX (SJDR) (427) 271-9918, x448 > -Original Message- > From: Charles Kline [mailto:[EMAIL PROTECTED] > Sent: Viernes, 07 de Marzo de 2003 05:48 p.m. > To: Barajas, Arturo > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP] MySQL Alias and PHP > > > Wow. That is ALMOST it. The only thing is it does not return > the record > with a 0 in tbl_1.area_2 - can you think of a workaround? > > Thanks for the help, > Charles > > On Friday, March 7, 2003, at 06:39 PM, Barajas, Arturo wrote: > > > Let's see: > > > > SELECT > > tbl_1.area_1, > > areas1.area_name, > > tbl_1.area_2, > > areas2.area_name > > FROM > > tbl_1 > > INNER JOIN tbl_2 areas1 ON tbl_1.area_1 = areas1.id > > INNER JOIN tbl_2 areas2 ON tbl_1.area_2 = areas2.id > > > > Maybe if you tinker a little on the sentence. I don't have > a place to > > test it right now. > > -- > > Un gran saludo/Big regards... > >Arturo Barajas, IT/Systems PPG MX (SJDR) > >(427) 271-9918, x448 > > > >> -Original Message- > >> From: Charles Kline [mailto:[EMAIL PROTECTED] > >> Sent: Viernes, 07 de Marzo de 2003 04:09 p.m. > >> To: Jim Lucas > >> Cc: [EMAIL PROTECTED] > >> Subject: Re: [PHP] MySQL Alias and PHP > >> > >> > >> Thanks for all the suggestions, I have tried all and more and still > >> can't get this quite right. If there is a better forum for these > >> question, please point me to it and I will take this somewhat > >> off topic > >> thread elsewhere. > >> > >> My table structure is like so: > >> > >> tbl_1 > >> > >> idarea_1area_2 > >> 1 2 3 > >> 2 1 2 > >> 3 5 0 > >> > >> > >> tbl_2 > >> > >> id area_name > >> 1 funding > >> 2 research > >> 3 new > >> 4 ongoing > >> 5 other > >> > >> > >> So, I need to display all the records in tbl_1 and show the > >> values for > >> the fields area_1 and area_2 as their area_name field from tbl_2. I > >> must display each record from tbl_1 only once. I know I am > >> close, but I > >> just can't get this to work. The closest I have gotten is this: > >> > >> SELECT DISTINCT a.area_name area_a, b.area_name area_b > FROM tbl_1 x, > >> tbl_2 a, tbl_2 b > >> WHERE x.area_1 = a.id > >> OR x.area_2 = b.id GROUP BY x.id > >> > >> But this ALWAYS returns the area_name (funding) in the value > >> of area_b > >> (have no idea why) > >> > >> Thanks for any help. It is appreciated. > >> > >> - Charles > >> > >> > >> On Friday, March 7, 2003, at 01:42 PM, Jim Lucas wrote: > >> > >>> Then the information in the DB is the same. > >>> > >>> Jim > >>> - Original Message - > >>> From: "Charles Kline" <[EMAIL PROTECTED]> > >>> To: "Rich Gray" <[EMAIL PROTECTED]> > >>> Cc: <[EMAIL PROTECTED]> > >>> Sent: Friday, March 07, 2003 10:03 AM > >>> Subject: Re: [PHP] MySQL Alias and PHP > >>> > >>> > >>> Thanks for the help. Almost there. Here is what I have: > >>> > >>> SELECT x.id, x.headline, x.description, a.area area_a, > b.area area_b > >>> FROM tbl_funding x, tbl_dra a, tbl_dra b > >>> GROUP BY x.id LIMIT 0 , 30 > >>> > >>> The problem is that $array[area_a] and $array[area_b] > >> display the same > >>> info. > >>> > >>> > >>> > >>> > >>> > >>> On Friday, March 7, 2003, at 11:09 AM, Rich Gray wrote: > >>>
RE: [PHP] MySQL Alias and PHP
Let's see: SELECT tbl_1.area_1, areas1.area_name, tbl_1.area_2, areas2.area_name FROM tbl_1 INNER JOIN tbl_2 areas1 ON tbl_1.area_1 = areas1.id INNER JOIN tbl_2 areas2 ON tbl_1.area_2 = areas2.id Maybe if you tinker a little on the sentence. I don't have a place to test it right now. -- Un gran saludo/Big regards... Arturo Barajas, IT/Systems PPG MX (SJDR) (427) 271-9918, x448 > -Original Message- > From: Charles Kline [mailto:[EMAIL PROTECTED] > Sent: Viernes, 07 de Marzo de 2003 04:09 p.m. > To: Jim Lucas > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP] MySQL Alias and PHP > > > Thanks for all the suggestions, I have tried all and more and still > can't get this quite right. If there is a better forum for these > question, please point me to it and I will take this somewhat > off topic > thread elsewhere. > > My table structure is like so: > > tbl_1 > > idarea_1area_2 > 1 2 3 > 2 1 2 > 3 5 0 > > > tbl_2 > > id area_name > 1 funding > 2 research > 3 new > 4 ongoing > 5 other > > > So, I need to display all the records in tbl_1 and show the > values for > the fields area_1 and area_2 as their area_name field from tbl_2. I > must display each record from tbl_1 only once. I know I am > close, but I > just can't get this to work. The closest I have gotten is this: > > SELECT DISTINCT a.area_name area_a, b.area_name area_b FROM tbl_1 x, > tbl_2 a, tbl_2 b > WHERE x.area_1 = a.id > OR x.area_2 = b.id GROUP BY x.id > > But this ALWAYS returns the area_name (funding) in the value > of area_b > (have no idea why) > > Thanks for any help. It is appreciated. > > - Charles > > > On Friday, March 7, 2003, at 01:42 PM, Jim Lucas wrote: > > > Then the information in the DB is the same. > > > > Jim > > - Original Message - > > From: "Charles Kline" <[EMAIL PROTECTED]> > > To: "Rich Gray" <[EMAIL PROTECTED]> > > Cc: <[EMAIL PROTECTED]> > > Sent: Friday, March 07, 2003 10:03 AM > > Subject: Re: [PHP] MySQL Alias and PHP > > > > > > Thanks for the help. Almost there. Here is what I have: > > > > SELECT x.id, x.headline, x.description, a.area area_a, b.area area_b > > FROM tbl_funding x, tbl_dra a, tbl_dra b > > GROUP BY x.id LIMIT 0 , 30 > > > > The problem is that $array[area_a] and $array[area_b] > display the same > > info. > > > > > > > > > > > > On Friday, March 7, 2003, at 11:09 AM, Rich Gray wrote: > > > >>> Hi all, > >>> > >>> I have this query: > >>> > >>> SELECT a.area_name, b.area_name FROM tbl_1 x, tbl_2 a, tbl_2 b > >>> WHERE x.area_1 = a.id > >>> AND x.area_2 = b.id > >>> > >>> I am using PEAR DB to get my results as an ASSOC ARRAY. > How do I echo > >>> the values for a.id and b.id? > >>> > >>> Thnks > >>> Charles > >>> > >> > >> I presume you mean area_name... > >> > >> Try this -> SELECT a.area_name as area_a, b.area_name as > area_b FROM > >> tbl_1 > >> x, tbl_2 a, tbl_2 b > >> Then you can refer to the columns as $array['area_a'] and > >> $array['area_b'] > >> > >> HTH > >> Rich > >> > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Pages refresh on submission on RedHat Server - POST problem
I think I know what can be causing it. Maybe on your "local" config you have register_globals turned on, and on the other (Red Hat) they are turned off. Try: if ($_GET['submit_login'] <> "") or if ($_POST['submit_login'] <> "") depending on the method you're using to send the data to the Red Hat server. Tell us if that works. -- Un gran saludo/Big regards... Arturo Barajas, IT/Systems PPG MX (SJDR) (427) 271-9918, x448 > -Original Message- > From: Arijit Chaudhuri [mailto:[EMAIL PROTECTED] > Sent: Jueves, 06 de Marzo de 2003 01:02 p.m. > To: Barajas, Arturo > Subject: RE: [PHP] Pages refresh on submission on RedHat Server - POST > problem > > > Tried using a hidden field named form_submitted with a value Y. Even > checking for that does not help. Checked the same file on my > server and it > works fine. > > Regards, > Arijit > > -Original Message- > From: Barajas, Arturo [mailto:[EMAIL PROTECTED] > Sent: Friday, March 07, 2003 12:05 AM > To: 'Arijit Chaudhuri' > Subject: RE: [PHP] Pages refresh on submission on RedHat Server - POST > problem > > > Arijit, > > Are you clicking on the button or pressing on a field > to send the > data? > > AFAIK, if you click, it will set the var. If you just press > , it will > submit the form, but won't set the var. I personally use a > hidden var, and I > check for that one. > > HTH. > -- > Un gran saludo/Big regards... >Arturo Barajas, IT/Systems PPG MX (SJDR) >(427) 271-9918, x448 > > > -Original Message- > > From: Arijit Chaudhuri [mailto:[EMAIL PROTECTED] > > Sent: Jueves, 06 de Marzo de 2003 11:57 a.m. > > To: [EMAIL PROTECTED] > > Subject: [PHP] Pages refresh on submission on RedHat Server - POST > > problem > > > > > > Its a rather strange thing. I tested all my pages on my > Win2000-Apache > > configuration and uploaded them to my clients RedHat > server. There, on > > submission, all pages just refresh themselves. All my forms > are set to > > submit to the same page and I check in the beginning for the > > submit button > > variable. If its set, the form data is processed - else its > > assumed that its > > the first time that the page is being viewed. > > > > I loaded the pages on another RedHat server and all pages > > work perfectly > > there. > > > > I experimented a bit and found that if I change the action of > > forms to GET, > > they work. But with passwords and file uploads, I cant do > that for all > > pages. > > > > Have tried $HTTP_POST_VARS also - doesnt work. > > > > Any idea of what could be the problem? If the submit button is named > > "submit_login", I am checking as follows: > > if ($submit_login <> "") > > to see if the form has been submitted. Hve tried isset also. > > > > Thanks, > > Arijit > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Pages refresh on submission on RedHat Server - POST problem
Arijit, Are you clicking on the button or pressing on a field to send the data? AFAIK, if you click, it will set the var. If you just press , it will submit the form, but won't set the var. I personally use a hidden var, and I check for that one. HTH. -- Un gran saludo/Big regards... Arturo Barajas, IT/Systems PPG MX (SJDR) (427) 271-9918, x448 > -Original Message- > From: Arijit Chaudhuri [mailto:[EMAIL PROTECTED] > Sent: Jueves, 06 de Marzo de 2003 11:57 a.m. > To: [EMAIL PROTECTED] > Subject: [PHP] Pages refresh on submission on RedHat Server - POST > problem > > > Its a rather strange thing. I tested all my pages on my Win2000-Apache > configuration and uploaded them to my clients RedHat server. There, on > submission, all pages just refresh themselves. All my forms are set to > submit to the same page and I check in the beginning for the > submit button > variable. If its set, the form data is processed - else its > assumed that its > the first time that the page is being viewed. > > I loaded the pages on another RedHat server and all pages > work perfectly > there. > > I experimented a bit and found that if I change the action of > forms to GET, > they work. But with passwords and file uploads, I cant do that for all > pages. > > Have tried $HTTP_POST_VARS also - doesnt work. > > Any idea of what could be the problem? If the submit button is named > "submit_login", I am checking as follows: > if ($submit_login <> "") > to see if the form has been submitted. Hve tried isset also. > > Thanks, > Arijit > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] maguma problems with php 4.3 and apache
AFAIK, you're either lacking those files or they are not compatible with Apache or some other module. I personally think it's the first option. BTW; normally, every php*.dll file resides below the main php install directory, except that file, which should reside on WIN[dows|nt]\System[32], as the installation README tells. Have you looked for those files under the directories where maguma tries to find them? -- Un gran saludo/Big regards... Arturo Barajas, IT/Systems PPG MX (SJDR) (427) 271-9918, x448 > -Original Message- > From: Sunfire [mailto:[EMAIL PROTECTED] > Sent: Martes, 04 de Marzo de 2003 05:13 p.m. > To: [EMAIL PROTECTED] > Subject: Re: [PHP] maguma problems with php 4.3 and apache > > > in httpd.conf i have the line: > LoadModule php4_module "C:/Program Files/Maguma > Studio/php/sapi/php4apache.dll" > i get the line when i start apache: > [warning]: syntax error on line 860 in httpd.conf: cant load > module because > the library required for this application cant be found: (1113) > review the list of errors above and make notes of them then > press [esc] to > exit:> > > any ideas of what the deal is? > > > - Original Message - > From: "Barajas, Arturo" <[EMAIL PROTECTED]> > To: "'Sunfire'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Tuesday, March 04, 2003 10:15 AM > Subject: RE: [PHP] maguma problems with php 4.3 and apache > > > > Let's check: > > > > 1. Do you have that file? I think that maguma needs it, but > I'm not sure, > since I haven't used it. > > 2. Do you have the extension_dir pointing to the place > where the files > should be? > > > > Extracted from php.ini: > > > > ; Directory in which the loadable extensions (modules) reside. > > extension_dir = C:/php/extensions/ > > > > Normally it should be pointing to some dir below the main > php installation > dir. > > > > In my installation (php 4.2.1), that file doesn't exist. > Maybe you could > try to find it and mess a little more with php.ini. > > -- > > Un gran saludo/Big regards... > >Arturo Barajas, IT/Systems PPG MX (SJDR) > >(427) 271-9918, x448 > > > > > -Original Message- > > > From: Sunfire [mailto:[EMAIL PROTECTED] > > > Sent: Martes, 04 de Marzo de 2003 08:46 a.m. > > > To: [EMAIL PROTECTED] > > > Subject: [PHP] maguma problems with php 4.3 and apache > > > > > > > > > hi.. > > > > > > went and installed maguma that has php 4.3 in it and then > > > went to start > > > apache up again after setting up the new php.ini file.. and > > > ran into a few > > > problems.. i keep getting a warning from php: > > > php warning: cant load dynamic library "c:\program > > > files\maguma\php\extensions\php_dbg.dll" a device on your > > > computer isnt > > > functioning. > > > i get this error twice when trying to start apache and then > > > it freezes up.. > > > the only place i can find anything about the extensions_dir= > > > variable is in > > > php.ini so i tried to comment it out and that still didnt > > > work.. i tried > > > putting " around the dir name and it still doesnt work.. also > > > tried checking > > > to see if the file existed and it does.. > > > > > > any reason for that and any way to fix it? > > > > > > tnx > > > > > > > > > > > > --- > > > Outgoing mail is certified Virus Free. > > > Checked by AVG anti-virus system (http://www.grisoft.com). > > > Version: 6.0.458 / Virus Database: 257 - Release Date: 2/24/2003 > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.458 / Virus Database: 257 - Release Date: 2/24/2003 > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] maguma problems with php 4.3 and apache
Let's check: 1. Do you have that file? I think that maguma needs it, but I'm not sure, since I haven't used it. 2. Do you have the extension_dir pointing to the place where the files should be? Extracted from php.ini: ; Directory in which the loadable extensions (modules) reside. extension_dir = C:/php/extensions/ Normally it should be pointing to some dir below the main php installation dir. In my installation (php 4.2.1), that file doesn't exist. Maybe you could try to find it and mess a little more with php.ini. -- Un gran saludo/Big regards... Arturo Barajas, IT/Systems PPG MX (SJDR) (427) 271-9918, x448 > -Original Message- > From: Sunfire [mailto:[EMAIL PROTECTED] > Sent: Martes, 04 de Marzo de 2003 08:46 a.m. > To: [EMAIL PROTECTED] > Subject: [PHP] maguma problems with php 4.3 and apache > > > hi.. > > went and installed maguma that has php 4.3 in it and then > went to start > apache up again after setting up the new php.ini file.. and > ran into a few > problems.. i keep getting a warning from php: > php warning: cant load dynamic library "c:\program > files\maguma\php\extensions\php_dbg.dll" a device on your > computer isnt > functioning. > i get this error twice when trying to start apache and then > it freezes up.. > the only place i can find anything about the extensions_dir= > variable is in > php.ini so i tried to comment it out and that still didnt > work.. i tried > putting " around the dir name and it still doesnt work.. also > tried checking > to see if the file existed and it does.. > > any reason for that and any way to fix it? > > tnx > > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.458 / Virus Database: 257 - Release Date: 2/24/2003 > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Keeping existing data in textarea's
Mirco, What I do is (in a JavaScript function): window.location = "?"; and then populate the fields this way: or HTH -- Un gran saludo/Big regards... Arturo Barajas, IT/Systems PPG MX (SJDR) (427) 271-9918, x448 > -Original Message- > From: Mirco Ellis [mailto:[EMAIL PROTECTED] > Sent: Lunes, 03 de Marzo de 2003 12:30 p.m. > To: Php-General (E-mail) > Subject: [PHP] Keeping existing data in textarea's > > > Hi, I have a developed a simple Helpdesk for our small > company. When users > log calls they get an alert message warning them that they > must fill in all > the fields if they have missed a field. At the moment if they > happen to > forget a field, they receive the alert message, but then have > to start all > over again. How do I keep the existing data in the textareas from > dissapearing after the alert message? > > Mirco > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] changing colors on buttons
Use CSS:
input {
color: Navy;
background: LightBlue;
}
(I'm writing from memory, but the essence is that.)
((HTH))
--
Un gran saludo/Big regards...
Arturo Barajas, IT/Systems PPG MX (SJDR)
(427) 271-9918, x448
> -Original Message-
> From: Sunfire [mailto:[EMAIL PROTECTED]
> Sent: Lunes, 03 de Marzo de 2003 11:13 a.m.
> To: [EMAIL PROTECTED]
> Subject: [PHP] changing colors on buttons
>
>
> is there a way you can change the text color on buttons as well as the
> background color for a button? i have a button that looks like:
> onclick="window.location='edit.php';"
> onkeypress="window.location='edit.php'">
> so is there a way to change text color and background color
> for that? or is
> it better to use and do it that way...
> my client wants light blue buttons with dark blue text on
> them but we need
> "real buttons" if you really want to call them that..not
> images that act
> like buttons...
>
> tnx
>
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.458 / Virus Database: 257 - Release Date: 2/24/2003
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Getting a Multiple Select Form Field's Value
Mike: On the name of the select, use "[]". That way, you can access the array to see what options were selected. -- Un gran saludo/Big regards... Arturo Barajas, IT/Systems PPG MX (SJDR) (427) 271-9918, x448 > -Original Message- > From: Mike Walth [mailto:[EMAIL PROTECTED] > Sent: Viernes, 21 de Febrero de 2003 05:45 p.m. > To: [EMAIL PROTECTED] > Subject: [PHP] Getting a Multiple Select Form Field's Value > > > Hello: > > I'm trying to get the value from the following form field. > > > Value1 > Value2 > Value3 > > > I can get it to return one value, but if I select multiple > values I can't > get all the values form it. Any ideas would be appreciated. > > Mike Walth > CinoFusion > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] ftp_get()
Chris,
Wouldn't work if you urlencode the path to the file?
Something like:
ftp_get($con,"/tmp/download.tmp", urlencode("/remote/file dir/file.txt"), FTP_ASCII)
THT
--
Un gran saludo/Big regards...
Arturo Barajas, IT/Systems PPG MX (SJDR)
(427) 271-9918, x448
> -Original Message-
> From: Muti [mailto:[EMAIL PROTECTED]]
> Sent: Miércoles, 12 de Febrero de 2003 05:17 p.m.
> To: [EMAIL PROTECTED]
> Subject: [PHP] ftp_get()
>
>
> I am trying to ftp_get($con,"/tmp/download.tmp","/remote/file
> dir/file.txt",FTP_ASCII). I am getting errors because of the
> space in the
> remote filename. I tried using "/remote/file\ dir/file.txt" as the
> filename, but that also fails. I also tried to ftp_chdir()
> to the directory
> first and get file.txt to no avail. Does anyone have any
> ideas on how to
> GET a file that is in a directory with a space in it?
>
> -Chris
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] undefined function - crypt()
Tony,
You have to compile PHP with the "crypt" option, I don't remember the exact syntax
(--enable-crypt? --with-crypt=/path?)
Something along those lines...
--
Un gran saludo/Big regards...
Arturo Barajas, IT/Systems PPG MX (SJDR)
(427) 271-9918, x448
> -Original Message-
> From: Anthony Ritter [mailto:[EMAIL PROTECTED]]
> Sent: Miercoles, 12 de Febrero de 2003 03:00 p.m.
> To: [EMAIL PROTECTED]
> Subject: [PHP] undefined function - crypt()
>
>
> Using MS Win98 / PHP /Apache
>
> I'm getting a undefined function error - crypt()
>
> The following scripts were taken from Larry Ullman's book on
> PHP on page
> 60-61.
>
> Any advice would be helpful.
> Thank you.
>
> Tony Ritter
> ..
>
> //ullmanform.html
>
>
> HTML Form
>
>
>
> First Name name=FirstName>Last Name
> E-mail Address
> Comments
>
>
>
>
>
> // ullmanpassword2.php
>
>
>
> Form Results/Using Strings
>
>
> the data generated by "ullmanform.html". */
>
> $FirstName = trim($FirstName);
> $LastName = trim($LastName);
> $Email = trim($Email);
> $Comments = trim($Comments);
> $Name = $FirstName . " " . $LastName;
> print ("Your name is $Name.\n");
> print ("Your E-mail address is $Email.\n");
> print ("This is what you had to say:\n $Comments\n");
> $CryptName = crypt($Name);
> print ("This is the crypt() version of your name: $CryptName\n");
> ?>
>
>
> ..
>
>
> Fatal error: Call to undefined function: crypt()
> in c:\program files\apache group\apache\htdocs\ullmanpassword2.php
>
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] MySQL Login Setup not working with PHP
Try user = 'root', password = ''. It's a security breach, so you would want to change it ASAP. Look for the SQL GRANT and REVOKE commands. -- Un gran saludo/Big regards... Arturo Barajas, IT/Systems PPG MX (SJDR) (427) 271-9918, x448 > -Original Message- > From: Tim Burgan [mailto:[EMAIL PROTECTED]] > Sent: Miércoles, 12 de Febrero de 2003 07:32 a.m. > To: [EMAIL PROTECTED] > Subject: [PHP] MySQL Login Setup not working with PHP > > > I've installed a bundle from ( www.fireworks.com.au ) that > includes PHP, > MySQL and Apache all pre-configured. > > All is working OK, except that I'm trying to access a table > in my database > using the following PHP code: > > $dbServer = "localhost"; > $dbName = "siteStats"; > $dbUser = "username"; > $dbPass = "password"; > ?> > > The problem is that I don't know what my USERNAME or PASSWORD > for MyDQL are. > How do I find this information out? > > I thought it was in the 'my.ini' file, but with this > installation there > doesn't seem to be one. > > Alternatively, does anyone know of a very simple tutorial > that explains > STEP-BY-STEP of how to install Apache, PHP and MySQL to run on a local > machine.. that even I can understand. > > Thanks > > Tim Burgan > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] array_fill error
Try "array" only: $arr = array(0, 99, 0); print_r($arr); HTH -- Un gran saludo/Big regards... Arturo Barajas, IT/Systems PPG MX (SJDR) (427) 271-9918, x448 > -Original Message- > From: Erin Fry [mailto:[EMAIL PROTECTED]] > Sent: Martes, 11 de Febrero de 2003 10:47 a.m. > To: [EMAIL PROTECTED] > Subject: [PHP] array_fill error > > > I am trying to initialize a large array with all values being > 0. Ive tried: > > $arr = array_fill(0, 99, 0); > > and I get this error message: > Fatal error: Call to undefined function: array_fill() > > Any information and suggestions will be greatly appreciated. > > Thanks. > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.449 / Virus Database: 251 - Release Date: 1/27/2003 > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] I get a "File Download" dialogue box
You need to tell Apache that the .php extension is a web page. Take a look at the README or the INSTALL text files, there is the solution. I think it has to be something along the "AddType" lines. -- Un gran saludo/Big regards... Arturo Barajas, IT/Systems PPG MX (SJDR) (427) 271-9918, x448 > -Original Message- > From: news [mailto:[EMAIL PROTECTED]] > Sent: Lunes, 10 de Febrero de 2003 10:50 a.m. > To: [EMAIL PROTECTED] > Subject: [PHP] I get a "File Download" dialogue box > > > I am trying to configure run PHP4 on Apache on Windows XP. > > When I type http://localhost/ all I get is a "File Download" > dialogue box, > instead of the normal Apache server page. > > Does anyone know whats is going on here? > > Please tell me if you need any more information. > > -Nelson > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Uploading an image to a db
Greetings, people. I have the following code to upload an image to a db: if (isset($imgLogo) && $imgLogo != "none") $data = addslashes(fread(fopen($imgLogo, "r"), filesize($imgLogo))); else $data = ""; Then I just "INSERT INTO table (image) VALUES $data" but I think that the string that contains the image gets truncated somehow. Can anybody tell me why? Is the "addslashes" really needed? I'm using php 4.2.1. Thanks in advance. -- Un gran saludo/Big regards... Arturo Barajas, Tech Support Supervisor IT PPG México (427) 271-9918, x448 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] A scrollable area within a page?
Denis, There are two ways: 1. Using text areas Content, you can modify it dinamically using JS. 2. Using the IFRAME tag (which I think is not advised). I'd recommend the first one. HTH -- Un gran saludo/Big regards... Arturo Barajas, IT/Systems PPG MX (SJDR) (427) 271-9918, x448 > -Original Message- > From: Denis L. Menezes [mailto:[EMAIL PROTECTED]] > Sent: Miércoles, 05 de Febrero de 2003 08:24 a.m. > To: PHP general list > Subject: [PHP] A scrollable area within a page? > > > Hello friends, > > Can anyone please suggest me some lnks orhelp me with some > info on how to make 2 scrollable areas inside one webpage? > Also, can I put dynamic data output into these areas? > > Thanks very much. > > Denis > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] PHP4.2.2 Windows
BTW: AccessFileName directive Syntax: AccessFileName filename [filename] ... Default: AccessFileName .htaccess Context: server config, virtual host Status: core Compatibility: AccessFileName can accept more than one filename only in Apache 1.3 and later When returning a document to the client the server looks for the first existing access control file from this list of names in every directory of the path to the document, if access control files are enabled for that directory. For example: AccessFileName .acl before returning the document /usr/local/web/index.html, the server will read /.acl, /usr/.acl, /usr/local/.acl and /usr/local/web/.acl for directives, unless they have been disabled with AllowOverride None See Also: AllowOverride and Configuration Files -- Un gran saludo/Big regards... Arturo Barajas Sistemas PPG MX (SJDR) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] PHP4.2.2 Windows
> From: Tim Thorburn [mailto:[EMAIL PROTECTED]] > Yes, I had tried the forward slashes before and I just tried > to escape the > backslashes as you thought - sadly neither have worked :( >From the Apache site: "Since it is often difficult to manage files with names like .htaccess under windows, you may find it useful to change the name of this configuration file using the AccessFilename directive." -- Un gran saludo/Big regards... Arturo Barajas Sistemas PPG MX (SJDR) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] resizing images comming out of blobs
> From: andy [mailto:[EMAIL PROTECTED]]
> Hi there,
Hey, Andy.
> I am wondering how to resize an image which is stored in a
> mysql blob field.
> With files this workes just fine, but how to do this with the
> image comming from blob? Has anybody done this already?
Incidentally, I've done this just yesterday.
First download the image, write it to the directory and then proceed as you will. It
uses ImageMagick, 'cause my ISP still doesn't install GD 2.x.
Here it goes (I use the ADODB library using MySQL), and in fact, if someone can
optimize it, it would be welcome :^)
$rsColegio = $conn->Execute("SELECT * FROM ConEsc_Colegio WHERE Colegio_Id='" .
$rs->Fields("Colegio_Id") . "'") or die("Algo paso en los colegios...");
if (stristr($rsColegio->Fields("Colegio_Imagen_Tipo"), "gif") != "")
$fileext = ".gif";
elseif (stristr($rsColegio->Fields("Colegio_Imagen_Tipo"), "jpeg") != "")
$fileext = ".jpg";
elseif (stristr($rsColegio->Fields("Colegio_Imagen_Tipo"), "jpg") != "")
$fileext = ".jpg";
else
$fileext = "";
if ($fileext != "") {
$image_tmpfilename = "images/tmp_" . $rsColegio->Fields("Colegio_Id") .
$fileext;
$image_filename = "images/" . $rsColegio->Fields("Colegio_Id") . $fileext;
$file = fopen("$image_tmpfilename", "w") or die("No fue posible abrir el
archivo");
if (!$file)
echo "No se pudo abrir el archivo.\n";
else {
fputs($file, $rsColegio->Fields("Colegio_Imagen"));
fclose($file);
}
$aSize = getimagesize($image_tmpfilename);
$iWidth = $aSize[0];
$iHeight = $aSize[1];
if (($iWidth >= 120) || ($iHeight >= 85)) {
if ($iWidth > $iHeight)
$fPercent = $iWidth / 120;
else
$fPercent = $iHeight / 85;
$newWidth = $iWidth / $fPercent;
$newHeight = $iHeight / $fPercent;
system("convert -antialias -sample " . $newWidth . "x" . $newHeight .
" $image_tmpfilename $image_filename");
}
else
copy($image_tmpfilename, $image_filename);
unlink($image_tmpfilename);
}
else
$image_filename = "images/sinlogo.jpg";
Hope that helps.
--
Un gran saludo/Big regards...
Arturo Barajas
Sistemas PPG SJR
+52 (427) 271-9100, ext. 448
> -Original Message-
> Sent: Jueves, 04 de Julio de 2002 11:25 a.m.
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: [PHP] resizing images comming out of blobs
>
>
>
>
> Thank you for any help on that,
>
> andy
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Problem uploading an image
Greetings.
I have two pages where I upload images to a database.
The first one is a "capture", where I insert a record to the database, and the second
is to edit the data.
The problem: When I go to insert, the following code works flawlessly:
But, if I do in another page (the same darn snippet), it goes:
Warning: fopen("C:\WINNT\Web\wuicon1.gif", "r") - No such file or directory in
/web/domain/adconsolutions/htdocs/conexionescolar/frmnoticiasedi.php on line 18
Warning: stat failed for C:\WINNT\Web\wuicon1.gif (errno=2 - No such file or
directory) in /web/domain/adconsolutions/htdocs/conexionescolar/frmnoticiasedi.php on
line 18
Warning: fread(): supplied argument is not a valid File-Handle resource in
/web/domain/adconsolutions/htdocs/conexionescolar/frmnoticiasedi.php on line 18
Anybody knows why? It's the same vars, the same text boxes, etc. The only thing that
changes comes after that condition...
TIA.
--
Un gran saludo/Big regards...
Arturo Barajas
Sistemas PPG SJR
+52 (427) 271-9100, ext. 448
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] How to read the Exchange databases?
Hi, list. I'm starting an application, running Apache + PHP + MySQL under WinNT. I need a user database, and all the users are on the Exchange Server database. Does anyone know how can I read that database or connect to it? I'm already running the NTLM module, so I can validate my users under an NT domain, and I just don't want to transfer that Exchange database (unless there's no other way). TIA, any help will be greatly appreciated. -- Un gran saludo/Big regards... Arturo Barajas Sistemas PPG SJR +52 (427) 271-9100, ext. 448 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Re: Automatic user login under NT
> From: Lazor, Ed [mailto:[EMAIL PROTECTED]] Hi, Ed. > and I'm pretty sure I'm not the only one he's helped. That > garners even more respect - IMHO. I'm new on the list, so I really don't know Rasmus, or what he does. As far as I've read messages, he seems to be really appreciated and respected, one way or another. > I think this last point shows that this a battle between > ASP and PHP - not necessarily an OS / platform war. More > books, support, programming tools (libraries, editors, > etc.) and jobs based around the PHP programming language > would help tremendously. Have to agree with that. Though I've seen lots of books and all that stuff spring from -almost- nowhere. > >To write PHP extensions on Windows I think Visual C++ is more > >appropriate. > Does gcc (or some other free C programming language) for > Windows exist? Not exactly. You can install cygwin under NT/2K and have a shell and a host of other utilities (even bash!) that make your winbox almost cross-platform (at least for development, I think). -- Un gran saludo/Big regards... Arturo Barajas Sistemas PPG SJR +52 (427) 271-9100, ext. 448 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Re: Automatic user login under NT
> From: Manuel Lemos [mailto:[EMAIL PROTECTED]] Hi, Manuel. > I don't agree and even think that it is a stupid thing to say because > open source is not about excluding Windows users even if > there are much less open source developers with Windows knowledge > there is no point in making Windows users feel bad about it. Sometimes you have to deal with it. At home I use Linux, but at the office it's Windows, and there's nothing we can do to change it. I thought open source wasn't about a given OS, but rather a philosophy (?). I can develop for Windows (or BeOS or MacOS or whatever) and what I do can be still open source, isn't it? OTOH, how can I (or anyone for that matter) change the mentality of a "corporate user" about open source tools with that other "mentality"? "Being second class?" My God. I don't want a flamewar, anyway, but I think it's not the most clever way to establish the open source movement, IMHO. > Anyway, personally I don't use Windows nor have a project > that motivate me to add support to NTLM authentication in > PHP, but if you or anybody has interest in doing it and > know enough C, I can tell you how to write a PHP extension > to support that. Just let me know if you are interested. Of course I am :^). What compiler do I need? gcc on cygwin or something? I'll have to dust my old C notebooks :^). > -- > Regards, > Manuel Lemos -- Un gran saludo/Big regards... Arturo Barajas Sistemas PPG SJR +52 (427) 271-9100, ext. 448 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Automatic user login under NT
Greetings, everyone.
I'm new on the list (not so on PHP).
I'm stuck with a little problem, I'm trying to implement some PHP pages at work, where
ASP is used. The platform is NT 4.0 SP6, with PHP 4.2.1.
My problem is that with ASP I can have something like
Request.ServerVariables("LOGON_USER"). I've tried using $_SERVER["LOGON_USER"] but to
no avail. Curiously, Request.ServerVariables("REMOTE_ADDR") and
$_SERVER["REMOTE_ADDR"] work like a charm.
How can I obtain the login the user entered when logged to his/her machine?
Thanks in advance.
--
Un gran saludo/Big regards...
Arturo Barajas
Sistemas PPG SJR
+52 (427) 271-9100, ext. 448
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
