Re: [PHP] Re: Connecting to MySQL Sever using PHP5
- Original Message - From: "Mark Rees" <[EMAIL PROTECTED]> To: Sent: Thursday, October 13, 2005 11:54 AM Subject: Fw: [PHP] Re: Connecting to MySQL Sever using PHP5 Back to the list - please use reply-all - Original Message - From: "Andreja Simovic" <[EMAIL PROTECTED]> To: "Mark Rees" <[EMAIL PROTECTED]> Sent: Thursday, October 13, 2005 9:58 AM Subject: Re: [PHP] Re: Connecting to MySQL Sever using PHP5 Sometimes this error may ocure if you do not place trailing slash in define sites url http://localhost/mysite1/ from my expirience - Original Message - From: "Mark Rees" <[EMAIL PROTECTED]> To: Sent: Thursday, October 13, 2005 10:43 AM Subject: [PHP] Re: Connecting to MySQL Sever using PHP5 >> I have just installed PHP5. I am using Windows XP and have already > installed >> MySQL. >> >> When I try and make a connection to a database on MySQL via >> Dreamweaver I >> get the following error message: "An unidentified error has occurred". >> >> What could be wrong > > Have a look at this: > http://uk2.php.net/mysql_error > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > __ NOD32 1.1251 (20051012) Information __ > > This message was checked by NOD32 antivirus system. > http://www.eset.com > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ NOD32 1.1251 (20051012) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Between Query (0T)
I am not sure
but maybe something like this is posible
$current_year = date(Y);
$qry = "SELECT * FROM
`table`
WHERE ($current_year-YEAR(birthday)) BETWEEN 25 AND 26"
"Matthew Weier O'Phinney" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>* Ryan A <[EMAIL PROTECTED]> :
>> Thanks for replying.
>>
>> > SELECT * FROM
>> > `table`
>> > WHERE `age` BETWEEN 25 AND 26;
>>
>> I knew the above, but how do i use it with my date field when i have
>> birthdates like this:
>> 01-01-1969
>> and 03-05-1955
>
> Just like you would in the example above -- only with dates that are
> compliant with your RDBMS, and using the earliest date first. The
> formats you give -- 'MM-DD-' won't work in most RDBMS'; typically
> you go from most general to most specific, e.g. '-MM-DD'. So, using
> the dates you gave:
>
>SELECT * FROM `table` WHERE `age` BETWEEN '1955-03-05' AND
> '1969-01-01';
>
> The date fields may be subject to the UNIX epoch; if so, neither of the
> dates above will be valid (epoch started 1970-01-01). Check the manual
> for your RDBMS to see if this is the case.
>
> Now, based on the OP's original question, about finding all users
> between an age range, one would need to determine the start date and end
> date prior to passing in the SQL. This can easily be done with
> strtotime():
>
>$ages = explode(',', $_GET['ages'], 2); // get the start/end ages
>$startDate = date("Y-m-d", strtotime("-$ages[0] years"));
>$endDate = date("Y-m-d", strtotime("-$ages[1] years"));
>$sql = "SELECT * FROM `table` WHERE `age` BETWEEN $startDate AND
> $endDate";
>
> Hope that helps.
>
>> On 5/8/2005 4:28:44 PM, Andy Pieters ([EMAIL PROTECTED]) wrote:
>> > On Sunday 08 May 2005 15:20, Ryan A wrote:
>> > > Sorry I know this is OT but I'm hoping someone will still
>> > > help...it should be quite simple :-)
>> > > I have a field in the database called "age" which is a DATE field.
>> > >
>> > > I also have a webform where the user can select between which ages
>> > > he wants the records shown...
>> > > eg: if he types 23,25 then I should get all results where
>> > > age > =23 and age <=25
>> > >
>> > SELECT * FROM
>> > `table`
>> > WHERE `age` BETWEEN 25 AND 26;
>> >
>> > You might want to sanitize your input first.
>> >
>> > Like using intval() on your input or mysql_escape_string
>
>
> --
> Matthew Weier O'Phinney | WEBSITES:
> Webmaster and IT Specialist | http://www.garden.org
> National Gardening Association| http://www.kidsgardening.com
> 802-863-5251 x156 | http://nationalgardenmonth.org
> mailto:[EMAIL PROTECTED] | http://vermontbotanical.org
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] HUMAN CHECK without url/session cookie/hidden input, etc.
i am pretty new in all of this, but i added this sites to restricted web sites in IE settings, so now it doesnt work at all "Ryan A" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > check up on CAPTCHA on google or your favourite search engine > > -Ryan > > > On 4/3/2005 11:35:03 PM, nime ([EMAIL PROTECTED]) wrote: >> A kind of :-) >> >> >> >> https://nokiags.wdsglobal. >> > com/bookmarkmanual?contractId=191&phoneId=408&captchaEnabled=true&step=detai > ls. >> > vm&bookmarkManualName=&bookmarkManualURL=&captchaKey=&mobileNumber=&siteLang > uageId=118 >> >> >> >> I mean what sort of data remembers the pass code here? >> >> I see no hidden input value/url value/session cookie/nothing. >> >> It means telepathy! >> >> >> >> >> >> "Marek Kilimajer" <[EMAIL PROTECTED]> wrote in message news:42505D1E. >> [EMAIL PROTECTED] >> >> > nime wrote: >> >> >> Is there any way to do a human check without sending any url/session >> cookie/hidden input value >> >> >> from server to browser? >> >> >> >> >> > >> >> > Do you mean telepathy? >> >> >> >> -- >> >> PHP General Mailing List (http://www.php.net/) >> >> To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.9.1 - Release Date: 4/1/2005 > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] HUMAN CHECK without url/session cookie/hidden input, etc.
did anyone tryed to paste this in address https://nokiags.wdsglobal.com/imageservlet "Ryan A" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > check up on CAPTCHA on google or your favourite search engine > > -Ryan > > > On 4/3/2005 11:35:03 PM, nime ([EMAIL PROTECTED]) wrote: >> A kind of :-) >> >> >> >> https://nokiags.wdsglobal. >> > com/bookmarkmanual?contractId=191&phoneId=408&captchaEnabled=true&step=detai > ls. >> > vm&bookmarkManualName=&bookmarkManualURL=&captchaKey=&mobileNumber=&siteLang > uageId=118 >> >> >> >> I mean what sort of data remembers the pass code here? >> >> I see no hidden input value/url value/session cookie/nothing. >> >> It means telepathy! >> >> >> >> >> >> "Marek Kilimajer" <[EMAIL PROTECTED]> wrote in message news:42505D1E. >> [EMAIL PROTECTED] >> >> > nime wrote: >> >> >> Is there any way to do a human check without sending any url/session >> cookie/hidden input value >> >> >> from server to browser? >> >> >> >> >> > >> >> > Do you mean telepathy? >> >> >> >> -- >> >> PHP General Mailing List (http://www.php.net/) >> >> To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.9.1 - Release Date: 4/1/2005 > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] very good resource
http://www.downloadfreetrial.com/scripts/php/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: eregi problem
I really dont know :)
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I m trying to check $GP[sifre] variable, $GP[sifre] must consist of alpha
> numeric chars only. here, how I check the variable:
>
> if((eregi("[^a-zA-Z0-9]",$GP[sifre])
>echo 'true';
> else
>echo 'false';
>
> It works if variable starts with alphabetic chars only.
> for example this returns 'ok'
>$GP[sifre]='blabla234243';
> but this does not work: (if variable starts with numeric chars)
>$GP[sifre]='3243242blabla';
>
> second one returns false, couldnt figure out the problem here. any help ?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: eregi problem
i'm not familliar with regular expresions but i think that ^a-z - means
that variable must start witx a-z characters
you can chek it here:
http://www.php.net/manual/en/reference.pcre.pattern.syntax.php
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I m trying to check $GP[sifre] variable, $GP[sifre] must consist of alpha
> numeric chars only. here, how I check the variable:
>
> if((eregi("[^a-zA-Z0-9]",$GP[sifre])
>echo 'true';
> else
>echo 'false';
>
> It works if variable starts with alphabetic chars only.
> for example this returns 'ok'
>$GP[sifre]='blabla234243';
> but this does not work: (if variable starts with numeric chars)
>$GP[sifre]='3243242blabla';
>
> second one returns false, couldnt figure out the problem here. any help ?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: image_type
I realy dont understand what are you saying :) "William Stokes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello, > > I was under impression that php automatically gives values to image_type > and image_name if one tries to upload image from a web form if the name of > the uploaded image field is image. > > If I do this I can see that there is a path for the uploaded image in a > variable but the echo won't print anything. Where I am mistaken here? > > var_dump($_GET); > echo $image_name; > > Thanks > -Will -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: How to insert and select images from postgres db
same thing for inserting, or similar but youl have to read file s something like: "J.F.Kishor" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi, > > I am having a problem in storing and selecting images in and > from postgres. > > My requirement is I have to select the image from the database > and display it in User Interface. > > Can anyone help me through this problem, I'am in need of this > solution by today. > > > > Regards, > - JFK > kishor > Nilgiri Networks -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: How to insert and select images from postgres db
i have done this before, but with mysql here is the way: now your link in other file , whitch will display a picture, would be "J.F.Kishor" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi, > > I am having a problem in storing and selecting images in and > from postgres. > > My requirement is I have to select the image from the database > and display it in User Interface. > > Can anyone help me through this problem, I'am in need of this > solution by today. > > > > Regards, > - JFK > kishor > Nilgiri Networks -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] help with GD
is there any way to edit and resize animated gifs in PHP? with imagegif() i only get a static image -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
