php - pulling mysql data for timelinejs? -

-

i'm trying pull data mysql database create json file use timelinejs timeline. problem json file must formatted way. i've created following code formats json correctly, pulling 1 entry database (specifically last entry). guys offer appreciated!

<?php $link = mysql_pconnect("localhost", "root", "********") or die("could not connect"); mysql_select_db("php_test") or die("could not select database"); $rs = mysql_query("select * timelinetest"); while($row = mysql_fetch_array($rs, mysql_assoc))      $object = array     ('timeline'=>         array(         'headline'=>'georgia history title page',          'type'=>'default',          'text'=> 'testing overview',          'startdate'=>'1700',          'asset'=>array('media'=>'titlepagemedia', 'credit'=>'titlepagecredit', 'caption'=>'titlepagecaption'),          'date'=>array(array('startdate'=>($row['startdate']), 'enddate'=>($row['enddate']), 'headline'=>($row[        'headline']), 'text'=>($row['text']), 'tag'=>'', 'asset'=>array('media'=>($row['media']), 'credit'=>($row[        'credit']), 'caption'=>($row['caption']))), ),          'era'=>array(array('startdate'=>'', 'enddate'=>'', 'headline'=>'', 'text'=>'', 'tag'=>''))          )     );  $json = json_encode($object); file_put_contents("testing.json", $json); ?>    <head>         <!-- jquery -->         <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>         <!-- begin timelinejs -->         <script type="text/javascript" src="http://cdn.knightlab.com/libs/timeline/latest/js/storyjs-embed.js"></script>         <script>             $(document).ready(function() {                 createstoryjs({                     type:       'timeline',                     width:      '800',                     height:     '600',                     source: 'http://localhost/php_test/timeline_test/testing.json',                     embed_id:   'my-timeline'                 });             });         </script>         <!-- end timelinejs -->

in while loop keep assigning (=overwriting) contents of result vector $row same (singular!) object $object. not being familiar timelinejs assume need build array in $object['timeline'] with

while($row = mysql_fetch_array($rs, mysql_assoc)) {     $object['timeline'][]=array(         'headline'=>'georgia history title page',          'type'=>'default',          'text'=> 'testing overview',          'startdate'=>'1700',          'asset'=>array('media'=>'titlepagemedia', 'credit'=>'titlepagecredit', 'caption'=>'titlepagecaption'),          'date'=>array(array(             'startdate'=>($row['startdate']),             'enddate'=>($row['enddate']),              'headline'=>($row['headline']),             'text'=>($row['text']),             'tag'=>'',             'asset'=>array('media'=>($row['media']),             'credit'=>($row['credit']),             'caption'=>($row['caption'])))),          'era'=>array(array('startdate'=>'', 'enddate'=>'', 'headline'=>'', 'text'=>'', 'tag'=>''))          ); }

this same array_push($object['timeline'], ...) , append data each of result rows array 'timeline' in $object.

edit

now loop fill arrays date , era within $object['timeline'] (although there no real data in era):

$object=array('timeline'=>array(     'headline'=>'georgia history title page',      'type'=>'default',      'text'=> 'testing overview',      'startdate'=>'1700',      'asset'=>array('media'=>'titlepagemedia', 'credit'=>'titlepagecredit', 'caption'=>'titlepagecaption'),      'date'=>array(),'era'=>array() ));  while($row = mysql_fetch_array($rs, mysql_assoc)) {     $object['timeline']['date'][]=array(             'startdate'=>($row['startdate']),             'enddate'=>($row['enddate']),              'headline'=>($row['headline']),             'text'=>($row['text']),             'tag'=>'',             'asset'=>array('media'=>($row['media']),             'credit'=>($row['credit']),             'caption'=>($row['caption'])));      $object['timeline']['era'][]=array('startdate'=>'', 'enddate'=>'', 'headline'=>'', 'text'=>'', 'tag'=>'');  }

maybe helps?


Comments

Post a Comment

Popular posts from this blog

Android : Making Listview full screen -

-
<linearlayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" tools:context=".mainactivity"> <edittext android:layout_margintop="5dp" android:layout_width="match_parent" android:layout_height="50dp" android:background="@drawable/location_edittext" android:id="@+id/locationeditext" android:textsize="15sp" android:textcolor="#999" android:paddingleft="15dp" /> <com.example.ravi_gupta.slider.viewpagercustomduration android:layout_width="wrap_content" android:layout_height="0dp" android:id="@+id/viewpager" android:scrollbarstyle="outsideoverlay" android:layout_weight="0.5...
Read more

javascript - Parse JSON from the body of the POST -

-
i'm using cameratag.com record video on website. service can send json response server can save data database. don't know how proceed here: the documentation states please note json repsonse passed in body of post , not form parameters. here example of how parse response in ruby: data = json.parse(request.raw_post) video_uuid = data["uuid"] but don't know how data on javascript. i'm not experienced in js please bare me :) post sample: { "uuid": "00012710-4b65-0131-ffe6-22000a499ea4", "camera_uuid": "98373a20-79ee-0130-3e42-1231390fcc11", "created_at": "2013-12-20t05:25:02.000z", "percent_complete": 100, "short_code": "kktb4q", "metadata": { }, "state": "published", "recorded_from": "http://singwho.com", "publish_type": null, "formats": [ { "name...
Read more

Automatically Create Database in Entity Framework 6 with Automatic Migrations Disabled -

-
i able automatically create new database, if not exist, using code-first ef6 automatic migrations disabled. if recall correctly, before automatic migrations existed in entity framework, worked fine. however, in ef6, receive following exception: an exception of type 'system.data.entity.migrations.infrastructure.automaticmigrationsdisabledexception' occurred in entityframework.dll not handled in user code additional information: unable update database match current model because there pending changes , automatic migration disabled. either write pending model changes code-based migration or enable automatic migration. set dbmigrationsconfiguration.automaticmigrationsenabled true enable automatic migration. to verify exception not caused external factor in production project, created new test project. however, same exception. for database context, have: public class mycontext : dbcontext { public dbset<entity> entities { get; set; } ...
Read more