14 replies to this topic

[augustorosauro]

Pessoal,

Tenho duas datas em Timestamp (Unix)

$data = $data1-$data2
Obtenho a difereça entre as datas em segundos...

Tem alguma forma fácil de exibir algo como :
03:22:15 (H:i:s) ?

Valeu!

[Felipe Pena]

Dê uma olhada nisso:

<?

$data1 = mktime("10", "10", "10", "10", "10", "2005");
$data2 = mktime("10", "9", "10", "10", "10", "2005");

echo "Diferença: ".($data1 - $data2) ." segs";

?>

Leia no manual sobre a função mktime()
http://www.php.net/mktime

[augustorosauro]

Mas como integrar isto com o TimeStamp que já esta no Banco de Dados?

$data1 esta no formato TimeStamp.
Tenho que quebra-la em H:m;s???

[Felipe Pena]

Você quer subtrair o tempo que está gravado na BD com que tempo? Hora atual?


Comparando a data do BD (timestamp) com a atual fica:

$Consulta = mysql_query("SELECT (NOW() - campo_data) tempo FROM tabela");
while ($x = mysql_fetch_array($Consulta))
{
    echo "{$x["tempo"]}<br />";
}

[augustorosauro]

Estou com duas horas registradas no BD
$data1 - Formato TimeStamp : Hora do primeiro registro no site
$data2 - Formato TimeStamp : Hora do último registro no site

Gostaria de saber o tempo online de cada visitante, subtraindo as datas
e apresentando no formato H:i:s

[Felipe Pena]

Então você quer pegar o horário do primeiro registro do bd e subtrair com o último registro...
Certo ?

[augustorosauro]

É isto...
E apresenta-lo da forma H:i:s

[Felipe Pena]

Veja esse exemplo:

<?

// PEGANDO O PRIMEIRO REGISTRO
$Cons1 = mysql_query("SELECT time FROM tabela ORDER BY time ASC");
$x1 = mysql_fetch_array($Cons1);

$Data1 = $x1["time"];


// PEGANDO O ÚLTIMO REGISTRO
$Cons2 = mysql_query("SELECT time FROM tabela ORDER BY time DESC");
$x2 = mysql_fetch_array($Cons2);

$Data2 = $x2["time"];

// SUBTRAÇÃO
$Data = ($Data2 - $Data1);


$cont = 0;
$Medida = array("segundos", "minutos", "horas");

while ($Data >= 60)
{
    $cont++;
    $Data = round($Data / 60);
}

// EXIBINDO A DIFERENÇA DE TEMPO
echo "{$Data} {$Medida[$cont]}.";

?>

Aonde usei time como nome do campo que usa a propriedade TIMESTAMP.

[augustorosauro]

PERFEITO !!!
VLW !!!!

Achava que haviam funcoes do MySQl prontas para isto...

[LarPhozyHah]

Can I Take Cipro With Amoxicillin buy cialis Celebrexsavings Cephalexin 500mg Cap Ranbaxy Priligy Dapoxetina 60 Mg
Buy Cephalexin Best Price For Generic Viagra cialis buy online Viagra Online Empfehlung Stendra Avana
Buy Propecia A Diez Dias viagra cialis Viagra En Angleterre Amoxicillin Breastfeeding

[LarPhozyHah]

New Healthy Man Viagra Perfect Rx Meds Buy Viagra Usa viagra online Brand Viagra Hawaii Cialis Vendita On Line In Italia
Kamagra Review Zithromax Dosage Elderly Cytotec Prix Tunisie viagra Amoxicillin Allergy Rash Information Isotretinoin Claravis Carmarthenshire
Priligy Se Puede Tomar Con Viagra generic cialis Cialis Vendita Generico Discount Generic Elocon Worldwide Drugs No Script Needed Healthymen

[LarPhozyHah]

Propecia Hair Loss Treatment For Women Rogaine Men Over 50 viagra online Generic Progesterone Discount Direct Free Doctor Consultation Stirling Propecia Reactions Buy Cipro 500mg
Metronidazole Over The Counter Sale Elocon viagra Overnight Lavitra Acquisto Kamagra 25mg Super Active Finasterid 5mg Rezeptfrei Kaufen
Can You Drink On Amoxicillin cheap cialis Levitra 20mg Generique Prix Cialis Bucodispersable Best Site To Buy Viagra Online
Amoxicillin Isde Effects Comprare Levitra Generico Senza online pharmacy Pharmacie Cialis Ligne 300 Mg Lithium Carbonate Doctors
Kamagra Online Now Pictures Of Cephalexin viagra Generic Levaquin Buying Best Website Shop Without Perscription Generic Provera With Free Shipping Price Overseas Amex Accepted Lexington

[BobbyCak]

акт причинения ущерба имуществу организации образец

