6/28/2023 0 Comments Html5 tableditIf there is a password, you will have to give it on the command line. INSERT INTO `tbl_2_ids` (`id0`, `id1`, `last_name`) VALUES ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1 In order to create the database "testing" with the tabel "tbl_2_ids" you can use the following batch file "database_mysql.batch".įor mysql perform the batch file by the command: mysql -u root -p < database_mysql.batch Live Table Data Edit Delete using Tabledit Plugin in PHP Be sure also to adopt the code for actions "edit" and "delete" within the file "action.php". This is achieved using a regular expression: $id_array = preg_split("/ /",$id_ser) (Serialization by the php function serialize() did not work, as there are quotations marks generated by the function, which are not transportet well by the INPUT_POST of tabledit.) Within the file "action.php" one has to "unserialize" the $id_ser back. $id_ser = $row." ".$row Īnd I use this "serialized" id as values for the first column of the displayed table. Therefore I used a kind of handmade serialization of the two identifiers by just putting them after each other separated by a semicolon. I changed the code from webslessons to this end. What you can do is to dump the two identifiers into one column. Tabledit does not work with two identifiers per se. ![]() (Honestly, second try, I only had to add the file into the directory.) ![]() Just tried the code from your source at webslessons, it worked at the first try.
0 Comments
Leave a Reply. |