'; $t .= 'Zobacz także:'; for($i=0; $i%s', $url, $name); if($i < count($id) -1) $t.='•'; } $t .= ''; return $t; } function showTutorials($cat = 'podstawy', $order = 'algorithm', $sort = 'DESC', $offset = 0, $limit = false, $noUl = false, $customSql = false) { switch($order) { case 'date': $order = 'date'; break; case 'id': $order = 'id'; break; case 'random': $order = 'RAND()'; break; //default: $order = '(1-0.48*commercial)*sqrt(datediff(now(),date)) * (SELECT max(views)+1 FROM toc)/(views + 1)'; //default: $order = '(1-0.68*commercial)*(SELECT max(views)+1 FROM toc)/(views + 1)'; default: $order = '(1-0.65*commercial)*(sqrt(datediff(now(),date)+1))/(2*POW(views,2)+1)'; } $table = array(); if($sort == 'DESC') $sort = 'DESC'; else $sort = 'ASC'; if($cat == '*') $sql = mysqli_query($conn, 'SELECT id,name,description,alias,commercial,level,date,ROUND(1+(POW(2,commercial))*2*POW((views-(select min(views) from toc))/(select max(views) from toc),0.45),0) AS popularity,api FROM toc WHERE id<900 AND tocable =1 ORDER BY '.$order.' '.$sort.($limit ? sprintf(' LIMIT 0,%d',$limit) : '')); else $sql = mysqli_query($conn, 'SELECT id,name,description,alias,commercial,level,date,ROUND(1+(POW(2,commercial))*2*POW((views-(select min(views) from toc))/(select max(views) from toc),0.45),0) AS popularity,api FROM toc WHERE '.($cat != 'zasoby' ? 'id < 900 AND ' : '').'tocable = 1 AND (id IN (SELECT tutorial_id FROM PoznajGoogleMaps_tagged WHERE tag_id = "'.$cat.'")) ORDER BY '.$order.' '.$sort.($limit ? sprintf(' LIMIT 0,%d',$limit) : '')); if($customSql) { $sql = mysqli_query($conn, 'SELECT id,name,description,alias,commercial,level,date,ROUND(1+(POW(2,commercial))*2*POW((views-(select min(views) from toc))/(select max(views) from toc),0.45),0) AS popularity,api FROM toc WHERE '.$customSql); } while($read = mysqli_fetch_array($sql)) { $tutorial = new Tutorial((int) $read['id']); $tutorial -> offset = $offset; $tutorial -> setName($read['name']); $tutorial -> setType('poradnik'); $tutorial -> setAlias($read['alias']); $tutorial -> setLevel((int) $read['level']); $tutorial -> setDescription($read['description']); $tutorial -> setCommercial(($read['commercial']=='1'? true : false)); $tutorial -> setDate($read['date']); $tutorial -> set('views',$read['views']); $tutorial -> set('popularity',$read['popularity']); $tutorial -> set('api',$read['api']); $table[] = $tutorial; } for($i=0;$igetName(); $id = $table[$i]->getID(); $lock = (($table[$i]->isCommercial()) ? '
' : ''); switch($table[$i]->get('api')) { case 5: $api_text = ''; break; case 3: $api_text = '
API v3
'; break; default: $api_text = '
API v2
'; break; } $description = $table[$i]->getDescription(); $icon = ($table[$i]->getImage() ? $table[$i]->getImage() : '/ikony/poradniki/000.jpg'); $url =$table[$i]->getUrl(); if($cat) $url.='?tag='.$cat; printf('

%s

%s%s

%s


',$id,$url,$title,$icon,$lock,$api_text,$description); } } function tutorialData($n,$t) { $sql = mysqli_query($conn, 'SELECT name,description,alias,id FROM toc WHERE id = '.$n); $read = mysqli_fetch_array($sql); if($read) { switch($t) { case 'name': return $read['name']; break; case 'url': return sprintf('/poradnik/%03d_%s.html',$read['id'],$read['alias']); break; } } else { return ''; } } function exampleData($n,$link='rich') { global $root; $s = split("\.",$n); $tid = $s[1]; $cid = $s[0]; if($link=="rich") return sprintf('przykład %spokaż kod przykładu',$root,$cid,$tid,$root,$cid,$tid,$tid,$root,$cid,$tid,$root,$cid,$tid); else return sprintf('%s',$root,$cid,$tid,$root,$cid,$tid,$tid); } function social($current_tutorial, $alias='poradnik') { $address = 'http://gmapsapi.com'.$current_tutorial->getUrl(); $description = 'Google Maps API: '.str_replace(" ","%20",$current_tutorial->getName()); print '

Dodaj stronę do ulubionego serwisu społecznościowego

'; print ''; } function more($current_tutorial, $ignoreAPI = false) { if($ignoreAPI == true) { $sql = mysqli_query($conn, sprintf('SELECT id,name,alias,description FROM toc WHERE id IN (SELECT tutorial_id FROM PoznajGoogleMaps_tagged WHERE tag_id IN (SELECT tag_id FROM PoznajGoogleMaps_tagged WHERE tutorial_id = %d)) AND id != %d AND views>0 ORDER BY views DESC LIMIT 0,4;',$current_tutorial->getID(),$current_tutorial->getID())); } else { $sql = mysqli_query($conn, sprintf('SELECT id,name,alias,description FROM toc WHERE api="%d" AND id IN (SELECT tutorial_id FROM PoznajGoogleMaps_tagged WHERE tag_id IN (SELECT tag_id FROM PoznajGoogleMaps_tagged WHERE tutorial_id = %d)) AND id != %d AND views>0 ORDER BY views DESC LIMIT 0,4;', $current_tutorial->get('api'),$current_tutorial->getID(),$current_tutorial->getID())); } if(mysqli_num_rows($sql)>0) { print '

Polecane artykuły

'; social($current_tutorial); print '

Oto, co najczęściej czytają internauci, którzy przeczytali ten artykuł:

'; //print '
    '; if($ignoreAPI == true) { $query = sprintf('id IN (SELECT tutorial_id FROM PoznajGoogleMaps_tagged WHERE tag_id IN (SELECT tag_id FROM PoznajGoogleMaps_tagged WHERE tutorial_id = %d)) AND id != %d AND views>0 ORDER BY (1-0.48*commercial)*POW(0.01*datediff(now(),date)+1,2) * (SELECT max(views)+1 FROM toc)/(views + 1) ASC LIMIT 0,4;',$current_tutorial->getID(),$current_tutorial->getID()); } else { $query = sprintf('api = "%d" AND id IN (SELECT tutorial_id FROM PoznajGoogleMaps_tagged WHERE tag_id IN (SELECT tag_id FROM PoznajGoogleMaps_tagged WHERE tutorial_id = %d)) AND id != %d AND views>0 ORDER BY (1-0.48*commercial)*POW(0.01*datediff(now(),date)+1,2) * (SELECT max(views)+1 FROM toc)/(views + 1) ASC LIMIT 0,4;',$current_tutorial->get('api'),$current_tutorial->getID(),$current_tutorial->getID()); } showTutorial($query); //print '

'; print '
'; print '
'; } } function basics($api,$curid=1) { if($api == 2) { $q = mysqli_query($conn, 'SELECT id,alias,name,description FROM toc WHERE id IN (SELECT tutorial_id FROM PoznajGoogleMaps_tagged WHERE tag_id = "podstawy") ORDER BY id ASC;'); $offset = 0; } else { $q = mysqli_query($conn, 'SELECT id,alias,name,description FROM toc WHERE id IN (SELECT tutorial_id FROM PoznajGoogleMaps_tagged WHERE tag_id = "apiv3") ORDER BY id ASC;'); $offset = 100; } $basics = array(); while($read = mysqli_fetch_array($q)) { $b = new Tutorial((int) $read['id']); $b -> setName($read['name']); $b -> setAlias($read['alias']); $b -> setDescription($read['description']); array_push($basics,$b); } $html = ''; $html .= '
'; if($next) $html = sprintf('

Tytuł następnej części kursu to %s

%s',$next->getUrl(),$next->getName(),$next->getName(),$html); return $html; } ?> setName($read['name']); $page -> setDescription($read['description']); $page -> setAlias($read['alias']); $page -> header = ($read['header'] == 0 ? false : true); } } elseif($tutorial_id) { $sql = mysqli_query($conn, 'SELECT id,name,description,alias,commercial,level,date,oldcat,views,ROUND(1+(POW(2,commercial))*2*POW((views-(select min(views) from toc))/(select max(views) from toc),0.45),0) AS popularity,api FROM toc WHERE id = '.$tutorial_id); if($read = mysqli_fetch_array($sql)) { $tutorial = new Tutorial((int) $read['id']); $tutorial -> offset = $offset; $tutorial -> setName($read['name']); $tutorial -> setType($cat); $tutorial -> setAlias($read['alias']); $tutorial -> setLevel((int) $read['level']); $tutorial -> setDescription($read['description']); $tutorial -> setCommercial(($read['commercial']=='1'? true : false)); $tutorial -> setDate($read['date']); $tutorial -> set('category',$read['oldcat']); $tutorial -> set('views',$read['views']+1); $tutorial -> set('popularity',$read['popularity']); $tutorial -> set('api',$read['api']); $tutorial -> hit(); } $sql = mysqli_query($conn, 'SELECT id, name FROM PoznajGoogleMaps_tags WHERE id in (SELECT tag_id FROM PoznajGoogleMaps_tagged WHERE tutorial_id ="'.$tutorial_id.'")'); $cats = array(); while($read = mysqli_fetch_array($sql)) { array_push($cats,$read); } if($tutorial) $tutorial -> set('cats',$cats); } ?> <? if($page) printf('Poznaj Google Maps API - %s',$page -> getName()); elseif($tutorial) printf('Tutorial Google Maps API: %s',$tutorial -> getName()); else print "Poznaj Google Maps API. Przykłady, kursy i tutoriale"; ?> getDescription()); elseif($tutorial) printf(" %s",$tutorial->getDescription()); ?>" />

www.gmapsapi.com

Kompleksowy kurs podstaw API, po którym mapowianie nie będzie miało przed Tobą żadnych tajemnic!

Setki przykładów, kursów i poradników z kodem gotowym do skopiowania i korzystania.

Największa strona o Google Maps API w Polsce, największe źródło informacji w języku polskim.