Try this:
//Get SAM's Time
$SAMdb->open("SELECT UNIX_TIMESTAMP() as timeonsam");
$samtime = $SAMdb->row();
$curtime = $samtime['timeonsam'];
if $SAMdb is not your connector change it to $db
then echo $curtime in the proper format you want.
----- Original Message -----
From: "Kipp Gremillion" <[email protected]>
To: <[email protected]>
Sent: Friday, March 13, 2009 2:08 PM
Subject: RE: [General-discussion] Displaying SAM server time on PHP website.
> Excellent, that's what I need then. Thanks!
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of
> James Henline
> Sent: Friday, March 13, 2009 3:02 PM
> To: [email protected]
> Subject: Re: [General-discussion] Displaying SAM server time on PHP
> website.
>
> MySQL can query the server time, which should be the time the computer has
> and return that.
>
> James Henline.
> Help Desk Manager
> Development Manager
> Spacial Audio Solutions LLC.
> 972-739-6420 ext: 110
> www.audiorealm.com
> www.spacialnet.com
> www.spacialaudio.com
>
> CONFIDENTIALITY NOTICE: This email, including any attachments, contains
> information from SpacialAudio Solutions LLC., which may be confidential or
> privileged. The information is intended to be for the use of the
> individual
> or entity named above. If you are not the intended recipient, be aware
> that
> any disclosure, copying, distribution or use of the contents of this
> information is prohibited. If you have received this email in error,
> please
> notify the sender immediately by "reply to sender only" message and
> destroy
> all electronic and hard copies of the communication, including
> attachments.
>
>
> On Fri, Mar 13, 2009 at 3:54 PM, Kipp Gremillion
> <[email protected]>wrote:
>
>> Thanks for the reply...
>>
>> So you are saying MySQL server can provide the time itself, or I have to
>> put
>> the time into the DB constantly? I thought of putting it there but it
>> would
>> not be very accurate unless I did it constantly and that seems intensive.
>>
>>
>>
>> -----Original Message-----
>> From: [email protected]
>> [mailto:[email protected]] On Behalf Of
>> Chris Haslage
>> Sent: Friday, March 13, 2009 2:47 PM
>> To: [email protected]
>> Subject: Re: [General-discussion] Displaying SAM server time on PHP
>> website.
>>
>> I would think that can be grabbed from the MySQL database directly. You
>> may
>> want to google on how to get the current time from a remote MySQL
> database.
>>
>> Thanks,
>>
>> *Chris*
>>
>> On Fri, Mar 13, 2009 at 3:45 PM, Kipp Gremillion <[email protected]
>> >wrote:
>>
>> > I am looking for suggestions on how to get the SAM server time
>> > displayed
>> on
>> > a PHP web page that my DJ's will see so they will know accurately what
>> time
>> > the SAM server has and in turn, when to start streaming to my server
>> > for
>> > relaying.
>> >
>> > Thanks,
>> > Kipp
>> > _______________________________________________
>> > General-discussion mailing list
>> > [email protected]
>> > http://mailman.spacialaudio.com/mailman/listinfo/general-discussion
>> >
>> > TO unsubscribe to this list, simply send a blank email to
>> > [email protected]
>> >
>> > with the subject
>> > 'unsubscribe'
>> >
>> _______________________________________________
>> General-discussion mailing list
>> [email protected]
>> http://mailman.spacialaudio.com/mailman/listinfo/general-discussion
>>
>> TO unsubscribe to this list, simply send a blank email to
>> [email protected]
>>
>> with the subject
>> 'unsubscribe'
>>
>>
>> _______________________________________________
>> General-discussion mailing list
>> [email protected]
>> http://mailman.spacialaudio.com/mailman/listinfo/general-discussion
>>
>> TO unsubscribe to this list, simply send a blank email to
>> [email protected]
>>
>> with the subject
>> 'unsubscribe'
>>
> _______________________________________________
> General-discussion mailing list
> [email protected]
> http://mailman.spacialaudio.com/mailman/listinfo/general-discussion
>
> TO unsubscribe to this list, simply send a blank email to
> [email protected]
>
> with the subject
> 'unsubscribe'
>
>
> _______________________________________________
> General-discussion mailing list
> [email protected]
> http://mailman.spacialaudio.com/mailman/listinfo/general-discussion
>
> TO unsubscribe to this list, simply send a blank email to
> [email protected]
>
> with the subject
> 'unsubscribe'
>
>
