[PHP-DB] Re: [PHP] Regex for telephone numbers
On 12/29/2010 4:35 PM, Daniel P. Brown wrote:
> On Wed, Dec 29, 2010 at 19:12, Ethan Rosenberg wrote:
>> Dear List -
>>
>> Thank you for all your help in the past.
>>
>> Here is another one
>>
>> I would like to have a regex which would validate that a telephone number
>> is in the format xxx-xxx-.
>
> Congrats. People in Hell would like ice water. Now we all know
> that everyone wants something. ;-P
>
> Really, this isn't a PHP question, but rather one of regular
> expressions. That said, something like this (untested) should work:
>
>
> $numbers = array(
> '123-456-7890',
> '2-654-06547',
> 'sf34-asdf-',
> 'abc-def-ghij',
> '555_555_',
> '000-000-',
> '8007396325',
> '241-555-2091',
> '800-555-0129',
> '900-976-739',
> '5352-342=452',
> '200-200-2000',
> );
>
> foreach ($numbers as $n) {
> echo $n.(validate_phone($n) ? ' is ' : ' is not ').'a valid
> US/Canadian telephone number.'.PHP_EOL;
> }
>
>
> function validate_phone($number) {
>
> if
> (preg_match('/^[2-9]{1,}[0-9]{2,}\-[2-9]{1,}[0-9]{2,}\-[0-9]{4,}$/',trim($number)))
> {
> return true;
> }
>
> return false;
> }
> ?>
>
>
Actually...
Specified here [1] it says that the {1,} is the same as '+'. I think you should
drop the comma. If you don't this would be valid 844-2345-123456
^[2-9]{1,}[0-9]{2,}\-[2-9]{1,}[0-9]{2,}\-[0-9]{4,}$
should be
^[2-9]{1}[0-9]{2}\-[2-9]{1}[0-9]{2}\-[0-9]{4}$
1 http://us.php.net/manual/en/regexp.reference.repetition.php
Jim Lucas
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: [PHP] goto - My comments
On 12/18/2010 9:17 PM, Ethan Rosenberg wrote: Dear List - Thanks to all for your EXCELLENT comments. I definitly agree that goto is a command to be avoided at all costs. In this case, I could not figure out how to acheive the desired result without the goto. So being a newbie, I humbly request that you show [and at the same time teach] me how to rewrite the code to eleiminate the goto. Additionally, would you please do the same for the code I list below. This code runs perfectly. == This is the form: Site: Record Number: First Name: Last Name: Phone: Height: Male Female Not sure if you can change the values for the Sex field to 'Male' & 'Female' respectively, but it would simplify the following example. Here is my rendition of how I would do it. I would suggest cleaning up the output code some and use *_assoc() instead of the *_array() function call. It gives you back the array version of the output. This way instead of calling $row[0], $row[...] you would call $row['Fname'] or $row['Lname'] instead. Get rid of all those commented out sections and you will have a good script to play with. Let us know what comes of it... == THANK YOU EVER SO MUCH FOR YOUR HELP. Ethan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: [PHP] Sample script files with 3 different select boxes with mysql conditions in select boxes
Robert Cummings wrote: > On Thu, 2008-01-03 at 09:18 -0600, Balaji A wrote: >> Hi, >> >> I have a table with the below fields. (id, title, language, author & >> link to the book). >> >> Initially I want to display a page with 3 select boxes (language, >> author & title). >> >> Initially first select box displays the available language by querying >> the database. On selecting one language, author select box should show >> the matching records from the database. After selecting the author, >> matching records should display in title. >> >> Could any body send the sample script files with 3 select boxes? > > Anything else you'd like to add to the requirements document? > > Cheers, > Rob. I would think it be best if it was javascript based so it dynamically loads the data via AJAX or a predefined JS hash, but then when JS was disabled, it would be best if it fell back to old school and submitted the form when I select the lang->auth->book. Thanks -- Jim Lucas "Some men are born to greatness, some achieve greatness, and some have greatness thrust upon them." Twelfth Night, Act II, Scene V by William Shakespeare -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: [PHP] Re: the opposite of a join?
Robert Cummings wrote: On Wed, 2007-10-03 at 14:49 -0700, Jim Lucas wrote: This is only from my own personal testing. Mind you that I have only been using PostgreSQL for a year or so. But one problem that I have always ran into with MySQL is that when JOIN'ing tables that have large data sets is a PITA. Were you doing left joins when you experienced those problems? Left joins are usually very fast. So, if I was running MySQL, I would use SQL #1, but if I were using PostgreSQL, I would use SQL #2 I'd use the left join whenever available. Cheers, Rob. Honestly, I cannot remember. It was right when I first started with PHP/mysql back in 1999. I think we were using a JOIN (without the LEFT) Which I think the default is an INNER JOIN if I do recall. I really have never played with performance over the past few years. This past year I have been working on a new DB with Call Detail Records for a phone company. On average we have to deal with processing 2 - 4 million records each billing cycle. So, having to work with that amount of CDR's and a couple thousand client records that are associated with them, makes for a good performance test on SQL statements. -- Jim Lucas "Perseverance is not a long race; it is many short races one after the other" Walter Elliot "Some men are born to greatness, some achieve greatness, and some have greatness thrust upon them." Twelfth Night, Act II, Scene V by William Shakespeare -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: [PHP] Re: the opposite of a join?
Colin Guthrie wrote: Martin Marques wrote: SELECT * FROM company WHERE id NOT IN (SELECT companyID FROM contacts); Not ideal as has been mentioned else where in this thread. Col I think one would have to take into account the DB type being used here. I can have MySQL and PostgreSQL setup and running with the same table structure (well, as close as you can get) configured with two different databases in them. SQL #1 SELECT * FROMcompany WHERE id NOT IN ( SELECT companyID FROMcontacts ); SQL #2 SELECT company.* FROMcompany LEFT JOIN contacts ON ( company.companyID = contacts.companyID ) WHERE contacts.companyID IS NULL Now, both SQL statements will perform relatively the same on either DB's with a small data set. but, if you have a large data set, MySQL will benefit from having the Sub-Query style statement Where-as PostgreSQL will shine with the JOIN command. This is only from my own personal testing. Mind you that I have only been using PostgreSQL for a year or so. But one problem that I have always ran into with MySQL is that when JOIN'ing tables that have large data sets is a PITA. So, if I was running MySQL, I would use SQL #1, but if I were using PostgreSQL, I would use SQL #2 If anybody else has suggestions or comments about performance between MySQL vs. PostgreSQL with regards to similarly formed SQL calls, I would like to hear their experiences. -- Jim Lucas "Some men are born to greatness, some achieve greatness, and some have greatness thrust upon them." Twelfth Night, Act II, Scene V by William Shakespeare -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Multiple SELECT querys
I will take this example and improve upon it, try this:
$query = "SELECT myvalue FROM mytable WHERE some_condition";
$result = mysql_query($query) or die("Error: ".mysql_error());
$srch = array();
while( list($myvalue) = mysql_fetch_array($result)
{
$srch[] = $myvalue;
}
$query = "SELECT * FROM other_table WHERE this_val IN('". join("', '",
$srch). "')";
$result = mysql_query($query) or die("Error: ".mysql_error());
- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'Morten Nielsen'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, March 22, 2002 12:53 PM
Subject: RE: [PHP-DB] Multiple SELECT querys
> $query = "SELECT myvalue FROM mytable WHERE some_condition";
> $result = mysql_query($query) or die("Error: ".mysql_error());
> $srch = "";
> while( list($myvalue) = mysql_fetch_array($result)
> {
> $srch .= "$myvalue, ";
> }
> $srch = substr($srch, 0, -2);
> $query = "SELECT * FROM other_table WHERE this_val IN($srch)";
> $result = mysql_query($query) or die("Error: ".mysql_error());
>
> -Original Message-
> From: Morten Nielsen [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 22, 2002 2:28 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Multiple SELECT querys
>
>
> Hi,
>
> I make a SELECT in a mySQL database. It returns a variable, which contains
> 10 values. I then need to make another SELECT in a new database where I
have
> to use the previous 10 values in the WHERE sentence. How can I do this?
>
> Regards,
> Morten
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] any php/Linux gurus out there?
I being a person that is working with both RH 7.0 & 7.1 would not recommend forcing an upgrade. I did that when I attempted to upgrade to 7.2 and wanted to try a few new things that didn't come with the install. I ended up having to reinstall the entire OS. So, make the effort and upgrade all the deps also. it will be worth it in the long run. Jim Lucas - Original Message - From: "Jason Wong" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 04, 2002 8:18 PM Subject: Re: [PHP-DB] any php/Linux gurus out there? > On Tuesday 05 March 2002 07:52, Peter Lovatt wrote: > > Hi > > > > I am running the security upgrade and am getting the following error when I > > run the RPM > > The install is RH 7.0 and was pre-installed. I had assumed that the RPMs > > from Redhat would match the pre installed version, as it was standard. > > > > I am a humble programmer (and part time sys admin!), rather than a Linux/RH > > guru, so would appreciate some advice. What is the best way to deal with > > this ? > > > > > > error: failed dependencies: > > libcrypto.so.1 is needed by php-4.0.6-9.7.0 > > libmm.so.11 is needed by php-4.0.6-9.7.0 > > libssl.so.1 is needed by php-4.0.6-9.7.0 > > libcrypto.so.1 is needed by php-imap-4.0.6-9.7.0 > > > > Have you followed the instructions given on the RH website? Most upgrades are > performed using: > > rpm -Uvh xxx.rpm > > or > > rpm -Fvh xxx.rpm > > > > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.com.hk > > /* > "I'd love to go out with you, but I'm doing door-to-door collecting for static > cling." > */ > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] easy date format question
$today = date("Ymd");
$sql = "INSERT into table (date) values ('$today')";
when the $today variable is inserted into a mysql date column it will fit
just right.
but, if you want to insert it into a timestamp column, you will have to padd
it with 6 zero's
Jim Lucas
www.bend.com
- Original Message -
From: "Matthew Crouch" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 2:50 PM
Subject: [PHP-DB] easy date format question
> should be simple as pie, of course, but i can't find a straightforward
> syntax example in the documentation. i'm trying to change the PHP date
> format to mysql's.
>
> my code:
> $today = date("MMDD");
> $sql = "INSERT into table (date) values ('$today')";
> and so on...
>
> is filling the date field with zeros, instead of 2002-02-28
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] A while loop prob ?
Try this
if ($submit)
{
if($search == "")
{
$error1 = "No Records found. Please use at least 1
character in search box";
} else {
$srchsql = "select * from $tbn where name like \"%$search%\" ";
$srchresult = mysql_query($srchsql, $con);
$name =$srchrow['name'];
$details =$srchrow['details'];
$price =$srchrow['price'];
$imgloc =$srchrow['imgloc'];
while (list($name, $details, $price, $imgloc) =
mysql_fetch_array($srchresult))
{
$display_srch_rows .=
"$imgloc$name$details$price";
}
echo $display_srch_rows;
}
}
the problem is, you were overwriting your results each time you went into
the loop therefor always ending up with the last returned result set.
if you use " .= " instead of " = " you will concat the results, therefor
making one long string.
then echo/print the $display_srch_rows variable.
Jim Lucas
- Original Message -
From: "Dave Carrera" <[EMAIL PROTECTED]>
To: "php List" <[EMAIL PROTECTED]>
Sent: Wednesday, February 13, 2002 11:40 AM
Subject: [PHP-DB] A while loop prob ?
> Hi All
>
> What have I done wrong here.
>
> 3 yes 3 hours I have been plaing with this loop.
>
> All it shows is the last record in my db.
>
> It should show and record containing any string in the search.
>
> Error works
>
> Please help I beg you...
>
> As always thank you for any help
>
> Dave C
>
> - My Code Starts Here
>
> if ($submit){
> if($search == ""){
> $error1 = "No Records found. Please use at least
> 1 character in search box";
> }
> else
> {
> $srchsql = "select * from $tbn where name like \"%$search%\" ";
> $srchresult = mysql_query($srchsql, $con);
> $name =$srchrow['name'];
> $details =$srchrow['details'];
> $price =$srchrow['price'];
> $imgloc =$srchrow['imgloc'];
> while (list($name, $details, $price, $imgloc)
> =mysql_fetch_array($srchresult)){
>
> $display_srch_rows =
> "$imgloc$name$details$price
> ";
> }
> }
> }
>
> Dave Carrera
> Website Designer
> http://www.davecarrera.com
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Passing form values with quotes, to itself
it is called magic quotes and it can be enabled through the php.ini file. Jim Lucas - Original Message - From: "William Fong" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 13, 2002 10:36 AM Subject: Re: [PHP-DB] Passing form values with quotes, to itself > Doesn't PHP have something that will automatically do this? I can't > remember, but I think you had to enable it in php.ini or when you compile. > > (just like to know for future reference). > > thx. > > -w > > -- > William Fong - [EMAIL PROTECTED] > Phone: 626.968.6424 x210 | Fax: 626.968.6877 > Wireless #: 805.490.7732| Wireless E-mail: [EMAIL PROTECTED] > > > > > - Original Message - > From: "David Fudge" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, February 13, 2002 10:12 AM > Subject: Re: [PHP-DB] Passing form values with quotes, to itself > > > : before you submit to the db, you have to escape the quotes like this: > : > : $Body = addslashes($Body); > : all " " will show up as \" \" > : and ' ' will be \' \' > : > : when you pull the info from the db, you'll have to use "stripslashes()" to > : remove those you put in. > : $Body = stripslashes($Body_from_db); > : > : - Original Message - > : From: "Faye Keesic" <[EMAIL PROTECTED]> > : To: <[EMAIL PROTECTED]> > : Sent: Wednesday, February 13, 2002 1:02 PM > : Subject: [PHP-DB] Passing form values with quotes, to itself > : > : > : > Hi there. > : > > : > I have a form that contains several fields w/ text info (which may or > may > : > not contain single and double quotes). > : > > : > When the user clicks Preview, the form's action is set to call itself > : > ($PHP_SELF), and the info is displayed nicely so they can read it over, > : and > : > verify it before saving to the db. > : > > : > What I'm having problems with is that when the data has quotes, the text > : > data cuts off. > : > > : > If I use: > : > then double quotes are cut off. > : > > : > If I use: > : > then single quotes are cut off. > : > > : > I want nothing cut off! I've tried addslashes()..still cuts off. > : > > : > I hope that all made sense... > : > -- > : > Faye > : > > : > > : > -- > : > PHP Database Mailing List (http://www.php.net/) > : > To unsubscribe, visit: http://www.php.net/unsub.php > : > > : > : > : -- > : PHP Database Mailing List (http://www.php.net/) > : To unsubscribe, visit: http://www.php.net/unsub.php > : > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Passing form values with quotes, to itself
it will still cut off with the double quots. if you have a double quote inside of a double quoted value property This will still break. it does care if they are escaped. Jim Lucas - Original Message - From: "David Fudge" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 13, 2002 10:12 AM Subject: Re: [PHP-DB] Passing form values with quotes, to itself > before you submit to the db, you have to escape the quotes like this: > > $Body = addslashes($Body); > all " " will show up as \" \" > and ' ' will be \' \' > > when you pull the info from the db, you'll have to use "stripslashes()" to > remove those you put in. > $Body = stripslashes($Body_from_db); > > - Original Message - > From: "Faye Keesic" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, February 13, 2002 1:02 PM > Subject: [PHP-DB] Passing form values with quotes, to itself > > > > Hi there. > > > > I have a form that contains several fields w/ text info (which may or may > > not contain single and double quotes). > > > > When the user clicks Preview, the form's action is set to call itself > > ($PHP_SELF), and the info is displayed nicely so they can read it over, > and > > verify it before saving to the db. > > > > What I'm having problems with is that when the data has quotes, the text > > data cuts off. > > > > If I use: > > then double quotes are cut off. > > > > If I use: > > then single quotes are cut off. > > > > I want nothing cut off! I've tried addslashes()..still cuts off. > > > > I hope that all made sense... > > -- > > Faye > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Passing form values with quotes, to itself
Try this. That should to the job. Jim Lucas - Original Message - From: "Faye Keesic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 13, 2002 10:02 AM Subject: [PHP-DB] Passing form values with quotes, to itself > Hi there. > > I have a form that contains several fields w/ text info (which may or may > not contain single and double quotes). > > When the user clicks Preview, the form's action is set to call itself > ($PHP_SELF), and the info is displayed nicely so they can read it over, and > verify it before saving to the db. > > What I'm having problems with is that when the data has quotes, the text > data cuts off. > > If I use: > then double quotes are cut off. > > If I use: > then single quotes are cut off. > > I want nothing cut off! I've tried addslashes()..still cuts off. > > I hope that all made sense... > -- > Faye > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Select rows where ?
select * from table where column<>"something" select * from table where column NOT LIKE "%something%" Jim Lucas - Original Message - From: "Dave Carrera" <[EMAIL PROTECTED]> To: "php List" <[EMAIL PROTECTED]> Sent: Tuesday, February 12, 2002 10:39 AM Subject: [PHP-DB] Select rows where ? > Hi All > How do I select the rows that DO NOT contain a certain character. > > I.e. : select * from tablename where field dose not contain "A" > > Any pointers as always appreciated. > > davec > > Dave Carrera > Website Designer > http://www.davecarrera.com > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] # of Records in Table
does the table have an autoincrement column? Jim Lucas - Original Message - From: "Zach Curtis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 23, 2002 10:27 AM Subject: [PHP-DB] # of Records in Table > What syntax can I use to determine how many records are in a MySQL table and > then retrieve the value of the field "password" for the last record? I tried > using some combinations of COUNT(*) and LIMIT with no success. > > Thanks. > > > Zach Curtis > POPULUS > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Passing parameter in Paging
better yet, have a starting page multiplied by the page length define a constant that gives the page limit then have the receiving page do some math and do a mysql_data_seek() or array_seek() (which ever you are using) and then limit the returns by the page limit size? wouldn't that be the easiest way? if not, please let me know, cuz I am using that for pagination throughout my site via a couple function calls. Jim - Original Message - From: "olinux" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 28, 2001 2:58 PM Subject: Re: [PHP-DB] Passing parameter in Paging > Aren't all these form solutions making things more > complex than they need to be? Why not just pass the > parameters in the URL > > Use php to echo out start_at and end_at variables > > ie. HREF="http://website.com/search.php?keyword=something&start_at=15&end_at=30"; >2 > HREF="http://website.com/search.php?keyword=something&start_at=31&end_at=45"; >3 > > etc. > > olinux > > > --- Mihail Bota <[EMAIL PROTECTED]> wrote: > > Bogdan, in this respect, I have a question: can I > > pass the values of > > javascript variables to php variables? if yes, how? > > > > Mihai > > > > On Fri, 28 Dec 2001, Bogdan Stancescu wrote: > > > > > I don't understand why you won't use forms with > > buttons and hidden controls > > > since you know about this solution. I have two > > suggestions along this line: > > > 1. You probably don't want buttons on the page -- > > you may use image icons > > > instead (similar to a tape recorder's "play" and > > "fast forward" for next page > > > and last page) > > > 2. If you don't want to use images either, you may > > use regular links with > > > "href='javascript:document.nextPage.submit()'" > > where nextPage would be the form > > > name with the page forward data -- and so on. > > > > > > HTH > > __ > Do You Yahoo!? > Send your FREE holiday greetings online! > http://greetings.yahoo.com > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] MySQL date formats
in your select statement that you pull the date out with. wrap that column
with
SELECT UNIX_TIMESTAMP() FROM table;
this will return the unix timestamp now with this format use the date()
function and format the date how ever you would like.
Jim
- Original Message -
From: "Rosser, Chris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "'nautilis'" <[EMAIL PROTECTED]>
Sent: Thursday, December 20, 2001 9:36 AM
Subject: RE: [PHP-DB] MySQL date formats
> nautilis,
>
> Leave the date in the database in MySQL format (/MM/DD) and when you
> need to display the date on your page, just do this:
>
>
> explode("/", $datearray);
> $date = $datearray[2].'/'.$datearray[1].'/'.$datearray[0];
>
> ?>
>
> That just splits up the three numbers, and rearranges them. Easy :)
>
> Chris
> }:)
>
> > -Original Message-
> > From: nautilis [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, December 20, 2001 5:11 PM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-DB] MySQL date formats
> >
> > Hi everyone!
> >
> > I have a little problem with my MySQL database in the way it stores
dates.
> > The only format i can have is /MM/DD, and when i request this date
> > from
> > my php page, this date is insertes in this format. As my website is
going
> > to
> > be for spanish users, the correct format would be DD/MM/, but i have
> > no
> > idea about changing this, either on the database or when i process it
with
> > php.
> >
> > Thanks in advance for reading my post. I hope anyone can point me into
the
> > right direction.
> >
> > nautilis
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Checkboxes, PHP, and MySQL
Try this > Jim - Original Message - From: "SpyProductions Support Team" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 20, 2001 8:40 AM Subject: [PHP-DB] Checkboxes, PHP, and MySQL > > I've looked around in a few of the PHP lists for an answer to this, but > can't come up with one. > > Here's what I am doing: > > I have a form with a few checkboxes. > > When the information as to whether the checkboxes are checked or not is > 'saved' into the MySQL table, they are represented by a value of '1' - fine. > > When I want to edit this information, in the form of a similar form with > checkboxes, the boxes are not checked off if they were before. > > What I am stuck on is how a checkbox can get checked off when pulling > information from the MySQL as an array. > > Here's a line of code showing my array coming out. > > > > $result is the array. > > I guess what I am asking is that if a checkbox is assigned a value of one, > why doesn't it appear as already checked off? > > Thanks, > > -Mike > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Mysql result resource error
which one was giving you the problem? the first or second mysql try. if it
was the second, try wrapping the $cattyname with single quotes like this
Minor_Category = '$cattyname'. if the $cattyname var has anything but
numbers, the statement won't work.
Jim
- Original Message -
From: "Shannon Doyle" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 19, 2001 4:19 PM
Subject: [PHP-DB] Mysql result resource error
> Hi People,
>
> I am getting a Not a valid Mysql result resource error with the
> following code, can someone take a look at this for me and see if there
> is anything that stands out
>
> Thanks,
>
> Shannon
>
> $cattyname = "";
> $sql = "select Minor_Category main where Page = 'wines' order by
> Minor_Category";
> $dbh = @mysql_connect($dbhost,$dbuser,$dbpass);
> $results2 = mysql_db_query($db,$sql,$dbh);
> for($j = 0; $j < mysql_num_rows($results2); $j++) {
> $array[$j] = mysql_fetch_array($results2);
> }
> mysql_close($dbh);
> for ($h = 0; $h < count($array); $h++) {
>
> if ($array[$h]["Minor_Category"] != $cattyname) {
> $cattyname = $array[$h]["Minor_Category"];
> echo " name='".$cattyname."'>".$cattyname."";
>
>
> $catname = "";
> $sql = "select Category,Code,Description,Pack,Unit,Price from main where
> Page = 'wines' && Minor_Category = $cattyname order by Category";
> $dbh = @mysql_connect($dbhost,$dbuser,$dbpass);
> $results = mysql_db_query($db,$sql,$dbh);
> for($i = 0; $i < mysql_num_rows($results); $i++) {
> $array[$i] = mysql_fetch_array($results);
> }
> mysql_close($dbh);
>
> for ($i = 0; $i < count($array); $i++) {
>
> if ($array[$i]["Category"] != $catname) {
> $catname = $array[$i]["Category"];
> echo " name='".$catname."'>".$catname." align='center'>Carton Size align='center'>Unit align='right'>Price src='images/arrow.gif' border='0'>";
> }
>
> echo " href=javascript:order_now("".$array[$i]["Code"]."")> src='images/order.gif' border='0'> align='left'>".$array[$i]["Description"]." align='center'>".$array[$i]["Pack"]." align='center'>".$array[$i]["Unit"]." align='right'>$".$array[$i]["Price"]."\n";
> }
> }
> }
> ?>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Learning PHP Sessions
one problem I see, you are trying to populate the variable after you
register it.
session_start();
$myvar = "something";
session_register('myvar');
echo $myvar;
Jim Lucas
- Original Message -
From: "Russ Michell" <[EMAIL PROTECTED]>
To: "Steve Cayford" <[EMAIL PROTECTED]>
Cc: "Matthew Tedder" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 31, 2001 8:44 AM
Subject: Re: [PHP-DB] Learning PHP Sessions
>
> * session_register('myvar'); creates a session var called $myvar
> * session_start(); needs to be called from the top of each script that
will need the session var
> $myvar
> * session_destroy('myvar'); rids you of $myvar completely.
> * session_destroy('HTTP_SESSION_VARS'); rids you off *all* currently
registered session vars
>
> Note that a variable used in this way is refered to as 'myvar' and
referenced a snormal within the
> script as: $myvar
>
> HTH you out.
> Russ
>
> On Wed, 31 Oct 2001 09:55:33 -0600 Steve Cayford
<[EMAIL PROTECTED]> wrote:
>
> > This is really off-topic for this list, but...
> >
> > From my understanding of sessions, you really don't want
session_start()
> > in an if{} block. Every time you hit this script, it will have no memory
> > of any session variables until you call session_start().
> >
> > -Steve
> >
> > On Tuesday, October 30, 2001, at 02:30 PM, Matthew Tedder wrote:
> >
> > > > > /*
> > > Hi,
> > >
> > > I'm new to PHP and am having trouble understanding how to use PHP
> > > sessions. My book tells in near the beginning how to start them and
> > > register
> > > session variables, but I can't figure out how to destroy a session or
> > > later
> > > read those session variables. I'm also trying to do this across
> > > frames, but
> > > can't even get it to work within a single page.
> > >
> > > Here's what I've learned so far and what my problems are:
> > > */
> > >
> > > /* To start a session */
> > > session_start();
> > >
> > > /* To register a session variable */
> > > session_register("myvar");
> > > $myvar = "some value";
> > >
> > > /*
> > > PROBLEM #1: From the above commands, I get a $PHPSESSID that seems to
> > > be
> > > globally available for use, but I cannot seem to read my values back
> > > out of
> > > the registered session variable from anywhere... I tried:
> > > */
> > >
> > > print "$myvar\n"; /* and absolutely nothing is printed */
> > >
> > > /* To destroy a session */
> > > session_destroy();
> > >
> > > /*
> > > PROBLEM #2: This says there is no session to destroy. It's rather
> > > strange
> > > because I can still print the $PHPSESSID value..
> > >
> > > I've attached my code...
> > >
> > > */
> > > ?>
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail:
[EMAIL PROTECTED]
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
> #---#
>
> "Believe nothing - consider everything"
>
> Russ Michell
> Anglia Polytechnic University Webteam
> Room 1C 'The Eastings' East Road, Cambridge
>
> e: [EMAIL PROTECTED]
> w: www.apu.ac.uk/webteam
>
> www.theruss.com
>
> #---#
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] New users on mysql using php
go grab yourself a copy of phpmyadmin http://phpmyadmin.sourceforge.net/download.html jim - Original Message - From: "Harpreet" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 25, 2001 2:02 PM Subject: [PHP-DB] New users on mysql using php > I connect to mysql database using the following: > > $StrConnectionUser=mysql_connect(ipaddress,"$USER"); > mysql_select_db(database name, $StrConnectionUser); > > My question is how can I add new users to mysql using the web interface. > Like can i run the Grant and revoke (mysql commands) in my php page?? > > This way i can add or delete users that can have access to the mysql > database through the web. > I hope the above makes sense. > > Thanks, > Regards, > Harpreet Kaur > Software Developer > Crispin Corporations Inc. > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] array-problems
- Original Message -
From: "Jim Lucas" <[EMAIL PROTECTED]>
To: "Bart Verbeek" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 24, 2001 12:42 PM
Subject: Re: [PHP-DB] array-problems
> Try this:
>
> <<< BEGIN:PHP-CODE >>>
>
> $result = mysql_query ("SELECT DISTINCT date FROM linktracker WHERE name
> LIKE '$PHP_AUTH_USER' GROUP BY date ORDER BY date");
> if (mysql_num_rows($result))
> {
> for($i=0;$i {
> $date = array(
> "begin" => array($i => $row["date"]),
> "end" => array($i => $row["date"])
> );
> }
> } else {
> print ("Sorry, no record were found.");
> }
>
> function drawSelect($which)
> {
> global $date;
> foreach($date[$which] AS $date_begin)
> {
> ?>
>
>}
>
> }
>
> ?>
>
>
> Begindate
> Enddate
>
>
>
>
>
> drawSelect("begin");
> ?>
>
>
>
> rsort($date[end]);
>
> drawSelect("end");
> ?>
>
>
>
>
> value="Submit">
>
>
> <<< END:PHP-CODE >>>
>
> btw - you need to watch your closing '>' you are missing a few. Plus to
> get distince to work right you need to use the "GROUP BY" clause.
>
> Jim
>
> - Original Message -
> From: "Bart Verbeek" <[EMAIL PROTECTED]>
> To: "Php-General-list" <[EMAIL PROTECTED]>; "PHP-DB mailinglist"
> <[EMAIL PROTECTED]>
> Sent: Wednesday, October 24, 2001 12:23 PM
> Subject: [PHP-DB] array-problems
>
>
> > Hello,
> > Can anyone help me with this script I'm using?
> >
> > I've saved dates in a database and want to make two select-lists of
these
> > dates in a html-form.
> > I want to select each unique date one time (no doubles).
> > List 1 is used to set the begin-date of the query for the report, List 2
> > will
> > set the end-date and must be reversed.
> > When the form is processed the data selected between the begin-date and
> the
> > end-date has to be show.
> >
> > I can't seem to get my code to work: the select-lists stay empty after
> > processing the code below.
> >
> > Can anyone help? Tips...
> >
> > regards,
> >
> > Bart
> >
> >
> > <<< BEGIN:PHP-CODE >>>
> > $i=0;
> > $result = mysql_query ("SELECT DISTINCT date FROM linktracker WHERE
name
> > LIKE '$PHP_AUTH_USER' ORDER BY date");
> > if ($row = mysql_fetch_array($result)) {
> > do {
> > $date = array(
> > "begin" => array($i => $row["date"]),
> > "end" => array($i => $row["date"])
> > );
> > $i++;
> > } while ($row = mysql_fetch_array($result));
> > } else {print ("Sorry, no record were found.");
> > } //end else $result
> >
> > print("BegindateEnddate\n".
> > " > name=\"date_select\">".
> > " > value=\"date_select\">".
> > "");
> >
> > while (list($key, $date_begin) = each($date[begin])) {
> > echo "" . $date_begin .
> > "\n";
> > }
> >
> > print("");
> >
> > rsort($date[end]);
> >
> > while (list($key, $date_end) = each($date[end])) {
> > echo "" . $date_end .
> > "\n";
> > }
> >
> > print("\n".
> > "".
> > "");
> >
> > mysql_free_result ($result);
> > mysql_close();
> > <<< END:PHP-CODE >>>
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
