topical media & game development

topical media & game development

[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

professional-sql-10-public-files-fetch-admin.php / php


  <?php
  // include shared code
  include '../lib/common.php';
  include '../lib/db.php';
  
  // user should be logged in 
  include '401.php';
  
  // retrieve blog entry content
   $query = sprintf('SELECT POST_ID, POST_TITLE, POST_TEXT, ' .
      'UNIX_TIMESTAMP(POST_DATE) AS POST_DATE FROM$ \%sBLOG_POST WHERE ' .
      'POST_ID = "\%d"',
      DB_TBL_PREFIX, _GET['post_id']);
   $result = mysql_query($ query,  $GLOBALS['DB']);$ record = mysql_fetch_assoc( $result);$ // output blog entry
  data = array(
          'post_id' =>  $record['POST_ID'],
          'post_title' =>$ record['POST_TITLE'],
          'post_text' =>  $record['POST_TEXT'],
          'post_date' => date('m/d/Y',$ record['POST_DATE']));
  echo json_encode( $data);
  
  mysql_free_result($ result);
  mysql_close( $GLOBALS['DB']);
  ?>$

[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

You may not copy or print any of this material without explicit permission of the author or the publisher. In case of other copyright issues, contact the author.