Tweet
id asset_id ordering state approval site_itemid checked_out checked_out_time title alias access language hits created created_by created_by_alias created_by_email modified modified_by username catid image file displaytime weekdays daystime startdate enddate period dates next time place website email phone name city country address coordinate lat lng shortdesc desc metadesc params 13686 12273 10745 1 0 0 0 0000-00-00 00:00:00 How can Blockchain Change the Future? how-can-blockchain-change-the-future 1 * 742 2019-05-28 10:54:08 813 2019-05-28 10:54:08 813 hajarEUE2017 4 images/LOGOS/BRITISH_CHAMBER.jpg 1 2019-09-09 12:30:00 2019-09-09 14:00:00 a:1:{i:0;s:16:"2019-09-09 12:30";} a:1:{i:0;s:16:"0000-00-00 00:00";} 2019-09-09 12:30:00 British Chamber of Commerce in Belgium https://www.britishchamber.be/event/how-can-blockchain-change-future Boulevard Bischoffsheim 11, 1000, Brussels, Belgium 0.0000000000000000 0.0000000000000000 <p style="text-align: justify;"><span style="font-size: 10pt;">We are pleased to welcome Mr. Pēteris Zilgalvis, Head of Unit, Digital Innovation and Blockchain, Digital Single Market, DG CONNECT {"statutReg":"","accessReg":"","typeReg":"1","reg_deadline":"","maxReg":"","maxRlistGlobal":"","maxRlist":"","RegButtonText":"","RegButtonLink":"","RegButtonLink_Article":"","RegButtonLink_Url":"","RegButtonTarget":"0","atevent":"","first_published_and_approved":1}
| 13686 | 12273 | 10745 | 1 | 0 | 0 | 0 | 0000-00-00 00:00:00 | How can Blockchain Change the Future? | how-can-blockchain-change-the-future | 1 | * | 742 | 2019-05-28 10:54:08 | 813 | 2019-05-28 10:54:08 | 813 | hajarEUE2017 | 4 | images/LOGOS/BRITISH_CHAMBER.jpg | 1 | 2019-09-09 12:30:00 | 2019-09-09 14:00:00 | a:1:{i:0;s:16:"2019-09-09 12:30";} | a:1:{i:0;s:16:"0000-00-00 00:00";} | 2019-09-09 12:30:00 | British Chamber of Commerce in Belgium | https://www.britishchamber.be/event/how-can-blockchain-change-future | Boulevard Bischoffsheim 11, 1000, Brussels, Belgium | 0.0000000000000000 | 0.0000000000000000 | <p style="text-align: justify;"><span style="font-size: 10pt;">We are pleased to welcome Mr. Pēteris Zilgalvis, Head of Unit, Digital Innovation and Blockchain, Digital Single Market, DG CONNECT | {"statutReg":"","accessReg":"","typeReg":"1","r eg_ deadline":"","maxReg":"","maxRlistGlobal":"","maxR list":"","RegButtonText":"","RegButtonLink":"","Re gButtonLink_Article":"","RegButtonLink_Url":"","Re gButtonTarget":"0","atevent":"","first_published_a nd_approved":1} |
="("&JOINDRE.TEXTE(", ";FAUX;'output table'!A2:AU2)&")"
=SUBSTITUE(B1&" "&JOINDRE.TEXTE(",";VRAI;C:C)&";";CAR(160);CAR(32))
INSERT INTO `srhoq_icagenda_events` (`id`, `asset_id`, `ordering`, `state`, `approval`, `site_itemid`, `checked_out`, `checked_out_time`, `title`, `alias`, `access`, `language`, `hits`, `created`, `created_by`, `created_by_alias`, `created_by_email`, `modified`, `modified_by`, `username`, `catid`, `image`, `file`, `displaytime`, `weekdays`, `daystime`, `startdate`, `enddate`, `period`, `dates`, `next`, `time`, `place`, `website`, `email`, `phone`, `name`, `city`, `country`, `address`, `coordinate`, `lat`, `lng`, `shortdesc`, `desc`, `metadesc`, `params`) VALUES ('', 0, 0, 1, 1, 613, 0, '0000-00-00 00:00:00', 'Test Marc 1', 'testmarc1', 1, '*', 1, '2019-09-11 13:04:48', 0, '', 'marc@woluweb.be', '0000-00-00 00:00:00', 0, 'Test Events', 1, 'images/icagenda/frontend/images/cloudy-field-280x244-2.jpg', '', 1, '', '', '2019-11-30 20:00:00', '2019-11-30 21:00:00', 'a:1:{i:0;s:16:\"2019-11-30 20:00\";}', 'a:1:{i:0;s:16:\"0000-00-00 00:00\";}', '2019-11-30 20:00:00', '', 'The place to be', 'https://www.google.com', 'test@test.com', '32475123456', '', '', '', '', '', 0.0000000000000000, 0.0000000000000000, '', '<p>Text</p>', '', ''),('', 0, 0, 1, 1, 613, 0, '0000-00-00 00:00:00', 'Test Marc 2', 'testmarc2', 1, '*', 1, '2019-09-11 13:04:48', 0, '', 'marc@woluweb.be', '0000-00-00 00:00:00', 0, 'Test Events', 1, 'images/icagenda/frontend/images/cloudy-field-280x244-2.jpg', '', 1, '', '', '2019-12-30 22:00:00', '2019-12-30 23:00:00', 'a:1:{i:0;s:16:\"2019-12-30 22:00\";}', 'a:1:{i:0;s:16:\"0000-00-00 00:00\";}', '2019-12-30 22:00:00', '', 'The place to be', 'https://www.google.com', 'test@test.com', '32475123456', '', '', '', '', '', 0.0000000000000000, 0.0000000000000000, '', '<p>Text</p>', '', '');
INSERT INTO `#__icagenda_events`
$colnames = array("id", "asset_id", "ordering"); // nom des colonnes, liste à compléter...
$table = $db->quoteName('#__icagenda_events'); // nom de la table
Commentaire