Online PHP editor | output for YMnon

<?php try { $db = new PDO('sqlite::memory:'); } catch(PDOException $e) { die($e->getMessage()); } $db->exec("CREATE TABLE demo (id integer primary key, name varchar(20), hint text);"); $sql = <<<SQL insert into demo ("id", "name", "hint") values ('1', 'SqLite', 'is a relational database management system contained in a C programming library'); insert into demo ("id", "name", "hint") values ('2', 'jQuery', 'is a cross-platform JavaScript library designed to simplify the client-side scripting of HTML'); insert into demo ("id", "name", "hint") values ('3', 'HTML5', 'is a core technology markup language of the Internet used for structuring and presenting content for the World Wide Web'); insert into demo ("id", "name", "hint") values ('4', 'dQj T pHomTrunNxXQP', 'V zTv QUAG'); insert into demo ("id", "name", "hint") values ('5', 'lHlCIFRgbvJJsX JRQil', 'rgkpNiKVtb'); insert into demo ("id", "name", "hint") values ('6', 'AsaEkgRzIfrqFBwayv P', 'K mwgC uZ'); insert into demo ("id", "name", "hint") values ('7', 'UH hVCRHTxNubHkHYOfZ', 'ZBMktFyEpl'); insert into demo ("id", "name", "hint") values ('8', 'UZ INSHasHmvVxstKjvh', 'BOE BJMeNi'); insert into demo ("id", "name", "hint") values ('9', 'vodQk kXuNVaHOuTXoEW', 'AAPfpVn O'); insert into demo ("id", "name", "hint") values ('10', 'SxJVShM coppvRNBYqN', 'ozex OWzRK'); insert into demo ("id", "name", "hint") values ('11', 'CddXfTUKrVqEzEFpCi', 'Xs NmELFmK'); insert into demo ("id", "name", "hint") values ('12', 'xqoaCV vgUdeDYNZZeGo', 'dsh uY To'); insert into demo ("id", "name", "hint") values ('13', 'AeQHoNwbPTBDi DUuugm', 'aJWYUoHrY'); insert into demo ("id", "name", "hint") values ('14', 'PNuERWQzJhBvtTPAux v', 'UifJn LDDz'); insert into demo ("id", "name", "hint") values ('15', 'enOHaQpibUn Wht SCeN', 'GrfiKv qHv'); insert into demo ("id", "name", "hint") values ('16', 'b FOaflFaDb CviG iJ', 'AKjCLnILBl'); insert into demo ("id", "name", "hint") values ('17', 'OzOyhYjXbMCmUBFwbur', 'sFPudTJCI'); insert into demo ("id", "name", "hint") values ('18', 'VPW fTe JMejSaKuJY', 'ksQNfKZxEZ'); insert into demo ("id", "name", "hint") values ('19', 'YKGT tldDGMMiuRuhSHf', 'zZx YUiKAH'); insert into demo ("id", "name", "hint") values ('20', 'Ak e aephALAbnq cEQQ', 'eJIfWFSuK'); insert into demo ("id", "name", "hint") values ('21', 'wPKksIj PAt tbDnf f', 'TucCVkNc'); insert into demo ("id", "name", "hint") values ('22', 'zUSuhvMTIMBgAGhkTOOc', 'dmeNHcHhtk'); insert into demo ("id", "name", "hint") values ('23', 'njKLLERWdwFrxcT gU', 'ZZdsvXIRHy'); insert into demo ("id", "name", "hint") values ('24', 'sLMwodqcGYBtoPkKAALl', 'upITR vK R'); insert into demo ("id", "name", "hint") values ('25', 'FFoaEeetSUKQvrQrIl f', 'VF NKtVXI'); insert into demo ("id", "name", "hint") values ('26', 'tbJhdcgXrOKUDlVwOsaX', 'GQSOtAqMAc'); insert into demo ("id", "name", "hint") values ('27', 'IxgGNucQJc nM caPF', 'AsukqzpEt'); insert into demo ("id", "name", "hint") values ('28', 'HddcYxzJrigjsuwAKgim', 'RUuwrc oln'); insert into demo ("id", "name", "hint") values ('29', 'pRIwqvTgEzJThasSQBMK', 'KXbWNEdp f'); insert into demo ("id", "name", "hint") values ('30', 'YSEavyOcL VR QytfDfW', 'qk CXgGaW'); insert into demo ("id", "name", "hint") values ('31', 'BkZdEPsxtH DttOcwDtH', 'IzoxZ N eC'); insert into demo ("id", "name", "hint") values ('32', 'LPPoVHZ nmcUZPI ZyM', 'rnNMFeFizW'); insert into demo ("id", "name", "hint") values ('33', 'MHBjmRHECIsYlFZGGxiE', 'vGBRID sO'); insert into demo ("id", "name", "hint") values ('34', 'jZdrA ZlkA UiJKrAZ', 'tI lFno vo'); insert into demo ("id", "name", "hint") values ('35', 'FPAaul QbcAoFIgafhRh', 'B ZzZsh Xr'); insert into demo ("id", "name", "hint") values ('36', 'BWfMjMPqKT wSzSpuot', 'p gkR kfdX'); insert into demo ("id", "name", "hint") values ('37', 'x ZIZIhhziwuM iA ilL', 'REZv O eB'); insert into demo ("id", "name", "hint") values ('38', 'k IjEH YrPUMKMyISIlE', 'sfgUWBDvpy'); insert into demo ("id", "name", "hint") values ('39', 'EDAi VFpM KLBAon ovj', 'tgKr OhCXX'); insert into demo ("id", "name", "hint") values ('40', 'Vr ogiUfYbkaeY dJazC', 'kL m rwZ'); insert into demo ("id", "name", "hint") values ('41', 'ojUDKEECfaQeUDtpEV o', 'SnqYamvrl'); insert into demo ("id", "name", "hint") values ('42', 'TiYmpbMb WPiId NwmJC', 'Dt UyLz C'); insert into demo ("id", "name", "hint") values ('43', 'zLFwYZSMEphIkTP GPvj', 'cPLq mkpv'); insert into demo ("id", "name", "hint") values ('44', 'DZHdsKzczTg NYXLjWVX', 'c tsVGeoKX'); insert into demo ("id", "name", "hint") values ('45', 'DcT qdQOZEOkKVFLH aD', 'ZEyPCWP dm'); insert into demo ("id", "name", "hint") values ('46', 'ITdbFfkHvIFiTsGuLWer', 'iY Im XwL'); insert into demo ("id", "name", "hint") values ('47', 'XHlaqx Dln dNpn CXys', 'mmaWtwe yD'); insert into demo ("id", "name", "hint") values ('48', 'sz GKTxH u LSZhhd', 'txd UVdYg'); insert into demo ("id", "name", "hint") values ('49', 'killMZ OfsgEqADkD fN', 'WGwaeHvs'); insert into demo ("id", "name", "hint") values ('50', 'ek lIEEq LTwrbTuwHhN', 'UuRRMpBNpb'); insert into demo ("id", "name", "hint") values ('51', 'fqRq lWGA uxWNACcsv', 'rNWVLP RpA'); insert into demo ("id", "name", "hint") values ('52', 'fjindCjXtFkmkgVUJJTc', 'bBISlGMhuF'); insert into demo ("id", "name", "hint") values ('53', 'VuJIYJDEKfmkvaCOVad', 'XWpwJSo s'); insert into demo ("id", "name", "hint") values ('54', 'n XkCvfdfjgdfDeC Yud', 'iMiNWaxsna'); insert into demo ("id", "name", "hint") values ('55', 'KgOIDBgCGzRhmQtZid', 'xMtobspG j'); insert into demo ("id", "name", "hint") values ('56', 'YNkJlnZTPt AP Rv zJi', 'CewfXoqr s'); insert into demo ("id", "name", "hint") values ('57', 'RFij nJkHREmHwXzFfDk', 'Cw ulimEm'); insert into demo ("id", "name", "hint") values ('58', 'sJlbQnadFiEdPYvuRMnC', 'XBNRUb H G'); insert into demo ("id", "name", "hint") values ('59', 'vbQxGCvpnraZrvYqDk', 'szoVuQPFl'); insert into demo ("id", "name", "hint") values ('60', 'Wqq RtGMhy lQ AygT', 'fjVa v UN'); insert into demo ("id", "name", "hint") values ('61', 'lQER n GCRcahNdxKYFf', 'wESxmgagp'); insert into demo ("id", "name", "hint") values ('62', 'ofek xMiwM GwOyZ Al', 'GyFhelDZpC'); insert into demo ("id", "name", "hint") values ('63', 'ZLKqfnDd OQrk J qQ', 'RrIKoFaFIb'); insert into demo ("id", "name", "hint") values ('64', 'Sw nYIBbBLLImDXn ISs', 'O N uMmVYt'); insert into demo ("id", "name", "hint") values ('65', 'L U coFFIfXSI uBtIh', 'euuwmwCgWX'); insert into demo ("id", "name", "hint") values ('66', 'kvkkabSoI qCQeH mtf', 'nbOprLArRI'); insert into demo ("id", "name", "hint") values ('67', 'MHfog bZqJQVtvDDA DG', 'FrYK BdzHs'); insert into demo ("id", "name", "hint") values ('68', 'mlLTLSeWZdzLLRCnvFVh', 'UnWfbVNq q'); insert into demo ("id", "name", "hint") values ('69', 'Ns iiLLmGkAvoTSP hwY', 'GzbDDcSxRO'); insert into demo ("id", "name", "hint") values ('70', 'PKHNKiNWRgnM oHJj Xh', 'snVqrSMRNT'); insert into demo ("id", "name", "hint") values ('71', 'sipLoDSxKdc nx Muivk', 'gkcSHZafXw'); insert into demo ("id", "name", "hint") values ('72', 'RVylebD LA JK LZ VJ', 'HyZDcCLVpu'); insert into demo ("id", "name", "hint") values ('73', 'kNjxL y FZagnNzBASc', 'ahC v IE'); insert into demo ("id", "name", "hint") values ('74', 'eDhmbDADrvmCCq cpBtY', 'PC foQoju'); insert into demo ("id", "name", "hint") values ('75', 'xlbwLcIvaCv UIclOOwu', 'NtunhmuWUg'); insert into demo ("id", "name", "hint") values ('76', 'AdsOiueisjoDHY BomkG', 'zCwMVw NaO'); insert into demo ("id", "name", "hint") values ('77', 'SHpWsGfLtEebdb eQcpS', 'PbrXcYFNhC'); insert into demo ("id", "name", "hint") values ('78', 'G JPbiSba KmWUV oYpd', 'mFfOnJVspD'); insert into demo ("id", "name", "hint") values ('79', 'Gb TTHcnIcRRFdZC vft', 'lJf mOWSJ'); insert into demo ("id", "name", "hint") values ('80', 'kPMWtBbrSjdc YdJYppI', 'xyaPXpEmOl'); insert into demo ("id", "name", "hint") values ('81', 'DiaDlNxrzaHVIFZqO jL', 'SIOM aSxww'); insert into demo ("id", "name", "hint") values ('82', 'PttazsuVyOfyiGFvpWOh', 'MZTrzFEyxU'); insert into demo ("id", "name", "hint") values ('83', 'izW sLHBd Buy CAC pw', 'QRofnqaDB'); insert into demo ("id", "name", "hint") values ('84', 'nfvSByXlaYLnL R qjX', 'HAIthjlMRL'); insert into demo ("id", "name", "hint") values ('85', 'AodbpVdMi DgZqf AykR', 'QIRqYZJcsJ'); insert into demo ("id", "name", "hint") values ('86', 'GKEiSijznj TbOxECGYr', 'AIGjcSQ kH'); insert into demo ("id", "name", "hint") values ('87', 'wfbvLoKRpFl VEf JNqj', 'xByGUrtUcz'); insert into demo ("id", "name", "hint") values ('88', 'gAmcj TzobKSkaWbjp', 'LpeNuohv c'); insert into demo ("id", "name", "hint") values ('89', 'dDLPUpDDIeAVEXIx oll', 'TCO ZLdldk'); insert into demo ("id", "name", "hint") values ('90', 'Qkm fvcCqhETJ k BjHO', 'KoVfcGhHXc'); insert into demo ("id", "name", "hint") values ('91', 'UKqWiSAnAy VZViuOoZW', 'uDPzzWWJCR'); insert into demo ("id", "name", "hint") values ('92', 't Ez UjGGDa HHPe BLs', 'cyMdPMZmHW'); insert into demo ("id", "name", "hint") values ('93', 'CPk kktCOIgbo ZQFqmp', 'A bZEmzGb'); insert into demo ("id", "name", "hint") values ('94', 'G fLcIpVIghe LGBlKp', 'bfHj JRQif'); insert into demo ("id", "name", "hint") values ('95', 'vhcl msnV qWdonHhDZc', 'mkqyAb TYn'); insert into demo ("id", "name", "hint") values ('96', 'eB LDyyiuvVO AUWGmac', 'ZdvnGIqlBJ'); insert into demo ("id", "name", "hint") values ('97', 'mFCVFgD cfGYGJ Bbiu', 'JjCYmVDHM'); insert into demo ("id", "name", "hint") values ('98', 'QGdAKkHcr KQrrO r', 'gDWWFKDELx'); insert into demo ("id", "name", "hint") values ('99', 'wW XUyj UpsgpSAtkPCk', 'vh K H CR'); insert into demo ("id", "name", "hint") values ('100', 'nOk vLLPGaojzmeNd XR', 'VDqbOH Jrb'); insert into demo ("id", "name", "hint") values ('101', 'vkJf wZdPquAHksIMLa', 'AAWDW EeE'); insert into demo ("id", "name", "hint") values ('102', 'PUz Mnln VAnwxDDTH', 'lm ssGF st'); insert into demo ("id", "name", "hint") values ('103', 'bgYCzmlBjJfBBmTVfxmt', 'zjffg vpFJ'); insert into demo ("id", "name", "hint") values ('104', 'z rJxVhyhJTqqjYFDf', 'dOUt dx K'); insert into demo ("id", "name", "hint") values ('105', 'nRauF QscNB KKAAdJ Y', 'tsLgDvUn O'); insert into demo ("id", "name", "hint") values ('106', 'WUy WCUiaQ VLO CCjnq', 'JnBEiRFwS'); insert into demo ("id", "name", "hint") values ('107', 'NWKqe YMXTGhyngzCkKN', 'cZ SQkkv k'); insert into demo ("id", "name", "hint") values ('108', 'v UWAUGRrYZlxoF CClq', 'nmxbyFsn x'); insert into demo ("id", "name", "hint") values ('109', 'zFInxPZojhehT lhe z', 'Ot gYOgeQ'); insert into demo ("id", "name", "hint") values ('110', 'RVrGtqGoIc vpBi H FI', 'rcbIl Ev'); insert into demo ("id", "name", "hint") values ('111', 'g vibvrxTSpJ Vrivk q', 'XOHSlQavGn'); insert into demo ("id", "name", "hint") values ('112', 't qAXHre nUKpv gzvsG', 'IqyaJsAens'); insert into demo ("id", "name", "hint") values ('113', 'LRviYEp RW xdcvs CPs', 'G qlbSqZtq'); insert into demo ("id", "name", "hint") values ('114', 'mFCLs OcLhalpOadfsSy', 'nWksOdoGK'); SQL; $db->exec($sql); $data = $db->query("SELECT id,name,hint FROM demo ORDER BY id DESC LIMIT 20;")->fetchAll(PDO::FETCH_OBJ); print_r($data);