korbaach's Recent Forum Activity

- korbaach
- - Joined 9 Sep, 2014
  - 8 topics • 1,506 posts
- 1
- 19 Sep, 2016
- Quote
Ajax Request URL..

korbaach
- Joined 9 Sep, 2014
- 8 topics • 1,506 posts
1

18 Sep, 2016
Quote

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...

- korbaach
- - Joined 9 Sep, 2014
  - 8 topics • 1,506 posts
- 1
- 16 Sep, 2016
- Quote
Try Construct 3

Develop games in your browser. Powerful, performant & highly capable.
Try Now Construct 3 users don't see these ads
- korbaach
- - Joined 9 Sep, 2014
  - 8 topics • 1,506 posts
- 1
- 16 Sep, 2016
- Quote
something like this?

demo2video.capx

korbaach
- Joined 9 Sep, 2014
- 8 topics • 1,506 posts
1

14 Sep, 2016
Quote

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]

- korbaach
- - Joined 9 Sep, 2014
  - 8 topics • 1,506 posts
- 1
- 14 Sep, 2016
- Quote

korbaach
- Joined 9 Sep, 2014
- 8 topics • 1,506 posts
1

14 Sep, 2016
Quote

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]

korbaach
- Joined 9 Sep, 2014
- 8 topics • 1,506 posts
1

13 Sep, 2016
Quote

{"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...

korbaach
- Joined 9 Sep, 2014
- 8 topics • 1,506 posts
1

13 Sep, 2016
Quote

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]

- korbaach
- - Joined 9 Sep, 2014
  - 8 topics • 1,506 posts
- 1
- 13 Sep, 2016
- Quote
maybe you can use Video plugin...

Mixing the File Chooser and Video plugin

korbaach
- Joined 9 Sep, 2014
- 8 topics • 1,506 posts
1

13 Sep, 2016
Quote

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]

- korbaach
- - Joined 9 Sep, 2014
  - 8 topics • 1,506 posts
- 1
- 11 Sep, 2016
- Quote
{"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 !!!