PHP - Retrieving Date/time From Database

How to output a MySQL timestamp field to correct local time with daylight saving with PHP?   Local time is set in php.ini with: date.timezone = "Europe/London"   Confirmed set with:   <?php echo date_default_timezone_get(); ?>   But when I echo the timestamp field it does not display correct UK time for the record (an hour behind correct UK time).   <?php echo date('jS F Y - g:ia', strtotime($row['Date'])); ?>  

Code: [Select]
$query = mysql_query("SELECT a.*, b.*
         FROM friendlist a
INNER JOIN friendlist b
ON (a.friendemail=b.friendemail)
INNER JOIN users c
ON (b.friendemail = c.EmailAddress)
WHERE a.email = 'asdf@gmail.com'
AND c.Username LIKE '%carol%'
GROUP BY a.id
ORDER BY count(*) DESC");
Code: [Select]
while ($showfriends = mysql_fetch_array($query)) {
     echo $showfriends['Username'];
}
and I would get nothing. It produces the correct number of <div> so i know it's getting through, but it's having trouble displaying the entries?

Hey all,
I've written a php search feature for a mysql database. The search returns a file name like sample.gif, how would I go about displaying the actual image instead? Since the images all have the same location could I have the search return the string into a variable then make the whole thing a link? Thanks.

I am having a problem with PHP displaying the correct date and time. It updates as it should, but is fast by 4min and is always displaying a date in 2004. I ran a basic php script to make sure the application im using itself is not wrong. go to lunenburgledger.com/time.php

Anybody had any ideas on where to check? The system time on the Windows Server 2003 is correct. The only thing I can think of is that it was converted to a virtual machine on vmware esxi, but the system time stayed right. Any ideas?

Thanks!

OK So I've got a datepicker that sends a date in d/m/y format. My DB stores the data in Unix Timestamp Which I can convert the date to with strtotime however this does the exact date & time.

All I want is the actual day. I've spent hours trying to convert this with just the day with mixed results...

Thanks.

I have two tables.

Table Name:Users

Fields:

User_name
user_email
user_level
pwd


2.Reference

Fields:

refid
username
origin
destination

user_name in the users table and the username field in reference fields are common fields.



There is user order form.whenever an user places an order, refid field in reference table will be updated.So the user will be
provided with an refid

Steps:

1.User needs to log in with a valid user id and pwd
2.Once logged in, there will be search, where the user will input the refid which has been provided to him during the time of order placement.
3.Now User is able to view all the details for any refid
3.Up to this we have completed.

Query:

Now we need to retrieve the details based on the user logged in.

For eg: user 'USER A' has been provided with the referenceid '1234' during the time of order placement
        user 'USER B' has been provided with the referenceid '2468' during the time of order placement

When the userA login and enter the refid as '2468' he should not get any details.He should get details only for the reference ids which is assigned to him.

Hello people, currently i ran into some problem.

Currently, i have a database called responses which have the fields of ID, Student_id, question_id, Answer.

I had stored my results into the database which appeared to be           1       1                  1             Agree
                                                                                                                 2       1                  2            Disagree
                                                                                                                 3        3                 4             Unsatisfied.

So any recommendation on how should i do about in generating the result into a graph whereby the graph will show how many students choose "AGree" on that particular question THANKS

I am working on a kind of CMS for my own website which no one else will be using but me as a way of improving my php skills, and am having problems with retrieving data from the database that holds both text and php code. I have searched the web and found that i should be using eval() for the code to be executed before it is send to the browser but cannot get it to work and can't find my mistake(s).

the php code will always be the same, and is supposed to retrieve the id number of a page to use in a link (and works fine when tested by loading the code directly without retrieving it from the database)

this is an example of data stored in the database
Code: [Select]
The <a href="page_builder.php?id=<?php echo $page->id('mines_DwarvenMines') ?>">Dwarven Mines</a> have a great selection of Ores,...
Of course when I leave it like this, hovering over the link in my page will show exactly that and lead to nowhere
Code: [Select]
localhost/page_builder.php?id=<?php echo $page->id('mines_DwarvenMines') ?>
Most of these links appear in tips given at the end of the page and are processed as followed
Code: [Select]
$questtips = $quest->getQuestTips();
$tips = "";
if ($questtips == "none")
{
$tips = "/";
}
else
{
foreach($questtips as $tip)
{
$tips .= "<li>";
$tips .= $tip->getTip();
$tips .= "</li>";
}
}

and finally put on screen by the presentation layer as followed
Code: [Select]
   <h2>Tips &amp; Extra Info</h2>
   <div class="tipsList">
      <ul>
   <?php echo $tips ?>
      </ul>
   </div>
I have tried all sorts to get the code to be executed when retrieved from the database before being send to the browser so that this particular link would say "localhost/page_builder.php?id=57" but I cannot get it to work, though I suspect it is fairly easy.

I suspect I would have to store the data in a different format in the database? And how exactly do I use the eval() function in my case?
Could someone please adjust my code so that it does work?

Thanks

Hi,

I have managed to get the code working to store a .jpg file in the database under the longblob type.

Now all i have left to do is to retrieve that image and display it.

So far i have this:

list.php
Code: [Select]
while($r = mysql_fetch_array($sql)) { //for each record
...
echo "     <img src=  getoutside.php?id='".$r[apartmentId].  " '>     ";

getoutside.php
Code: [Select]
<?php
header("Content-type: image/jpg"); // act as a jpg file to browser
    $nId = $_GET['id'];
include 'dbase.php'; //connect to database
    $sqlo = "SELECT outside FROM apartment WHERE apartmentId = $nId";

$oResult = mysql_query($sqlo);

$oRow = mysql_fetch_array($oResult);
$sJpg = $oRow["outside"];
echo $sJpg;
?>
The result from this is a box with a red cross in it.
Can anyone find a problem with this code please?

Thanks

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=318312.0

Basically i have a folder with 100+ images they are NOT all the same extension, what im wanting to do is use PHP to find all the images and put them all in a database. how would i go about doing this?

thanks

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=309239.0

I have two tables.

Table Name:Users

Fields:

User_name
user_email
user_level
pwd


2.Reference

Fields:

refid
username
origin
destination

user_name in the users table and the username field in reference fields are common fields.



There is user order form.whenever an user places an order, refid field in reference table will be updated.So the user will be
provided with an refid

Steps:

1.User needs to log in with a valid user id and pwd
2.Once logged in, there will be search, where the user will input the refid which has been provided to him during the time of order placement.
3.Now User is able to view all the details for any refid
3.Up to this we have completed.

Query:

Now we need to retrieve the details based on the user logged in.

For eg: user 'USER A' has been provided with the referenceid '1234' during the time of order placement
user 'USER B' has been provided with the referenceid '2468' during the time of order placement

When the userA login and enter the refid as '2468' he should not get any details.He should get details only for the reference ids which is assigned to him.

The subject could be a bit vague, but my problem is simple. (I think so)

So I made a php test site that is quite similar to a forum. Where you see a title or a subject and when you click on it you will see more details about that subject.
I made my database and script for inserting data into my mySQL database.

I also did my output aswell, so every topic is posted on a webpage "archive" where you can see all the subjects.

But now I want to see the full details of that type of subject by clicking on it. I have no idea how to make that happen
googled it but didn't find any results...just wondering if it's even possible to do that.

I'm a new guy here!