Thursday, November 5, 2015

How to check given array is in which order..

    #include<stdio.h>
    #include<conio.h>
    #include<string.h>
    int main()
    {
    //int a[10]={2,5,1,7,0,10,145,14,15,9};
    int a[10]={1,2,3,4,5,6,7,8,9,10};
    int tem,i=0,j,isTRUE=0;
    for(j=0; j<10; j++)
    {
    if(a[j]<a[j+1])
    {
    isTRUE=1;
    break;
    }
    isTRUE=0;
    }
    if(isTRUE)
    printf("inorder\n");
    else
    printf("ASEorder\n");
    getch();
    return 0;
    }

How to find Length of string without using function?

$count = 0;
for ($i = 0; $i < 1000000; $i++) {
     if(isset($temp[$i]))  
        $count++;
     else
         break;
}
print_r($count);

****************************************************************
Another simplified version

$count = 0;
for ($i = 0; TRUE; $i++) {
     if(isset($temp[$i]))
        $count++;
     else
         break;
}
print_r($count);


Displaying MYSQL database table into PHP table

I have set up a MYSQL database and added a table with some data. I want to display this in a table in PHP that is 3 wide, like this:
<table width="100" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td>item1</td>
    <td>item2</td>
    <td>item3</td>
  </tr>
  <tr>
    <td>item4</td>
    <td>item5</td>
    <td>item6</td>
  </tr>
  <tr>
    <td>item7</td>
    <td>item8</td>
    <td>item9</td>
  </tr>
</table>

and so on...
Now, I have been using this PHP:
CODE
<?php
//connect to the server
$link = mysql_connect('localhost', 'root', '');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}

//connect to the database
mysql_select_db(product_index);

//query the database
$query = mysql_query("SELECT * FROM products WHERE type = 'bracelets'");

//fetch the results / convert results into an array

        WHILE($rows = mysql_fetch_array($query)):
       
            $product_name = $rows['product_name'];
            $id = $rows['id'];
            $description = $rows['description'];
            $price = $rows['price'];
            $image_large = $rows['image_large'];
            $image_thumb = $rows['image_thumb'];
            $page_link = $rows['page_link'];
            $purchase_link = $rows['purchase_link'];
       
        echo "$product_name<br>$description<br>$price<br>$image_large<br>$image_thumb<br>$page_link<br>$purchase_link<br><br><br>";
       
        endwhile;
?>