резюме помощника бурильщика образец уведомление о выселении из квартиры образец Отчет о результатах внутреннего финансового контроля Акт зачёта взаимных требований образец Образец договора перевода долга трехсторонний Возражение на акт пфр образец по сзв-м Примеры заполнения анкеты на работу Отчет о расходе основных материалов форма м 29 образец заполнения оперативный журнал теплового пункта образец заполнения заявление о расчете пособия по законодательству 2010 г.в 2017 году уведомление о расторжении договора подряда по инициативе заказчика ходатайство в министерство образования образец почта россии реестр писем бланк скачать журнал учета калия перманганата образец договор строительного подряда-судебная практика Договор считается заключенным с момента подписания сторонами Заявление на увольнение после декретного отпуска образец Трудовой договор с сантехником тсж образец Письмо уточнение назначения платежа образец Обращение в управляющую компанию образец Образец заполнения заявки на подключение к электронному бюджету Заполнение формы с-09-3-1 образец заполнения заявление о взыскании судебных расходов по гражданскому делу порядок формирования плана закупок по 44 фз образец заполнения заявление о выходе на работу из декретного отпуска образец паспорт на пиломатериалы образец форма по кнд 1151085 образец заполнения для ип нулевая

приказ о закреплении печатей и штампов образец постановление правительства рф от 10 сентября 2009 г. n 720 жалоба на сбербанк в центробанк образец

постановление губернатора ростовской области декларация о соответствии субъектам малого предпринимательства образец 2017 образец искового заявления об исправлении кадастровой ошибки заявление о выходе из общества с ограниченной ответственностью образец приказ 1280 мо рф приложение 2 бланк скачать Счет по агентскому договору образец акт о проведении растяжки компенсаторов образец заполнения рко на возврат денежных средств покупателю воинский учет форма 18 бланк скачать заявление об аварийном состоянии балкона анкета для шенгенской визы скачать резюме продавец кассир образец пропуск на автомобиль образец срок регистрации договора дарения в росреестре право подписи искового заявление при подаче его в арбитражный суд имеет справка с места работы для пенсионного фонда образец форма 39-1 налоговая образец 2017 журнал учета полученных и выставленных счетов-фактур 2017 бланк ппр на земляные работы образец доверенность на ведение дела в суде образец образец штатное расписание на 2017 год оформляем по всем правилам мелоксикам гель инструкция по применению постановление правительства рф от 29.07.2013 645

пассажирская таможенная декларация бланк скачать протокол узи органов малого таза образец скачать заявление об ознакомлении с протоколом судебного заседания платежка в ффомс в 2017 году образец заполнения отраслевое соглашение между департаментом образования и профсоюзом

[RonsisM]

Free Porn Get Vagera Amoxicillin Max Dose cialis price Cozaar 50 Mg Without A Script Comprar Cialis Generico En Espana

[JeffMalm]

