Cursuri online, tutoriale, jocuri si anime - gratuite
https://marplo.net/forum/
Cod: Selectaţi tot
<?php
require 'connectme.php';
mysql_select_db('birthdays') or die('Could not select birthdays');
$month=date("m");
$day=date("d");
$n=15;
$unixtime= mktime (0,0,0, $month, $day);
$month_next = date("m","d"+time()+$n*24*3600);
$day_next = date("d", time()+$n*24*3600);
$next= mktime (0,0,0, $month_next, $day_next);
$query = mysql_query("SELECT * FROM birthtable WHERE DAY_MONTH
BETWEEN $unixtime AND $next ORDER BY DAY_MONTH ASC ")or die
(mysql_error());
echo "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "\t<tr>\n";
foreach ($line as $col_value) {
echo "\t\t<td>$col_value</td>\n";
}
echo "\t</tr>\n";
}
echo "</table>\n";
mysql_free_result($result);
?>Cod: Selectaţi tot
<html>
<head>
<title>Birthday List</title>
<script type="text/javascript">
//the bday array data can be generated from server-side
var arrBday = [
['John Doe', '14/7'],
['John Doe1', '5/31'],
['John Doe2', '5/30'],
['John Doe3', '5/28'],
['John Doe4', '5/27'],
['John Doe5', '5/18'],
['John Doe6', '5/20'],
['John Doe7', '5/19']
//...and so on (last entry must not have a trailing comma)
];
function getBdaysThisWeek(){
var arrMonth = new Array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
var bday, idx;
var bdayList = new Array();
var today = new Date();
for (var i=0;i<arrBday.length;i++){
var bday = new Date(arrBday[i][1] + '/' + today.getFullYear());
if (isNaN(bday)) continue;
if ( isBdayInRange(bday, 7) ){
idx = bdayList.length;
bdayList[idx] = new Object();
bdayList[idx].name = arrBday[i][0];
bdayList[idx].bday = bday;
bdayList[idx].month = arrMonth[bday.getMonth()];
}
}
if (bdayList.length > 0){ //sort asc by birthdate
bdayList.sort(
function(a, b){
if (a.bday < b.bday) return -1
if (a.bday > b.bday) return 1;
return 0;
}
);
}
return bdayList;
}
function isBdayInRange(bday, interval){
//credit for this function goes to:
//-Rob (@slingfive) Eberhardt, Slingshot Solutions
//http://slingfive.com/pages/code/jsDate/jsDate.html
var today = new Date();
//have to override time so entire day will be valid
today.setHours(0,0,0,0);
//if the birthday has already occurred in the year, increment to the next year
if (bday < today)
bday.setFullYear(bday.getFullYear() + 1);
// get ms between dates (UTC) and make into "difference" date
var iDiffMS = bday.valueOf() - today.valueOf();
//divide iDiffMS by 1000, Seconds, Minutes, Hours
nDays = parseInt(iDiffMS / 1000 / 60 / 60 / 24);
if(parseInt(nDays) <= parseInt(interval))
return true;
else
return false;
}
function displayBdayList(){
var date = new Date().getDate();
var bdayList = getBdaysThisWeek();
var len = bdayList.length;
var s = "<h1>Birthday Celebrants for this week:</h1>";
if (len>0){
s += '<ul>';
for (var i=0; i<len; i++){
//be mindful of the string-line continuation character (\) at the end of the first line
s += '<li' + ((date == bdayList[i].bday.getDate())?' class="bdayToday"':'')+ '>\
<strong>' + bdayList[i].name + '</strong> - '
+ bdayList[i].month + ' ' + bdayList[i].bday.getDate() + '</li>';
}
s += '</ul>';
}
else{
s += "No birthday celebrant for this week.";
}
document.write(s);
}
</script>
<style type="text/css">
body {
font:14px Verdana;
}
/*display style when bday is today*/
.bdayToday {
color: red;
}
</style>
</head>
<body>
<script type="text/javascript">
displayBdayList();
</script>
</body>
</html>Cod: Selectaţi tot
<?php
// Formezi data la fel cum e bagata in mysql (de ex.: numar_zi-numar_luna-an)
$data_azi = date('j-m-');
// Se face cautare in baza de date si se preia numele unde data adaugata incepe cu $data_azi;
?>
Cod: Selectaţi tot
<?php
require_once('conectare.php');
$data = date('j-m-Y);
$sql = "SELECT `mesaj` FROM `verset` WHERE `data`='$data' LIMIT 1";
$rezultat = mysql_query($sql);
if (mysql_num_rows($rezultat) == 0) {
$mesaj = 'Nici o zi de nastere';
}
else {
$i=0;
while ($i < $rezultat) {
$rand=mysql_fetch_array($resultat);
$mesaj = $rand['mesaj'];
++$i;
}
}
echo $mesaj;
?> Cod: Selectaţi tot
<?php
$data = date('j-m'); // am eliminat "Y"
$sql = "SELECT * FROM `members` WHERE `data`='$data' ";
$rezultat = mysql_query($sql);
if (mysql_num_rows($rezultat) == 0) {
echo 'Astazi nu este ziua nimanui';
}
else {
echo 'Astazi este ziua lui: ';
$i=0;
while ($i < $rezultat) {
$rand=mysql_fetch_array($rezultat);
echo ' '.$rand['nume'].' '.$rand['prenume'].' ';
++$i;
}
}
?>