korbaach's Recent Forum Activity

  • Ajax Request URL..

  • I store information in array because I do not want to display full path to video..

    let's say you have on server something like this..

    you can use list.php to get all sub-folders and files in video folder

    <?php
    function listFolderFiles($dir){
        $ffs = scandir($dir);
       
        foreach($ffs as $ff){
            if($ff != '.' && $ff != '..'){
               echo $ff. PHP_EOL;
             if(is_dir($dir.'/'.$ff)) listFolderFiles($dir.'/'.$ff);}}}
    
    listFolderFiles('video');
    exit;
    ?>[/code:ewugl4oe]
    so..your ajax data will look like this:
    [img="http://lookpic.com/O/i2/1364/e8EIVxSr.png"]
    
    now you can loop through data and populate array and list object..
    
    [url=https://app.box.com/s/nozesa4msrfq346aoohpq8ovmaicxvic]phpDir2List.capx[/url]
    
    if you upload a new videos or delete..even sub-folders in [b]videos/video[/b] folder..
    you do not have to make any changes in php script or C2 code...
  • something like this?

    demo2video.capx

  • Array

    Array properties

    Width (X dimension)

    Height (Y dimension)

    Depth (Z dimension)

    The size of the array. If you want a one-dimensional array (i.e. a list of values), use A x 1 x 1. If you want a two-dimensional array (i.e. a grid of values) use A x B x 1.

    in c2 is necessary to determine all three dimensions

    ....................

    Table Persons

    C2 Array

    so..PHP script transform Rows to Columns & columns2rows..

    $size = array(4,2,1);[/code:2clsnhon]
    in this case
    [b]$size = array(Rows[/b](4)[b],Columns[/b](userName&userContact)[b],1);[/b]
    
    php script to check [b]$size[/b]
    [code:2clsnhon]<?php
    $servername = "yourServerName.com";
    $username = "yourUserName";
    $password = "yourPassword";
    $dbname = "yourDatabaseName";
    
    $conn = new mysqli($servername, $username, $password, $dbname);
    
            if ($conn->connect_error) 
    		  {
            die("Connection failed: " . $conn->connect_error);
              } 
    
    $sql="SELECT * FROM Persons ";
    
    if ($result=mysqli_query($conn,$sql))
      {
      
      $rowcount=mysqli_num_rows($result);
      $columncount=mysqli_num_fields($result);
                $size=( 'array('.$rowcount. ',' .$columncount.',1)' ) ;
                echo($size);
     
                mysqli_free_result($result);
      }
    
    mysqli_close($conn);
    exit();
    ?>[/code:2clsnhon]
  • Try Construct 3

    Develop games in your browser. Powerful, performant & highly capable.

    Try Now Construct 3 users don't see these ads
  • Json to Array

    Persons table (userName; userContact)

    PHP file

    <?php
    $servername = "yourServerName.com";
    $username = "yourUserName";
    $password = "yourPassword";
    $dbname = "yourDatabaseName";
    
    $conn = new mysqli($servername, $username, $password, $dbname);
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    } 
    
    $size = array(4,2,1);
    
    $sql = "SELECT  userName, userContact FROM Persons";
    $result = $conn->query($sql);
    
    $response = array(
        "c2array" => true,
        "size" => $size,
        "data" => array()
    );
    
    while ( $row = $result->fetch_assoc() ) {
        $response['data'][] = array(
            array($row['userName']),
            array($row['userContact'])
        );
    }
    
    echo json_encode($response);
    $conn->close();
    exit();
    ?>[/code:26n3mbpf]
    [img="http://oi63.tinypic.com/71tn2u.jpg"]
    
    [url=https://app.box.com/s/8r2wgcc1by9il8tumqbw29x3suk9lfll]jsonPHP2Array.capx[/url]
  • {"status":true,"message":"","data":{"prize":{"name":"BONUS","description":"BONUS 25","image":"cash","promo_code":"","position":15}}}[/code:fdqspyw3]
    
    i try with JSON.Value(0,"data","prize","position"), but its not working.
    

    works for me...

  • Array(3,2,1)

    {"c2array":true,"size":[3,2,1],"data":[[["one"],[4]],[["two"],["five"]],[[3],[6]]]}[/code:jx17tizg]
    [code:jx17tizg]{"c2array":true,"size":[3,2,1],"data":
       [
         [["one"],[4]],
    	  [["two"],["five"]],
    	  [[3],[6]]
       ]
    }[/code:jx17tizg]
    
    Array(3,3,1)
    [code:jx17tizg]{"c2array":true,"size":[3,3,1],"data":[[["one"],[4],["seven"]],[["two"],["five"],["eight"]],[[3],[6],["nine"]]]}[/code:jx17tizg]
    [code:jx17tizg]{"c2array":true,"size":[3,3,1],"data":
         [ 
    	   [["one"],[4],["seven"]],
    	   [["two"],["five"],["eight"]],
    	   [[3],[6],["nine"]]
    	 ]
    }[/code:jx17tizg]
    
    you can use Browser object
    [img="http://lookpic.com/O/i2/1996/vONpZEP6.png"]
    
    check also [url=https://www.scirra.com/forum/array-contents-editor-2d-3d-beta_t120926]Array contents editor[/url]
  • maybe you can use Video plugin...

    Mixing the File Chooser and Video plugin

  • i have an online SQL DataBase. And i need to import all table data in some rows into c2 project as listbox items.

    a little explaine - i have such rows as UserName and his contact. so i want to import this data into project on construct2 as listbox items. for each tabledata (userName and UserContact) separate listbox item.

    maybe you can use CSV instead JSON...

    Persons table (userName; userContact)

    PHP file

    <?php
    $servername = "yourServerName.com";
    $username = "yourUserName";
    $password = "yourPassword";
    $dbname = "yourDatabaseName";
    
    // Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);
    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    } 
    
    $sql = "SELECT  userName, userContact FROM Persons";
    $result = $conn->query($sql);
    
    if ($result->num_rows > 0) {
        // output data of each row
        while($row = $result->fetch_assoc()) {
            echo  $row["userName"]. "#" . $row["userContact"] . PHP_EOL; 
        }
    } else {
        echo "0 results";
    }
    $conn->close();
    exit;
    ?>[/code:3cm5v3t1]
    
    [url=https://www.scirra.com/forum/plugin-csv-csv2array-csv2dictionary_t64326]CSV2Array Plugin[/url]
    
    [img="http://lookpic.com/O/i2/1992/B5uX7V1Y.png"]
    
    [url=https://app.box.com/s/230lpj02kzbtikkq08bx5bjg5wh89ssy]dataCSV2Array.capx[/url]
  • {"arraytext02":true,"size":[3,1,1],"data":[[["one"]],[["two"]],[[3]]]}

    {"c2array":true,"size":[3,1,1],"data":[[["one"]],[["two"]],[[3]]]}]

    not "yourFileName":true,"size":..... OR "yourArrayName":true,"size":.....

    it's always c2array !!!

korbaach's avatar

korbaach

Member since 9 Sep, 2014

Twitter
korbaach has 3 followers

Trophy Case

  • 10-Year Club
  • Coach One of your tutorials has over 1,000 readers
  • Email Verified

Progress

12/44
How to earn trophies