You should have your period within 2 to 3 days after the ring is removed tamoxifen drug class
clomiphene antiestrogen LH and hCG tell your ovaries to release the egg or eggs that they have just developed
18 Indirect comparison therefore suggests that the major reason for the strong influence of PgR status on outcome for both anastrozole and tamoxifen is an intrinsic prognostic effect anastrozole vs tamoxifen quality of life H ATPase was stained with blue, and pendrin was stained with brown
Zhao J, Cheng F, Yao Z, Zheng B, Niu Z, He W propecia for men to buy
The doctor will go over some problems that could happen, such as buy cialis cheap
I understand this might be shocking to read on social media and that really isn t my intention stromectol 3 mg tablet
finasteride generic uk Use short, simple sentences
I was put on medication for a month and retested after a month and my PSA dropped to 2 stromectol comprar Hosahalli V
Best of luck to anyone who needs it cialis pills for sale
Of the 294 patients, postoperative AKI developed in 64 patients 21 cialis tadalafil
FACS sorted YFP positive fibroblasts sorted 14 days after Dpt IresCreERT2 recombination expressed higher levels of Pi16 and Col15a1 and lower levels of Ccl19 and Npnt in the lymph node and lung, respectively, than YFP negative fibroblasts rx canada pharmacy accutane What are the possible side effects of steroid treatment
5 fetuses were abnormal with reduction in size, thickened epicardium and mesenchymal septum how to take viagra Minor 1 parecoxib decreases effects of perindopril by pharmacodynamic antagonism
order accutane online More About Cholesterol Pills
cialis online without prescription The curtains are from Les Indiennes and I loooove them
Should hysterectomy be performed, restarting tamoxifen postoperatively may be appropriate nolvadex for fat loss
ii Instruction, to include performance drills, in cardiopulmonary resuscitation buy ivermectin pills online
One interviewer JV completed the study interviews after obtaining consent, explaining the goals of the study, and recording patient demographic information buy cialis canadian
Overgaard M, Hansen PS, Overgaard J, Rose C, Andersson M, Bach F, Kjaer M, Gadeberg CC, Mouridsen HT, Jensen MB, Zedeler K Postoperative radiotherapy in high risk premenopausal women with breast cancer who receive adjuvant chemotherapy viagra generic name
That s one reason why you should check with a doctor before you take potassium supplements buy generic propecia Rogge tips on how to lower blood pressure smiled smugly, and suddenly increased his movements, Adjani s unstoppable will doing cardio lower blood pressure moans poured into Fengdie s room through the thin slatted walls, and they echoed incessantly
2014; Stojanowski et al priligy cvs No lethal toxicity was documented during therapy; however, 1 patient later died of myelodysplastic syndrome induced by dibromodulcitol
If an agent is administered therapeutically to treat one cell type but has an undesirable effect on another cell type, the invention provides an assay to determine the molecular basis of the undesirable effect and thus provides the opportunity to co administer a counteracting agent or otherwise treat the undesired effect sildenafil vs viagra vs cialis
mark martin viagra car In nonpregnant breast cancer patients, delaying chemotherapy beyond 4 months is associated with diminished efficacy and the same applies to PABC 25
May be tender immediately before and during menses Diffusely enlarged uterus with cystic areas within myometrial wall Is definitive diagnosis mail order propecia Heavy bleeding preceded by spotting can be due to miscarriage, ectopic pregnancy or bleeding around the fetus subchorionic haemorrhage
buy online cialis PubMed 11014311
cialis for daily use E mail al kline
best place to buy cialis online reviews 1 billion pounds
In certain embodiments, R P12 is unsubstituted C 1 6 alkyl buy cheap cialis online 5b, e g, while combination of herceptin and didox caused no significant change in the S phase cell population 10
The risk would be much less acne medication accutane
DIM may for some women be counter intuitive especially if there don t have any issues with excess estrogens to begin with legit cialis online So I m in my fertile window, and this morning I had a ton of egg white discharge
These effects should be considered by clinicians when prescribing loop diuretics to critically ill patients with or at risk of AKI cialis generic online
Furthermore, MTB tetO MIC organoids can be adapted into co culture systems with fibroblasts or individual components of the immune system such as macrophages in order to study the contribution of these cell types to tumor induction and progression clomid
buy nolvadex Stay tuned as we demystify testosterone and answer these and other questions for you
teens with Postural Orthostatic Tachycardia Syndrome have dizziness, fatigue, headaches, nausea, difficulty concentrating and other symptoms related to alterations or dysfunction in the autonomic nervous system dysautonomia generic cialis 5mg FSH level is typically tested at the beginning of stimulation 23, 24, and the importance of E 2 level is frequently overlooked
buy clomid online But I can tell you that there s 23 million women in the U
take viagra You will not become politicians, shouting slogans, pointing the country, and high spirits
Statistical analyses of qPCR inflammation array data azithromycin used for PMID 10212819 Review
letrozole vs tamoxifen In any case, more studies will be needed in our country, once the price of tafamidis is known in our setting
Natalie, USA 2022 06 26 12 08 09 finasteride prescription Am J Physiol 225 1114 1117
I felt like I was in good hands acheter du levitran
You may lose feeling in elements of your body or have a painful, tingling, or burning feeling If you might have neuropathy, you could not be capable of really feel a sore on your foot People who ve neuropathy might proceed strolling on a foot that has broken joints or bones Charcot foot causes swelling and instability in the injured foot buy nolvadex canada
nolvadex testosterone Sean coughed twice, and everyone cheered up
buy ivermectin tablets An elevated expression of PCNA in mammary tumors of DMBA control animals indicates accelerated proliferation of tumor cells
ritonavir will increase the level or effect of brexpiprazole by affecting hepatic enzyme CYP2D6 metabolism how does propecia work
stromectol pill B, Mediolateral oblique A and craniocaudal B screening mammograms and corresponding magnification views from subsequent diagnostic mammograms C and D, respectively show grouped coarse heterogeneous calcifications oval in right breast at 11 o clock position, middle depth
Suppression of cardiac myocyte hypertrophy by conjugated linoleic acid role of peroxisome proliferator activated receptors alpha and gamma enclomiphene vs clomiphene
I am going through some of these issues as well kamagra efectos farmacia Conclusion The rs5758550 enhancer does not lead to improved prediction of endoxifen levels in breast cancer patients
Samual, USA 2022 04 24 06 50 26 accutane dosage chart Breast Cancer Res 9 R52
Tissue was processed for paraffin embedded sections or cryosections and subsequently analyzed by H E staining according to the manufacturer s protocol Sigma Aldrich cheap cialis online
Two control mice Fig 4, animals 1 and 4 contained both the LSL TPP1 and cre driver transgenes but were not treated with tamoxifen priligy at walgreens
generic cialis online How much weight could I lose using Alli