Happy Codings - Programming Code Examples

Php Programming Code Examples

Php > MySQL Code Examples

Table and Field Information

Table and Field Information

<?php 
    mysql_connect("localhost", "mysql_username", "mysql_password"); 
    mysql_select_db("mysql"); 
    $result = mysql_query("SELECT * FROM func"); 
    $fields = mysql_num_fields($result); 
    $rows   = mysql_num_rows($result); 
    $table = mysql_field_table($result, 0); 
    echo "Your '".$table."' table has ".$fields." fields and ".$rows." record(s)\n"; 
    echo "The table has the following fields:\n"; 
    for ($i=0; $i < $fields; $i  ) { 
        $type  = mysql_field_type($result, $i); 
        $name  = mysql_field_name($result, $i); 
        $len   = mysql_field_len($result, $i); 
        $flags = mysql_field_flags($result, $i); 
        echo $type." ".$name." ".$len." ".$flags."\n"; 
    } 
    mysql_free_result($result); 
    mysql_close(); 
?>

Inputs Few Numbers Performs Merge Sort - Input few numbers & perform 'Merge Sort' on them using recursion. C program to performs merge sort. Merge sort is a sorting algorithm with complexity of O(nlogn) and It is used for

C++ Implementing B-Tree Data Structure - This C++ Program implements The "B-Tree" data structure. B-tree is a tree data structure that keeps "data sorted" and allows searches, sequential access & insertions in logarithmic

C Code Demonstration of Tree Operations - Program demonstration of Tree Operations - insertion, inorder, preorder, postorder. Enter the number of terms you want to add to the tree. Repeated entry error value rejected...

Count Alphabets Digits Special Characters - C program Count total number of Alphabets, Digits or 'Special Characters' in a string using Loop. How to find total number of alphabets, digits & special characters in a string in The C

Calling by reference is a little bit the same - It affects the "value of the variable" from the Parameter List. There is a possibility to use the default values for the parameters in the parameters list. In this case you can assign a

C Programs Calculates the Value of sin(x) - C Program Coding to Calculates the Value of sin(x). It's a non-differentiable function. Start at zero, then goes up to 1, then back down to 0. But then, instead of Going Negative, it will

Singly Linked list Program Using functions - In C++, under the simplest form, each node is composed of data and a reference ('a link') to the next node in the sequence. This structure allows for efficient insertion or removal of the

Count the Numbers of Vowels Consonants - This program takes string input from the user Stores in variable line. Initially, the 'Variables' 'vowels', 'consonants', 'digits' and 'spaces' are initialized to 0. When the "vowel character" is