Login MySQL via linux shell command

MySQL syntax dari command shell linux:

Login ke mysql

$ mysql -u root -h localhost -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 4.1.15-Debian_1-log
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

USE demo;

Leave a comment

Video Conference Tools

Video and audio conferencing information


Top Video Conference Tool:


Ekiga untuk linux, windows:




Leave a comment

Greetings to the Universe in 55 Different Languages

Greetings to the Universe in 55 Different Languages

Dari: http://voyager.jpl.nasa.gov/spacecraft/greetings.html

To learn the story behind the greetings, click here

» Akkadian
“May all be very well”
» Amoy (Min dialect)
“Friends of space, how are you all? Have you eaten yet? Come visit us if you have time.”
» Arabic
“Greetings to our friends in the stars. We wish that we will meet you someday.”
» Aramaic
» Armenian
“To all those who exist in the universe, greetings.”
» Bengali
“Hello! Let there be peace everywhere.”
» Burmese
“Are you well.”
» Cantonese
“Hi. How are you? Wish you peace, health and happiness.”
» Czech
“Dear Friends, we wish you the best.”
» Dutch
“Heartfelt greetings to everyone.”
» English
“Hello from the children of planet Earth.”
» French
“Hello everybody.”
» German
“Heartfelt greetings to all.”
» Greek
“Greetings to you, whoever you are. We come in friendship to those who are friends.”
» Gujarati
“Greetings from a human being of the Earth. Please contact.”
» Hebrew
» Hindi
“Greetings from the inhabitants of this world.”
» Hittite
» Hungarian (Magyar)
“We are sending greetings in the Hungarian language to all peace-loving beings in the Universe.”
» Ila (Zambia)
“We wish all of you well.”
» Indonesian
“Good night ladies and gentlemen. Goodbye and see you next time.”
» Italian
“Many greetings and wishes.”
» Japanese
“Hello? How are you?”
» Kannada (Kanarese)
“Greetings. On behalf of Kannada-speaking people, ‘good wishes.'”
» Kechua (Quechua)
“Hello to everybody from this Earth, in Kechua language.”
» Korean
“How are you?”
» Latin
“Greetings to you, whoever you are; we have good will towards you and bring peace across space.”
» Luganda (Ganda)
“Greetings to all peoples of the universe. God give you peace always.”
» Mandarin Chinese
“Hope everyone’s well. We are thinking about you all. Please come here to visit when you have time.”
» Marathi
“Greetings. The people of the Earth send their good wishes.”
» Nepali
“Wishing you a peaceful future from the earthlings.”
» Nguni (Zulu)
“We greet you, great ones. We wish you longevity”
» Nyanja
“How are all you people of other planets?”
» Oriya
“Greetings to the inhabitants of the universe from the third planet Earth of the star Sun.”
» Persian
“Hello to the residents of far skies.”
» Polish
“Welcome, creatures from beyond the outer world.”
» Portuguese
“Peace and happiness to all.”
» Punjabi
“Welcome home. It is a pleasure to receive you.”
» Rajasthani
“Hello to everyone. We are happy here and you be happy there.”
» Romanian
“Greetings to everybody.”
» Russian
“Greetings! I Welcome You!”
» Serbian
“We wish you everything good from our planet.”
» Sinhalese
“Wish You a Long Life.”
» Sotho (Sesotho)
“We greet you, O great ones.”
» Spanish
“Hello and greetings to all.”
» Sumerian
“May all be well.”
» Swedish
“Greetings from a computer programmer in the little university town of Ithaca on the planet Earth”
» Telugu
“Greetings. Best wishes from Telugu-speaking people.”
» Thai
“We in this world send you our good will”
» Turkish
“Dear Turkish-speaking friends, may the honors of the morning be upon your heads.”
» Ukrainian
“We are sending greetings from our world, wishing you happiness, goodness, good health and many years.”
» Urdu
“Peace on you. We the inhabitants of this earth send our greetings to you.”
» Vietnamese
“Sincerely send you our friendly greetings.”
» Welsh
“Good health to you now and forever.”
» Wu
“Best wishes to you all.”

