/ Published in: PHP
EShop for interviews
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
function cde($db) { if ($db->errno!=0) throw new Exception ('db error: '.$db->error); } $db = new mysqli ('','','',''); check_db(); checkout(); } add_to_basket($_GET['add_to_basket']); } delete_from_basket($_GET['delete_from_basket']); show_basket(); } show_basket(); } show_page(); //--------------------------------- function check_db() { global $db; $rez = $db->query('show tables like \'zshop\''); cde($db); if ($rez->num_rows==0) { $db->query('create table zshop( id int(11) not null auto_increment,'. 'product varchar(500), rating int(11),'. 'primary key (`id`))'); cde($db); $db->query ('insert into zshop(product, rating) select link, rating from bookm_tmp a left outer join zstat b on a.id=b.pic_id'); cde($db); } } //--------------------------------- function add_to_basket($id) { $_SESSION['basket'][] = $id; } //--------------------------------- function show_page() { global $db; $perpage = 10; $start = ($page-1)*$perpage; $rez = $db->query('select count(*) from zshop'); cde($db); $pages = $rez->fetch_row(); echo '<br/><br/>'; for ($i=0; $i<$pages; $i++) { if ($i+1==$page) { echo ($i+1); } else { echo '<a href="'.$_SERVER['PHP_SELF'].'?page='.($i+1).'">'.($i+1).'</a>'; } if (($i+1)%20==0) echo '<br/>'; } echo '<br/><br/>'; '<a href="'.$_SERVER['PHP_SELF'].'?show_basket">'. echo $nav; $stmt = $db->prepare('select id, product, rating from zshop order by id limit ?,?'); cde($db); $stmt->bind_param('dd',$start,$perpage); $stmt->execute(); $stmt->bind_result($id, $product, $rating); echo '<table>'; $i = 0; while ($stmt->fetch()) { if ($i%3==0) echo '<tr>'; $inf = $_SERVER['REQUEST_URI']; $link = 'http://freedomplace.ru/diff/php_dbg/loader.php?thumb='.$match[1]; $id.'"><img src="'.$link.'" /></a><h2>Rating: '.$rating.'</h2></td>'; if (($i+1)%3==0) echo '</tr>'; $i++; } } //--------------------------------- function show_basket() { $_SERVER['HTTP_REFERER']: $_SERVER['PHP_SELF']; $catlink = $inf['scheme'].'://'.$inf['host'].$inf['path']; } $catlink = '<a href="'.$catlink.'">back to catalog</a>'; echo 'basket empty<br/>'; echo $catlink.'<br/>'; return; } echo $catlink.'<br/>'; global $db; $rez = $db->query('select id,product,rating from zshop where id in ('. cde($db); while ($row = $rez->fetch_assoc()) { $link = 'http://freedomplace.ru/diff/php_dbg/loader.php?thumb='.$match[1]; echo '<div><img src="'.$link.'" /><h2>Rating: '.$row['rating'].'</h2>'; echo '<a href="'.$_SERVER['PHP_SELF'].'?delete_from_basket='.$row['id']. '">delete from basket</a></div>'; } $rez->free(); echo '<h2><a href="'.$_SERVER['PHP_SELF'].'?checkout" />checkout</a></h2>'; } //--------------------------------- function delete_from_basket($id) { if ($key!==false) } //--------------------------------- function checkout() { global $db; $rez = $db->query ('select id, product, rating from zshop where cde($db); while ($row = $rez->fetch_object()) { } include($fname); }