Software Solutions and Services

  JDO Tutorials
  EAI Articles
  Struts Tutorials
  Java Tutorials
  Java Certification
  Java Applet

Questions

convert to java plss
hi i am using microsoft VB6.0 and my friend ask me to make java program to convert number to words but i only use visual
java program
if c = 2 find d = ++c++++4 answer shows 3+2+4+1 9+1 10 I think d = operator mistake, pls clarify what operator
java program
if int a = 48 find a = a+++++a answer shows 48+49+1 97+1 98 pls clarify find a equation, as I think there some
java
program concept behind inheritance in java
Java File
Hi Friend, Thank you for the support I got previously... Anyone please send me the Java Code for scanning a direct
password protected zip file creation exmpale coded neaded
am able to create a zip file and able to read the file but password protection need please help
java
any programs on combination generation pls...
deteminant
wap to find the determinant of any order matrix
java
i want to know the program for transversal sort. thanks
java
pl. let me know few progrograms on encapsulation. thanks
All Questions...

Comments

PHP SQL Query
Most of the applications need to interact with database to store, update and fetch the data. This interaction is made executing Sql queries.

PHP SQL Query

This example illustrates how to create and execute the sql query in php application.

Most of the applications need to interact with database to store, update and fetch the data. This interaction is made executing Sql queries. To understand how to use sql queries in php, we have created sql_query.php page. First, connection from database is created using mysql_connect("hostName", "userName", "Password"), selected the database by mysql_select_db("databaseName", connectionObject). Now, the query "SELECT name, designation FROM employee" is executed using mysql_query() method to get name and designation of all employees.

Source Code of sql_query.php


<?php

  $con = mysql_connect("localhost","root","root");

  if (!$con) {

    die('Could not connect: ' . mysql_error());

  }



  mysql_select_db("test", $con);

  $result = mysql_query("SELECT name, designation FROM employee");

  

  while ($row = mysql_fetch_array($result)) {

    echo $row['name']." ||| ";

    echo $row['designation'];    

    echo "<br>";

  }



  if (!$result) {

    $message  = 'Invalid query: ' . mysql_error() . "\n";

    $message .= 'Whole query: ' . $query;

    die($message);

  }  



  mysql_free_result($result);

?>

Download Source Code

Output:

� View all related tutorials

Related Tags: sql mysql c table sed tab if ie record records to ci e use trie pe from m tr spec

Leave your comment:
Name:
Email:
URL:
Title:
Comments:
Enter Code:
	Note: Emails will not be visible or used in any way, and are not required. Please keep comments relevant. Any content deemed inappropriate or offensive may be edited and/or deleted. No HTML code is allowed. Line breaks will be converted automatically. URLs will be auto-linked. Please use BBCode to format your text.