PHP - Selecting Members Who's Birthday Is In The Next Month

im trying to generate a birthday list for people who have birthdays today. Unfortunatly it keeps coming up 0 when there are birthdays today. here is the query:

$birthday_query = $link->query("SELECT u.u_username, u.u_birthday
                    FROM ".TBL_PREFIX."users u
                    WHERE u.u_banned = '0'
                    AND u_confirmed = '1'
                    AND u_birthday LIKE '" . $link->asf_escape(sprintf('%2d-%2d-', $now['mday'], $now['mon'])) . "%'
                    ORDER BY u_username ASC");

the query string is:

Code: [Select]
SELECT u.u_username, u.u_birthday               FROM asf_users u               WHERE u.u_banned = '0'               AND u_confirmed = '1'               AND u_birthday LIKE '25- 1-%'               ORDER BY u_username ASC
there is a birthday in the database which appears like:

Code: [Select]
25-1-1986
but it still says no birthdays.

any ideas?

and yes the user is confirmed and not banned.

friend i store dob as 12/17/1984 in my table now how do i go on geting users birthday if today is 12/16 how could i display only the mm/dd from table?   i tried  

$today = date("m-d");
$result = mysql_query("SELECT * FROM members WHERE dob = '".$today."'");

  but not happening

Hi Hello

I have a problem with this code, I need to make a simple calendar with birthday reminder but it is not working. I just created two variables ($BirthdayMonth and $DayBirthday) but when I add the day, I need this variable ($DayBirthday) to be static, the problem is when I change to another month then the variable $DayBirthday would be changed. Here is the source code:

<?php
$monthNames = Array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
if (!isset($_REQUEST["month"])) $_REQUEST["month"] = date("n");
if (!isset($_REQUEST["year"])) $_REQUEST["year"] = date("Y");

$cMonth = $_REQUEST["month"];
$cYear = $_REQUEST["year"];
$prev_year = $cYear;
$next_year = $cYear;

$prev_month = $cMonth-1;
$next_month = $cMonth+1;

if ($prev_month == 0 ) {
$prev_month = 12;
$prev_year = $cYear - 1;
}
if ($next_month == 13 ) {
$next_month = 1;
$next_year = $cYear + 1;
}
?>
<div id="calendar_div" name="calendar_div">
<table width="200">
<tr align="center">
<td bgcolor="#999999" style="color:#FFFFFF">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="50%" align="left">&nbsp;&nbsp;<a href="<?php echo $_SERVER["PHP_SELF"] . "?month=". $prev_month . "&year=" . $prev_year; ?>" style="color:#FFFFFF">Previous</a></td>
<td width="50%" align="right"><a href="<?php echo $_SERVER["PHP_SELF"] . "?month=". $next_month . "&year=" . $next_year; ?>" style="color:#FFFFFF">Next</a>&nbsp;&nbsp;</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="center">
<table width="100%" border="0" cellpadding="2" cellspacing="2">
<tr align="center">
<td colspan="7" bgcolor="#999999" style="color:#FFFFFF"><strong><?php echo $monthNames[$cMonth-1].' '.$cYear; ?></strong></td>
</tr>
<tr>
<td align="center" bgcolor="#999999" style="color:#FFFFFF"><strong>S</strong></td>
<td align="center" bgcolor="#999999" style="color:#FFFFFF"><strong>M</strong></td>
<td align="center" bgcolor="#999999" style="color:#FFFFFF"><strong>T</strong></td>
<td align="center" bgcolor="#999999" style="color:#FFFFFF"><strong>W</strong></td>
<td align="center" bgcolor="#999999" style="color:#FFFFFF"><strong>T</strong></td>
<td align="center" bgcolor="#999999" style="color:#FFFFFF"><strong>F</strong></td>
<td align="center" bgcolor="#999999" style="color:#FFFFFF"><strong>S</strong></td>
</tr>

<?php
$timestamp = mktime(0,0,0,$cMonth,1,$cYear);
$maxday = date("t",$timestamp);
$thismonth = getdate ($timestamp);
$startday = $thismonth['wday'];
$BirthdayMonth = "February";
$DayBirthday = 12;
for ($i=0; $i<($maxday+$startday); $i++) {
if(($i % 7) == 0 ) echo "<tr>\n";
if(($i == $DayBirthday)) {
echo "<td bgcolor='#0000FF' align='center' valign='middle' height='20px'>".($i - $startday + 1) ."</td>\n";
} elseif($i < $startday) {
echo "<td></td>\n";
}
else {echo "<td align='center' valign='middle' height='20px'>". ($i - $startday + 1) . "</td>\n";
}
if(($i % 7) == 6 ) echo "</tr>\n";
}
echo "</br>";
echo "</br>";
echo $startday;
echo $thismonth
?>
</table>
</td>
</tr>
</table>
</div>

Where Am I failing or where is the problem ?

Code: [Select]
<?php 

"INSERT INTO costumers
(firstname,lastname,birthdate,product_name,price,details,category,subcategory,city,state,zipcode,country)            VALUES('$fname','$lname','$birthday','$itemname','$price','$details','$category','$subcategory','$city','$state','$zipcode','$country')";
?>


What am I missing in the INSERT query above that is not inserting the values of birthday.?

Hello

I have a mysql database with users and birthday.
I'd like to set a cronjob to send an e-mail on the aniversary of each one.
Can i do a script in php and the cron job execute it?
If not how can i do this? Anyone can help?

THanks

Before I go digging around for code or conversion to unix time stamp, I'm curious how many of you have a birthday entry on a form which is the least hassle for the person filling out the form. For example

a text box and they can enter 12/1/1992 or 12/1/92 or 12-1-1992

or three text boxes for month, day and year and if so, require an 01 or a 08 or 4 characters for year.

The second method with three boxes would easily convert to a date stamp entry on the other hand if there is a php conversion that would convert any format (12/1/1992, 12/01/92, etc) to a unix time stamp that would make it easier for the person filling out the form.

Thanks in advance for any ideas or help.
Mike

I created a field in "b_users" table as "banned" with default value="no". i.e, all members by default are set to "banned"="no". I was testing this code in my some pages to ban member and prevent access to my pages:

$getid="SELECT * from b_users where id='$user_id'";
if($getid[banned]=="yes")
 {
  die("<center>You have been banned from posting</center>");
 } 
else
{
show page
Above code is banning all members. But i want to show ban message to members who's "banned" field value is set to "yes" only. How to do that?

Hi Guys,

I was wondering how I could wrap my members page so that only 5 members appear at a time and you have to click the next button to go onto the next page. Here is the current code. Code: [Select]
$userid = $_SESSION['userid'];

$query = "SELECT username, first_name, last_name, password, email, dob, mob, yob, year, gender FROM spotty WHERE user_id = '" . $userid . "'";

$query2 = "SELECT user_id FROM spotty WHERE user_id = '" . $userid . "'";

$result = mysql_query($query) or die('Error Getting Information Requested');

$result2 = mysql_query($query2) or die('Error Getting user_id');

$row = mysql_fetch_array($result);

$row2 = mysql_fetch_array($result2);

//$result = mysql_query($query);

$num = mysql_num_rows($result2);
$username = $row['username'] ;


if($_SESSION['userid'] == NULL)
{
echo "Sorry, wrong username or password. You will be redirected in 5 seconds.";
echo "<meta http-equiv='refresh' content='7;url=http://www.klueless.net/daisysite'>";
}
else
{
echo "Members.";
echo "<br />";

$membsquery="SELECT * FROM spotty WHERE showmem = '0'";
$membs=mysql_query($membsquery);

$num=mysql_numrows($membs);
$membresult = mysql_result($membs,$i,"user_id");
$useridname = $membresult['username'];


echo "<br /> <br />" ;

echo "<table border='0' cellspacing='2' cellpadding='2'> <tr>
<font face='Comic Sans MS, cursive'>Click on a username to see their profile.</font>
<br />
<br />
</tr>";

$i = 0;
while ($i < $num) {


$f1 = "<font face='Verdana, Geneva, sans-serif'><a href='profile.php?id=" . mysql_result($membs,$i,"user_id") . "'>" . mysql_result($membs,$i,"username") . "</a><br /><br />";


echo "<tr>
<td>" .  $f1 ."</font></td>
</tr>
</table>" ;
$i++;
}
}

mysql_close()


?>
Thanks in advance! 

Hi guys,

Im trying to get my members_profile.php to display the users profile....

I.e members_profile.php?boxerman will display my information.

I've been at it for hours but no luck...

This is what im trying to code:

<?php
include ("connect.php")

$username = $_GET['username'];
$user = mysql_query("SELECT * FROM user WHERE username = '$username'");
$user=mysql_fetch_assoc($user);

echo "<h1>User Info</h1>";

echo "<b>Username:".$user['username']."<br>";

echo "<br>";
  echo '<form name="backlistfrm" method="post" action="members.php">';
echo '<input type="submit" value="Back to The List">';
echo '</form>';
echo "<br>";

?>

It displays nothing when going to members_profile.php?boxerman

Any advice as to why?

Regards,

B-Man

i been working on my view Members page for a while now i can't seem to get it to work right

this is how i shows up for me


and i want it to show up like this


i think it has something to do with the loop, but have no idea how to fix this :S



<?php
require_once('settings.php');
checkLogin('1 2');


$Members = mysql_query("SELECT * FROM users") or die(mysql_error());

$numRowsMembers = mysql_num_rows($Members);
?>

<?php
for($count = 1; $count <= $numRowsMembers; $count++)
{
    $name = mysql_fetch_array($Members);


?>
<table border=2>
<tr><td><img src="<? echo $name['main_P']?>" width="50" height="50"/>
<a href="view_profile.php?username=<? echo $name['Username']?>"><? echo $name['Username']?></a>

<?

$onlinestatus = $name['ON_OFF'];

if ( $onlinestatus == OFFLINE ) {
echo "";
} else {
echo "<font color=green>Online Now!</font>";
}
?>

</td></tr></table>

<?
}
?>

$_GET["find"] displays all users including the current user. The current user should not be displayed.

I would like to display members that are NOT friends with the current user. Do I need to join the tables to make this work?

$_GET["add"] inserts "screen_name" into "member and friendwith"

Code: [Select]
<?php
if(isset($_GET["find"]))
 {
$username = $_POST["screen_name"];
$query = "SELECT * FROM users WHERE screen_name LIKE '%$username%'";
$result = mysql_query($query);
$exist = mysql_num_rows($result); 
if($exist=='0')
{
 echo "No match found";
}
else 
{
 echo "Matches for search: $username<br>";
 while($currow = mysql_fetch_array($result))
 {
 ?>
<a href="users/member?addfriend=<?php echo $currow['screen_name']; ?>"><img src="avatars/<?php echo $currow["image"]; ?>" ></a>
<?php
 }
}
 }
 
 if(isset($_GET["add"]))
 { 
$username = $_SESSION["screen_name"];
$friend = $_GET["add"];
$query = "SELECT * FROM friends WHERE member='$username' AND friendwith='$friend'";
$result = mysql_query($query);
$exist = mysql_num_rows($result); 
if($exist=='0')
{
 $query = "INSERT INTO friends(member,friendwith) VALUES('$username','$friend')";
 mysql_query($query);
 echo "$friend is now your friend!";
}
else 
{
 echo "$friend is already your friend!";
} 
 }
?>

hey guys, im new to PHP and im trying to use a login script that allows users to register and login to my site from my database.

on my login/register pages i get this error

Warning: mysql_pconnect() [function.mysql-pconnect]: Unknown MySQL server host 'host' (1) in /home/hullcale/public_html/dbConfig.php on line 12
Error connecting to database.
Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user 'hullcale'@'localhost' (using password: NO) in /home/hullcale/public_html/dbConfig.php on line 20

Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /home/hullcale/public_html/dbConfig.php on line 20


it seems like al my problems are from my page dbConfig.php on line 12 and 20, problem is i dont know how to edit them, here is the code from that page...

things you may need to know is my databse is called hullcale_database, user is Admin, password is password, as for host im not actually sure where i get this from? any tips?!

<?
// Replace the variable values below
// with your specific database information.
$host = "localhost";
$user = "UserName";
$pass = "Password";
$db = "dbName";

// This part sets up the connection to the
// database (so you don't need to reopen the connection
// again on the same page).
$ms = mysql_pconnect(host, $user, $pass);
if ( !$ms )
{
echo "Error connecting to database.\n";
}

// Then you need to make sure the database you want
// is selected.
mysql_select_db($db);
?>

I'm using 3 files to try and mass mail my members, massmail.php massmail-exe.php and elist.php

massmail.php

<form name="massmail" method="post" action="./massmail-exe.php">
<table width="450px">
<tr>
 <td valign="top">
  <label for="subject">Subject</label>
 </td>
 <td valign="top">
  <input type="text" name="subject" maxlength="50" size="30" id="subject">
 </td>
</tr>
<tr>
 <td valign="top">
  <label for="message">Email Content</label>
 </td>
 <td valign="top">
  <textarea  name="message" maxlength="9001" cols="100" rows="18" id="message"></textarea>
 </td>

</tr>
<tr>
 <td colspan="2" style="text-align:center">
  <input type="submit" value="Submit">
 </td>
</tr>
</table>
</form>


massmail-exe.php

<?php
// read the list of emails from the file.
$email_list = file("./elist.php");

// count how many emails there are.
$total_emails = count($email_list);

// go through the list and trim off the newline character.
for ($counter=0; $counter<$total_emails; $counter++) {
   $email_list[$counter] = trim($email_list[$counter]);
   }

// implode the list into a single variable, put commas in, apply as $to value.
$to = implode(",",$email_list);

if ( mail($to,$_POST["subject"],$_POST["message"]) ) {
   echo "The email has been sent!";
   } else {
   echo "The email has failed!";
   }
?>



and elist.php which has the email addresses.



What is wrong because every time i try and send it it say query failed.

Thanks so much.

Let me make this clear really quick, I am not talking about this forum.  Ok, so how do I set up a way that I can make a simple messaging system on my website and make it so that I can have check boxes of who I can send a message to on my website.  I have a recipient field and I need to know how I can make it so that only the specific members that are checked will get the message.........does this make sense?

Hi, Im getting better at this php lark!
ok so now I have a signup website page, all details get added to the database including an email address, all works fine.

now I would like a page, with a simple text box, that when you hit submit, it send the contents of the text box to all email address` in the members table, a really really simple newsletter so to speak. Its purely for my learning curve and Ill set up recapacha on it anyway.

but Im getting a bit lost in the code, could someone guide me please? I can grab the contents of the text box like this:

$letter     = $_POST['letter];

but how do I send to all recipients?
$recipient = ("SELECT email FROM members");

thanks