Leave a comment

php web based pivot table ajax with drag and drop














1 Comment


Sumber http://www.w3schools.com/php/php_ajax_database.asp


AJAX can be used for interactive communication with a database.


Contohnya dapat dilihat di http://www.w3schools.com/php/php_ajax_database.asp


When a user selects a user in the dropdown list above, a function called “showUser()” is executed. The function is triggered by the “onchange” event:

<script type=”text/javascript”>
function showUser(str)
if (str==””)
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
{// code for IE6, IE5
xmlhttp=new ActiveXObject(“Microsoft.XMLHTTP”);
if (xmlhttp.readyState==4 && xmlhttp.status==200)

<select name=”users” onchange=”showUser(this.value)”>
<option value=””>Select a person:</option>
<option value=”1″>Peter Griffin</option>
<option value=”2″>Lois Griffin</option>
<option value=”3″>Glenn Quagmire</option>
<option value=”4″>Joseph Swanson</option>
<br />
<div id=”txtHint”><b>Person info will be listed here.</b></div>


The showUser() function does the following:

  • Check if a person is selected
  • Create an XMLHttpRequest object
  • Create the function to be executed when the server response is ready
  • Send the request off to a file on the server
  • Notice that a parameter (q) is added to the URL (with the content of the dropdown list)

The PHP File

The page on the server called by the JavaScript above is a PHP file called “getuser.php”.

The source code in “getuser.php” runs a query against a MySQL database, and returns the result in an HTML table:


$con = mysql_connect(‘localhost’, ‘peter’, ‘abc123′);
if (!$con)
die(‘Could not connect: ‘ . mysql_error());

mysql_select_db(“ajax_demo”, $con);

$sql=”SELECT * FROM user WHERE id = ‘”.$q.”‘”;

$result = mysql_query($sql);

echo “<table border=’1′>

while($row = mysql_fetch_array($result))
echo “<tr>”;
echo “<td>” . $row['FirstName'] . “</td>”;
echo “<td>” . $row['LastName'] . “</td>”;
echo “<td>” . $row['Age'] . “</td>”;
echo “<td>” . $row['Hometown'] . “</td>”;
echo “<td>” . $row['Job'] . “</td>”;
echo “</tr>”;
echo “</table>”;


Explanation: When the query is sent from the JavaScript to the PHP file, the following happens:

  1. PHP opens a connection to a MySQL server
  2. The correct person is found
  3. An HTML table is created, filled with data, and sent back to the “txtHint” placeholder



Leave a comment

How to export table structure of MS Access Database

Bagaimana mengekspor struktur tabel dari Database MS Access


  1. Open MS Access and open your database. (For this sample the CarsDB.MDB sample database installed with ASPxperience was used)
  2. Press ALT+T+Y+D to open the Documentor. (This is a legacy menu option that still works as long as you know the shortcut)
  3. Click the Table tabs
  4. In the Documentor Table tab check the Cars and CarScheduling tables (see Figure 1)
  5. Click the Options button
  6. In the Include for Table group check Properties only
  7. In the Include for Fields group select the Names, Data Types, and Sizes radio button
  8. In the Include for Indexes group select the Nothing radio button (see Figure 2).
  9. Click OK to close the Print Table Definition dialog
  10. Click OK to generate the documentation
  11. When the documentation report is finished the Print Preview tab will be displayed. Click Text File in the Data section to export the report to a text file
  12. In the Export – Text File dialog (see Figure 3)
  13. Check open the destination file after the export operation is complete
  14. Click OK
  15. For the encoding choose Windows default

Leave a comment

How to list all table names in ms access

Cara pertama:

SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Flags)=0) AND ((MSysObjects.Type)=1)) ORDER BY MSysObjects.Name

Cara kedua:

FROM MSysObjects
Type In (1,4,6)

Leave a comment


Get every new post delivered to your Inbox.