PHP - Pulling Sunset Time From Txt File And Displaying On Site Daily

Hi all:

I have been going nuts trying to get this to work. I have gone through many attempts based on internet searches and examples that simply do not work.

I have files stored in my MySQL db. The files cna be of any type and are being displayed in a listed report. The files are hyperlinked and clickable, but here is the issue:

When I click on a file in:
http://development.products-and-services.ca/cms/test.php
I get:
http://development.products-and-services.ca/cms/test2.php?content=DHall_CV_webdev_eng.pdf
as a blank page result.
The objective is to get a file download alert or to see the file in the browser.

Any ideas?

I used the following code to convert the length in seconds to min:second format
$sec=$duration % 60;
if ($sec=="0"){
$min=$duration/60;
$duration=''.$min.':00';
}else{
$min=(($duration-$sec)/60);
$duration=''.$min.':'.$sec.'';
}
everything is OK, but it shows 35:5 instead of 35:05. I mean it disregards the first 0 when the second is 1-digit. 

Anyone know how I can print a file (specifically a PDF) that is stored on the server to the clients computer with a button?  I don't want them to be able to view it, just print it.  I've done some research and understand that there is no way to print directly without popping up the Windows Print dialog.  And that is fine.  I just want them to print this file, but not no where it is or be able to type in a URL to access it.
Thanks
Mike

I think its a problem connecting with mySQL, because no matter what I put in the "Date" category, it comes up as Dec 31.  Here's the snippet in question for the newArticle.php, and the corresponding snippet for the homepage layout.  If I could somehow put a  "$today = date("F j, Y, g:i a");"   at the top and replace that stuff with $today, please let me know!  The column is called publicationDate, and its a VARCHAR with 30 length.  And I'm 100% I'm connected to the DB itself, because articles will post correctly and they appear on both the webpage and their various rows.  The only one thats not working is publicationDate.
The 'write' part in newArticle.php
 
Code: [Select]
<li>
            <label for="publicationDate">Publication Date</label>
            <input type="date" name="publicationDate" id="publicationDate" placeholder="MM-DD-YYYY, hh:mm" required maxlength="30" value="<?php 
echo $results['article']->publicationDate? date("F-j-Y-g:i a", $results['article']->publicationDate ) : ""  ?>" />
          </li>
The 'read' part in the homepage
Code: [Select]
<td><?php echo date("F j, Y, g:i a", $article->publicationDate)?></td>

When I echo the current time, the hour is what it is plus one:

echo date("h:i:s:A");


Real time is 3:46:33

Would display 4:46:33


What is wrong here?

Hi,

I'm inserting hours and minutes per user into a database where they have their own fields.
(userid, hours, mins)

I've a small issue when displaying the data.

When I run my query I sum the total hours and minutes per user which results in data such as the following

userid1 - 2  hours 15 mins
userid2 - 1 hour 100 mins

The query orders by hours and then mins desc

When I'm displaying the data (as I'm looping through the results array) I perform a calculation to convert the mins to hours so it now reads

userid1 - 2 hours 15 mins
userid2 - 2 hours 40 mins

so the webpage displays userid1 first when i want userid2 to be the first record displayed (Hours desc)

Can anyone recommend a solution to this ?
Will I need to create another table and update it as hours and minutes are being entered and display results from that table instead ?
Can I order the data after I carry out the mins to hours calculation ?

many thanks in advance for any suggestions....

tmfl

This topic has been moved to Application Design.

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

Hello, I have some questions about dates/time ...

I have a site where registered users will receive messages, I want to include the date/time with that message.
I am not sure what is best way to do this, so I am recording the GMT hours offset from users input (from receivers), but then I saw that the hours offset from the GMT is different in different seasons of the year, so how do I detect correct local time for the message receiver? Is it something like a database with start-end time of daylight savings hour adjustment or how is this done?

hiii all, i want to show the database field (alise name) as the url after index.php when page or site loads first time. how i can achieve it? please help.... thanks in advance

I am trying to make a PHP script that will read the linked file. It essentially is a map array using ASCII charactor codes.

It has a 23 offset initial line for the name of the map, and then 76 offset for each row of the map. Half the 76 is for the actual map displaied ASCII chr and the other half for the color. 

