PHP和MySQL将所有日期行更新为时间戳

I have a database which structure looks like

[Name] [18:00]
[Name] [12:00]

I want to convert each time to timestamp using strtotime accordingly. How do i do it please? i tried while loop and it set same time for everyone.

You could try something like the following, simply supply the correct name for the table and column.

update `<TABLE>` set `<FIELD>`=unix_timestamp( concat( date_format( now(), "%Y-%m-%d"), " ", `<FIELD>`, ":00" ) );

or, having now seen the pastbin data

update `times` set `book_date`=unix_timestamp( concat( date_format( now(), "%Y-%m-%d"), " ", `book_date`, ":00" ) );

if(isset($_POST['update'])){
    for($i=0;$i<$count;$i++){
        $result = dbquery("UPDATE times SET.....");
    }
}

This is what i needed. This is the solution that helped me update each value with unique new-value. That is all needed.