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? 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? 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 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? 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. 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. 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. 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']; } ?> 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. 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 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 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 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 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. 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 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 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 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 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. 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? 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 Link to comment https://forums.phpfreaks.com/topic/56740-solved-name-of-weekday/#findComment-280399 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.