Help with data from db

phpbuild12

Hey, I need some help with PhpMyadmin and PHP. So I have my users birthday date stored in database in format of Y-M-D. Now how do I take that date and add -1 week to it, so I can use it in my PHP code? 🙂

bradgrafelman

SELECT dateCol - INTERVAL 1 WEEK
FROM myTable

phpbuild12

Ok, thanks. Do I put that in the same query where I get all other info?

So would that be correct: mysql_query('SELECT Number, Name, Password, birthday - INTERVAL 1 WEEK FROM users1'

phpbuild12

Ok, maybe my questions is confusing, let me ask again in a different way.

So I have a database with peoples birthday stored in in a fromat of Y-m-d ( 2000-10-10 ). So I need to get each users birthday and 1 week before birthday (so I can send them an email 1 week before birthday). So what would be the best way to do it?

phpbuild12

Hello, this is really a newbie questions, I actually did that already but right now Im confused. So how do I create a loop where text is displayed and then each set of text gets its own link?

Example:

<a href="chocolate.php">Chocolate</a>
<a href="Banana.php">Banana</a>
<a href="Apple.php">Apple</a>

But I dont have those items specified.

phpbuild12

Hello, I have another question.

Right now I have a list of people where each person has their own unique number. Now I am using a loop to display them all, and what I need now is to be able to click on each and then open a new window where I get their info, so I can display stuff based on person I clicked. I hope its written clearly what I need 🙂

Weedpacket

phpbuild12 wrote:
But I dont have those items specified.

Well, you need to do that before you can loop over them.

phpbuild12

Well its inside loop. I have a list of users, and I would like to make it so if I click on a specific user that I get a new window opened with info of the user I clicked.

Derokorian

Do this (you'll have to modify for your needs):

foreach( $users as $id => $user ) {
   echo "<a href='userprofile.php?id=$id' target='_blank'>$user</a><br>\n";
}

of course that assuming you have an ID as the array key, and the username as the array value. You haven't given enough information to determine the data you have and how to work with it. HTH

phpbuild12

Ohh yes, sorry. So what I have right now...

Got user info from DB using fetch_assoc (name, surname, phone, email, birthday) and saved them in variables. Now as far as I know I cant directly use foreach loop there, or can I?

phpbuild12

Hello, its me again. I have a task that I have to complete untill today, and it is something like that..

Ok, so I have a database with peoples info (Unique number, Name, Surname, Email and Birth date).
I need to create a script which will display users who have a birthday in 1 week.
Then I must be able to click on one, get a new window up with all their info, where I also can send them a birthday email.

So that is it, I would really appreciate any kind of help 🙂

bradgrafelman

Step 1. Stop creating numerous threads that all center around the same issue. It's annoying.

Step 2. Read (and comprehend) the responses from your other threads created for the same issue (e.g. Help with data from db and Linking in loop).

Step 3. Combine them into a single solution that meets your needs.

Step 4. There is no step 4.

bradgrafelman

phpbuild12;11018103 wrote:
I have a database with peoples birthday stored in in a fromat of Y-m-d ( 2000-10-10 ).

The format of the date isn't nearly as important as the format of the data. In other words, is the column where you store the birthday of type DATE? That's all we need to know (since the YYYY-MM-DD representation of the date is a consequence of the proper column type, DATE, being used).

phpbuild12;11018103 wrote:
I need to get each users birthday and 1 week before birthday (so I can send them an email 1 week before birthday).

Is this query going to be inside a PHP script that is executed once every day? In other words, do you actually care what the (birthday minus one week) date really is, other than answering the question "Is it today?" If not, then it sounds like you simply need to SELECT the birthday itself, and add a WHERE clause that only selects rows where the (date column minus one week) is equal to the current date.

If that's not the case, then I'd be curious as to what you're doing with the information? Regardless, you'd simply want to SELECT both the date column as well as the (date column minus one week) values. You'll probably want to alias the latter (and perhaps the former as well) to make it easier/cleaner to reference the data in PHP.

bradgrafelman

phpbuild12;11018157 wrote:
Got user info from DB using fetch_assoc (name, surname, phone, email, birthday) and saved them in variables.

Why do you save the information? Why not use it as you process each row? In other words, can you not do all of the processing you need (including outputting a link) inside the loop that processes the SQL result set?

If not...

phpbuild12;11018157 wrote:
Now as far as I know I cant directly use foreach loop there, or can I?

You can "directly" (whatever that means) use a foreach() loop on any array (or iterable object). So the only reason you wouldn't be able to use the foreach() loop as in Derokorian's example above would be if you weren't storing the data in a sensible manner (e.g. inside an array).

bradgrafelman

Step 1. Stop creating numerous threads that all center around the same issue. It's annoying.

Step 2. Read (and comprehend) the responses from your other threads created for the same issue (e.g. Help with data from db and Linking in loop).

Step 3. Combine them into a single solution that meets your needs.

Step 4. There is no step 4.

Weedpacket

bradgrafelman wrote:
Step 1. Stop creating numerous threads that all center around the same issue. It's annoying.

Cross-posted threads merged.

phpbuild12

Ok, now I am really lost...

Here is my code so far...

if( $db_select_users = mysql_query("SELECT Unique, Surname, Name, Email, Birth FROM people
" ) )
{

$date_today = date('Y-m-d');
echo 'Date: '.$date_today.'<br />--------------------------------<br /><br />';

$user_info = mysql_fetch_assoc($db_select_users);

while($user_info = mysql_fetch_assoc($db_select_users)) {

	$unique = $user_info['Unique'];
	$name = $user_info['Name'];
	$surname = $user_info['Surname'];
	$birth = $user_info['Birth'];
	$email = $user_info['Email'];

	echo 
	'<strong> Unique number: </strong>'.$unique.' '.
	'<strong>Name: </strong>'.$name.' '.
	'<strong>Surname: </strong>'.$surname.' '.
	'<strong>BD: </strong>'.$birth.' '.
	'<strong>Email: </strong>'.$email.' ';

Now I want to be able to click on each user and have unique page for each or something where I can send a unique email for each.