filmov
tv
PHP and MySQL: how to store time and compare time
Показать описание
Time is a little complicated variable: month-day-year Hour-minute-second
MySQL data type:datetime
PHP function: date('Y-m-d H:i:s')
To compare time, it is better to convert it to UNIX time
In PHP mktime, MYSQL UNIX_TIMESTAMP for UNIX time
Example:
CREATE TABLE members (
`member_id` mediumint(8) unsigned NOT NULL,
`dept_type` tinyint(4) NOT NULL default '0',
`edu_type` tinyint(4) NOT NULL default '0',
`modify_date` datetime default '0000-00-00 00:00:00',
PRIMARY KEY (`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Compare time
More about this video:
MySQL data type:datetime
PHP function: date('Y-m-d H:i:s')
To compare time, it is better to convert it to UNIX time
In PHP mktime, MYSQL UNIX_TIMESTAMP for UNIX time
Example:
CREATE TABLE members (
`member_id` mediumint(8) unsigned NOT NULL,
`dept_type` tinyint(4) NOT NULL default '0',
`edu_type` tinyint(4) NOT NULL default '0',
`modify_date` datetime default '0000-00-00 00:00:00',
PRIMARY KEY (`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Compare time
More about this video:
0:12:55
16 | Create a Database in MySQL PHP Tutorial | 2023 | Learn PHP Full Course for Beginners
0:22:53
PHP With MySQL Tutorial For Beginners | PHP And MySQL Database Tutorial | PHP Tutorial | Simplilearn
0:06:41
Connect to MySQL with PHP in XAMPP / Create a new database
0:32:49
PHP and MySQL with CRUD Operations: Create, Read, Update, Delete
7:12:17
PHP & MySQL Tutorial | Learn PHP From Scratch | Full Tutorial
0:06:21
PHP Connect to MySQL Database | 2 Methods
0:07:09
How to Connect HTML Form with MySQL Database using PHP
0:01:00
How to connect PHP with MySQL Database | Step by Step Guide | Geekboots
0:01:01
Billing System in PHP and MySQL #php
0:28:37
Really Simple CRUD Operations Tutorial with PHP and MySQL
0:07:16
PHP Tutorial (& MySQL) #26 - Getting Data From a Database
0:02:51
How to Connect PHP File to MySQL Database using phpMyAdmin | CRUD Operations
0:05:25
PHP Tutorial (& MySQL) #23 - MySQL Introduction
0:24:38
Save HTML Form Data to a MySQL Database using PHP
0:43:16
Signup and Login with PHP and MySQL
0:00:58
Creating a database using xampp control panel. #xampp #database #sql #mysql #php
0:00:09
php interview question top 50 #php #laravel #linux #apache
0:16:57
PHP Tutorial (& MySQL) #7 - Arrays
0:07:46
PHP and MySQL How to connect #HTML #login form to #PHP and #MySQL Part 2
0:00:16
❗𝐆𝐑𝐀𝐓𝐈𝐒❗Sistema de venta básico - PHP- MYSQL
0:05:14
How to Run PHP Projects with MySQL: Database Setup Tutorial - CodeAstro
0:04:16
Connect Your HTML Form to MySQL with PHP: Step-by-Step Tutorial
0:17:31
Creating Dynamic Web Pages Using PHP and MySQL | Part 1 | Coding the Front-end
0:07:33
A quoi servent le PHP et MYSQL ? [ITWB04]
Комментарии