/modules/snippets/ajax/get_snippet.php
PHP | 38 lines | 38 code | 0 blank | 0 comment | 5 complexity | 4d401e6e5437072e33a3fdb0e5227c88 MD5 | raw file
- <?php
- include('../../../config.php');
- include('../../../mysql.php');
- ?>
- <link rel="stylesheet" type="text/css" href="<?php echo $basehref; ?>modules/snippets/js/tagging.css" />
- <script type="text/javascript" src="<?php echo $basehref; ?>modules/snippets/js/tagging.js"></script>
- <?php
- $id = $_GET['id'];
- if(isset($link) && isset($id)) {
- if ($link && is_numeric($id)) {
- $sql = "SELECT snippets.`id` AS `id`,
- snippets.`snippet_name` AS snippet_name,
- snippets.`snippet_code` AS snippet_code,
- DATE_FORMAT(snippets.`created`, '%b %e %Y, %l:%i %p') AS fcreated,
- DATE_FORMAT(snippets.`modified`, '%b %e %Y, %l:%i %p') AS fmodified,
- snippets.`created` AS `created`,
- snippets.`modified` AS `modified`
- FROM snippets
- WHERE snippets.`id` = '" . $id . "'";
- }
- $fetch = mysql_query($sql);
- while ($row = mysql_fetch_array($fetch, MYSQL_ASSOC)) {
- $id = $row['id'];
- $snippet_name = $row['snippet_name'];
- $snippet_code = $row['snippet_code'];
- $fcreated = $row['fcreated'];
- $fmodified = $row['fmodified'];
- $modified = $row['modified'];
- $created = $row['created'];
- ?>
- <p><strong><?php echo $snippet_name; ?></strong></p>
- <p><pre>
- <?php echo $snippet_code; ?>
- </pre></p>
- <?php
- }
- }
- ?>