corillo181 Posted June 22, 2007 Share Posted June 22, 2007 hey i got a script that is kind opf like a calendar.. i know i can get the month name by using jd's functions, but is there a way to enter a interger and get the name of that day of the week? Quote Link to comment https://forums.phpfreaks.com/topic/56740-solved-name-of-weekday/ Share on other sites More sharing options...
corillo181 Posted June 22, 2007 Author Share Posted June 22, 2007 no answer? Quote Link to comment https://forums.phpfreaks.com/topic/56740-solved-name-of-weekday/#findComment-280279 Share on other sites More sharing options...
cooldude832 Posted June 22, 2007 Share Posted June 22, 2007 first don't be bumping your post. secondly yes    * d - The day of the month (from 01 to 31)   * D - A textual representation of a day (three letters)   * j - The day of the month without leading zeros (1 to 31)   * l (lowercase 'L') - A full textual representation of a day   * N - The ISO-8601 numeric representation of a day (1 for Monday through 7 for Sunday)   * S - The English ordinal suffix for the day of the month (2 characters st, nd, rd or th. Works well with j)   * w - A numeric representation of the day (0 for Sunday through 6 for Saturday)   * z - The day of the year (from 0 through 365)   * W - The ISO-8601 week number of year (weeks starting on Monday)   * F - A full textual representation of a month (January through December)   * m - A numeric representation of a month (from 01 to 12)   * M - A short textual representation of a month (three letters)   * n - A numeric representation of a month, without leading zeros (1 to 12)   * t - The number of days in the given month   * L - Whether it's a leap year (1 if it is a leap year, 0 otherwise)   * o - The ISO-8601 year number   * Y - A four digit representation of a year   * y - A two digit representation of a year   * a - Lowercase am or pm   * A - Uppercase AM or PM   * B - Swatch Internet time (000 to 999)   * g - 12-hour format of an hour (1 to 12)   * G - 24-hour format of an hour (0 to 23)   * h - 12-hour format of an hour (01 to 12)   * H - 24-hour format of an hour (00 to 23)   * i - Minutes with leading zeros (00 to 59)   * s - Seconds, with leading zeros (00 to 59)   * e - The timezone identifier (Examples: UTC, Atlantic/Azores)   * I (capital i) - Whether the date is in daylights savings time (1 if Daylight Savings Time, 0 otherwise)   * O - Difference to Greenwich time (GMT) in hours (Example: +0100)   * T - Timezone setting of the PHP machine (Examples: EST, MDT)   * Z - Timezone offset in seconds. The offset west of UTC is negative, and the offset east of UTC is positive (-43200 to 43200)   * c - The ISO-8601 date (e.g. 2004-02-12T15:19:21+00:00)   * r - The RFC 2822 formatted date (e.g. Thu, 21 Dec 2000 16:01:07 +0200)   * U - The seconds since the Unix Epoch (January 1 1970 00:00:00 GMT)   those are all the parameters so you can say date(i:s) and it gives you the time in minutes/seconds Quote Link to comment https://forums.phpfreaks.com/topic/56740-solved-name-of-weekday/#findComment-280281 Share on other sites More sharing options...
corillo181 Posted June 22, 2007 Author Share Posted June 22, 2007 let me explain my self better...  i have 3 mysql fields..                          | year | month | day | now below some has enter an chosen a date        any| year | month | day |  i can find the month name using jdnameofthemonth  but to find the name of the day such as Saturday or Tuesday  is that possible? Quote Link to comment https://forums.phpfreaks.com/topic/56740-solved-name-of-weekday/#findComment-280289 Share on other sites More sharing options...
cooldude832 Posted June 22, 2007 Share Posted June 22, 2007 yes if you say $madedate = mkdate($mysqldatefieldscombined) then say $dayofweek =Â date(D,$madedate); all you have to do is use the DOM and make it thing the day is what ever day you want and do those two lines. Quote Link to comment https://forums.phpfreaks.com/topic/56740-solved-name-of-weekday/#findComment-280293 Share on other sites More sharing options...
chigley Posted June 22, 2007 Share Posted June 22, 2007 I really don't understand your question. Post a proper dummy table with field names and a few example rows, then tell us what you need please. Quote Link to comment https://forums.phpfreaks.com/topic/56740-solved-name-of-weekday/#findComment-280298 Share on other sites More sharing options...
corillo181 Posted June 22, 2007 Author Share Posted June 22, 2007 year month day 200766 2008220 thats my table.. $getDate=mysql_query("SELECT * FROM tableDate"); $Array=$mysql_fetch_array($getDate); $array['Month'] / $array['Day'] / $array['Year']  now if i want the name of the month all i need to do is;  jdnameofmonth($year,$month);  to get the name of the day..  how i do that?  how do i change the day number into a day name..  from 6 to what ever the day is..  could be sat.. mon...tueday.. how do i find that out if is possible. Quote Link to comment https://forums.phpfreaks.com/topic/56740-solved-name-of-weekday/#findComment-280325 Share on other sites More sharing options...
cooldude832 Posted June 22, 2007 Share Posted June 22, 2007 okay lets try this: <?php $getDate=mysql_query("SELECT * FROM tableDate"); while( $row= mysql_fetch_array($numresults)) { $date[$i]['year'] = $row['year']; $date[$i]['month'] = $row['month']; $date[$i]['day'] = $row['day']; $date[$i]['dayofweek'] = date("D",mktime(0,0,0,$row['month'],$row['day'],$row['year'])); $i++; } foreach ($date as $value) { echo "<br/>".$value['day']."/".$value['month']."/".$value['year']." is a ".$value['dayofweek']; } ?> Â Quote Link to comment https://forums.phpfreaks.com/topic/56740-solved-name-of-weekday/#findComment-280337 Share on other sites More sharing options...
chigley Posted June 22, 2007 Share Posted June 22, 2007 <?php $query = mysql_query("SELECT day, month, year FROM tableDate") or die(mysql_error()); while(list($day, $month, $year) = mysql_fetch_row($query)) { $timestamp = mktime(0, 0, 0, $month, $day, $year); $date = date("l", $timestamp); echo "{$day}/{$month}/{$year} was a {$date}<br />\n"; } ?> Â Untested. Quote Link to comment https://forums.phpfreaks.com/topic/56740-solved-name-of-weekday/#findComment-280340 Share on other sites More sharing options...
cooldude832 Posted June 22, 2007 Share Posted June 22, 2007 same as mine the lower case "l" gives full text days the "D" gives a 3 letter version read the list of params i gave you to pick what you need Quote Link to comment https://forums.phpfreaks.com/topic/56740-solved-name-of-weekday/#findComment-280343 Share on other sites More sharing options...
chigley Posted June 22, 2007 Share Posted June 22, 2007 Mine's faster though Quote Link to comment https://forums.phpfreaks.com/topic/56740-solved-name-of-weekday/#findComment-280348 Share on other sites More sharing options...
cooldude832 Posted June 22, 2007 Share Posted June 22, 2007 not really only because a script is shorter in length does not mean its faster, many defined functions like list() execute a lot more lines of code than you think it does Quote Link to comment https://forums.phpfreaks.com/topic/56740-solved-name-of-weekday/#findComment-280352 Share on other sites More sharing options...
chigley Posted June 22, 2007 Share Posted June 22, 2007 Trust me.. mine's faster Quote Link to comment https://forums.phpfreaks.com/topic/56740-solved-name-of-weekday/#findComment-280355 Share on other sites More sharing options...
corillo181 Posted June 22, 2007 Author Share Posted June 22, 2007 both work fine.. thanx guys. Quote Link to comment https://forums.phpfreaks.com/topic/56740-solved-name-of-weekday/#findComment-280357 Share on other sites More sharing options...
cooldude832 Posted June 22, 2007 Share Posted June 22, 2007 its doing the same thing say declaring each individually i don't see the speed difference list() does that same exact thing Quote Link to comment https://forums.phpfreaks.com/topic/56740-solved-name-of-weekday/#findComment-280361 Share on other sites More sharing options...
chigley Posted June 22, 2007 Share Posted June 22, 2007 mysql_fetch_array() takes longer, as it fetches effectively twice the data than required; and if any more fields are added to the table later, your code will still SELECT * which is also pointless Quote Link to comment https://forums.phpfreaks.com/topic/56740-solved-name-of-weekday/#findComment-280363 Share on other sites More sharing options...
cooldude832 Posted June 22, 2007 Share Posted June 22, 2007 yeah well i didn't know if the query results was to be used differently, i thought you where arguing between the function list() i know the * slows it down Quote Link to comment https://forums.phpfreaks.com/topic/56740-solved-name-of-weekday/#findComment-280366 Share on other sites More sharing options...
Wildbug Posted June 22, 2007 Share Posted June 22, 2007 A) Why are you using three columns for a date when you could be using a DATE column? Â B) Why not just use an SQL query to find the day? Â SELECT DAYNAME(CONCAT(yearcol,monthcol,daycol)) FROM table Quote Link to comment https://forums.phpfreaks.com/topic/56740-solved-name-of-weekday/#findComment-280380 Share on other sites More sharing options...
corillo181 Posted June 22, 2007 Author Share Posted June 22, 2007 come to think of it now that i see i can use date and mktime to bring out the year or month or day by it self i don't really know why. Quote Link to comment https://forums.phpfreaks.com/topic/56740-solved-name-of-weekday/#findComment-280388 Share on other sites More sharing options...
corillo181 Posted June 22, 2007 Author Share Posted June 22, 2007 but what would be the best format to insert date and retrieve it? Quote Link to comment https://forums.phpfreaks.com/topic/56740-solved-name-of-weekday/#findComment-280397 Share on other sites More sharing options...
chigley Posted June 22, 2007 Share Posted June 22, 2007 Read this: http://www.phpfreaks.com/forums/index.php/topic,146364.0.html Quote Link to comment https://forums.phpfreaks.com/topic/56740-solved-name-of-weekday/#findComment-280399 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.