use Ionic framework with php files -

-

i'm creating mobile app ionic framework. got html pages created online. want backend code data sql server. receiving data no problem php. when use php pages don't have interface created ionic.

how can use php pages (instead of html) , still lay out ionic? example: scorebord.php

<?php $servername = "localhost:3306"; $username = "ssss"; $password = "dffd"; $dbname = "ddddd";  // create connection $conn = new mysqli($servername, $username, $password, $dbname); // check connection if ($conn->connect_error) {     die("connection failed: " . $conn->connect_error); }  $sql = "select user_username,user_city,user_highscore tbl_user"; $result = $conn->query($sql); ?> <ion-view style="" title="scorebord">     <ion-content class="has-header" overflow-scroll="true" padding="true" style="background: url(img/hx1ml1tvggabo3ene6qg_menu3.png) no-repeat center;">         <h1 style="">scorebord</h1>         <table style="width:100%">             <?php             if ($result->num_rows > 0) {                 // output data of each row                 while ($row = $result->fetch_assoc()) {                     ?>                      <tr>                         <td><?php echo $row["user_username"] ?></td>                      </tr>                     <?php                 }             } else {                 echo "0 results";             }             $conn->close();             ?>          </table>      </ion-content> </ion-view>

btw: safe configure database in php file that? alternative?

the mobile app saved on device can't interpret php code, unlike web server. if dont know/want javascipt iframe option.

example.com/table.php

        <h1 style="">scorebord</h1>         <table style="width:100%">             <?php             if ($result->num_rows > 0) {                 // output data of each row                 while ($row = $result->fetch_assoc()) {?>                     <tr> <td><?php echo $row["user_username"] ?></td></tr>                     <?php                 }             } else {                 echo "0 results";             }             $conn->close();             ?>         </table>

your app 

<ion-view style="" title="scorebord">     <ion-content class="has-header" overflow-scroll="true" padding="true" style="background: url(img/hx1ml1tvggabo3ene6qg_menu3.png) no-repeat center;">         <iframe src="example.com/table.php"/>     </ion-content> </ion-view>

but better solution use javascript make http requests json data or full html templates(like table.php).

i use json backend

highscores.php

<?php $servername = "localhost:3306"; $username = "ssss"; $password = "dffd"; $dbname = "ddddd";  // create connection $conn = new mysqli($servername, $username, $password, $dbname); // check connection if ($conn->connect_error) {     die("connection failed: " . $conn->connect_error); }  $sql = "select user_username,user_city,user_highscore tbl_user"; $result = $conn->query($sql); $json = mysqli_fetch_all ($result, mysqli_assoc); echo json_encode($json);

your app

angular.module('ionicapp', [])  .controller('mainctrl', function($scope, $http) {   $http.get('http://example.com/highscores.php').then(function(resp) {     $scope.users = resp.data;   }, function(err) {     console.error('err', err);   }) });    <html ng-app="ionicapp">   <body ng-controller="mainctrl">     <ion-content>       <ion-list>         <ion-item ng-repeat="user in users">           {{user.user_username}}         </ion-item>       </ion-list>     </ion-content>   </body> </html>

Comments

Post a Comment

Popular posts from this blog

ruby - Trying to change last to "x"s to 23 -

-
i have been playing around irb , have string looks this: irb(main):072:0> puts ["[\"4354 5432 5432 xxxxx\", \"6547 6547 8543 xxxxx\", \"2344 6543 6674 xxxxx\", \"2346 6236 7543 xxxxx\", \"1273 5585 5587 xxxxx\"]"] => nil irb(main):073:0> what want gsub last 2 "x" s of each 17 digit combination, 23 . what i've tried far (i've been using rubular): a.gsub(/\d[x]/,"23") <= grabs "x" s i'm close a.gsub(/\w[x{2}]/,"23") <= grabs "x" s grabs two digits each combination. is there easier way i'm not understanding? a.gsub(/\d{4} \d{4} \d{4} xxx\kxx/, '23') \d{4} = 4 digits what \k drop matched far. can use don't replace entire number, still able validate have in desired format.
Read more

jquery - Clone last and append item to closest class -

-
this bare-bones code on page: <div class="list-container"> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> </div> <p><button class="add-list-item">add</button></p> <div class="list-container"> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> </div> <p><button class="add-list-item">add</button></p> <di
Read more

c - Unrecognised emulation mode: elf_i386 on MinGW32 -

-
i'm trying make kernel, , cannot link c output assembly. ld . i'm getting error: unrecognized emulation mode: elf_i386 i'm using windows 10 professional mingw32 , msys. code using: link.ld /* * link.ld */ output_format(elf32-i386) entry(start) sections { . = 0x100000; .text : { *(.text) } .data : { *(.data) } .bss : { *(.bss) } } kernel.c /* * kernel.c */ void kmain(void) { const char *str = "my first kernel"; char *vidptr = (char*)0xb8000; //video mem begins here. unsigned int = 0; unsigned int j = 0; /* loops clears screen * there 25 lines each of 80 columns; each element takes 2 bytes */ while(j < 80 * 25 * 2) { /* blank character */ vidptr[j] = ' '; /* attribute-byte - light grey on black screen */ vidptr[j+1] = 0x07; j = j + 2; } j = 0; /* loop writes string video memory */ while(str[j] != '\0') { /
Read more