I would think it would be fairly easy to do, but I can't seem to get the code to work.

http://cid-b676d7f6bbd68862.office.live.com/self.aspx/.Public/file.map

Anyone have some puesdo code to help me out.

i want to display the size of a file but i round it off to the nearest kb.

I am using...
($_FILES["file"]["size"]/1024/1024)."mb"

i am geting it return something like this....
1.0313243865967mb
and i want it to be more like
1.03mb

any idears???

I wrote a very simple web form that allows my user to view text files from within their Internet browser.

Occasionally, the search criteria entered returns more than one file. So I want to implement a feature whereby the text files returned by the search are compressed into a ZIP.

I got a prototype working but it only compresses the first file. The second or third files are ignored.

Here's my code

  Code: [Select]
  <HTML><body><form name="myform" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
    <fieldset><label for="DBRIDs">RIDs</label><input type="text" id="DBRIDs" name="DBRIDs" >
    </fieldset></form></body></HTML>
    <?php
    function check_search() {
     if (isset($_POST['submit'])) {if (!empty($_POST['DBRIDs'])) { $results = getFiles(); }
            }       else $errors = "Please enter something before you hit SUBMIT.";
     return Array($results, $errors);
    }
    function getFiles() {
     $result = null;
     $ZIPresult = null;
     if (empty($_POST['DBRIDs'])) { return null; }
     $mydir = MYDIR; 
     $dir = opendir($mydir);
     $DBRIDs = $_POST['DBRIDs'];
     $getfilename = mysql_query("select filename from search_table where rid in (" . $DBRIDs . ")") or die(mysql_error());
     while ($row = mysql_fetch_array($getfilename)) {
     $filename = $row['filename'];
     $result .= '<tr><td><a href="' . basename($mydir) . '/' . $filename . '" target="_blank">' . $filename . '</a></td></tr>';
     $ZIPresult .= basename($mydir) . '/' . $filename;
    } 
    if ($result) {
    $result = "<table><tbody><tr><td>Search Results.</td></tr> $result</table>";
    shell_exec("zip -9 SearchResult.zip ". $ZIPresult ." > /dev/null ");
    } return $result;
    }
The hyperlinks pointing to the file(s) are generated just fine. The ZIP file however only contains the first file listed in the results.

How can I get the ZIP file to capture ALL the files returned??

Thanks for your input.

**PS: The new ZipArchive() library/class is not available on our production environment so I chose to use the Unix utility ZIP instead.**

I need to write a bit of code to select some mp3's (actually, just the titles) from a database...but I need to select them based on last play (which is a timestamp field in the DB) AND I need to select 14 minutes worth of them (and not more than 15 minutes).  I currently do NOT know how long each song is...

So, if every song was 2 minutes long, I would need 7 songs.  If each song was 3 minutes long, I'd need to select 5 of them.

I currently do NOT have a length field in the db (the boss sprung this on me after I designed the DB).  A few questions:

Would it be best to have a column of TIME (mysql time...not the name of the column)? 

Would it be best to have a column for the raw size of the file (each file is the same bitrate, so I could do the math - plus it would be probably be easier to import raw filesize using php into the db)

Would it be easier to do something else?

Once we answer that, I'll start with some code...and probably be back for help!

Hello

So in my index.php code i include('somefile.html');. In the html file itself there is an <img src="/images/picture.jpg">. When looking at index.php on a browser, the html looks fine everything loaded fine except for the <img> There is a little broken image link displayed on the page. i checked through the browser if i mistyped the img src link but somefile.html in the browser displays the image fine. But if i try to display the img in the html file through the php file, its a broken link. Any reason why this is happening? Am I missing something here? Thanks in advance.

I want to make the news feed on my website easier to maintain. I just created a form that I will use to add the information. The form saves the files that it creates as "entry-date-time.txt" and places it in a folder for the year and a sub folder for the month. Such as "2011\09".

I have displayed data from a single flat file before, but I am unsure how to go about displaying the data from multiple files. Can anyone show me an example?

I want to be able to paginate the data, displaying a number of updates per page from newest to oldest.

I don't have MySQL access on the server or I'd just use that, instead.