Build an online dictionary by PHP/MySQL

[puccavn]

create a database with name: dict
and run these query

CREATE TABLE `words` (
 `id` tinyint(4) NOT NULL auto_increment,
 `eng` varchar(255) NOT NULL default '',
 `vie` varchar(255) NOT NULL default '',
 PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

Then create new file with name: dbconn.inc, copy codes below---> save

<?php     
    $link = mysql_connect ("localhost", "yourusernamehere", "yourpasshere")
    or die ("Could not connect to MySQL Database");
    mysql_select_db("dict", $link); 
?>

Copy codes below to a text edition

<?php
echo("<a href=admin.php>ACP</a>
");

if(isset($_GET['act']))
{
$do=$_GET['act'];
switch($do)
{
 case 'form': show_form();break;
 case 'sm' : submited();break;
 default : show_form; break;
}

}
else
{
show_form();
}

function show_form()
{
?>
<form name=frm method=POST action="index.php?act=sm">

Word : <input type=text name="word"> <input type=submit name="sbm" value="Submit">
</form>
<?

}
function submited()
{

require("dbconn.inc");
//if(isset($_POST['sbm'])) 
//{
 $word=$_POST['word'];
 
 $sql="select * from words where eng like '".$word."'";
 //echo($sql);
 $result=mysql_query($sql,$link);
 if(@mysql_num_rows($result)!=0)
 {
  while($rows=mysql_fetch_array($result))
  {
   $vie=$rows["vie"];
  }
  echo("Word$word in vietnamese is : $vie
");
?>
<form name=frm method=POST action="index.php?act=sm">

Word : <input type=text name="word"> <input type="submit" name="sbm" value="Submit">
</form>
<?
 }
 else
  echo("Don't know that word !! My database is not update!");
//}
mysql_close($link);

}
?>

save with name: index.php

Copy this code to text editor:

<?php
echo("<a href=index.php>Home</a>
");
if(isset($_GET['act']))
{
$do=$_GET['act'];
switch($do)
{
 case 'form': show_form(); break;
 case 'sm': submited(); break;
 default: show_form();
}

}
else
show_form();
function show_form()
{
?>
<form name=frm method=POST action=admin.php?act=sm>
English: <input type=text name="eng">

Vietnam: <input type=text name="vie">

<input type=submit name=sm value="Submit">
</form>
<?
}
function submited()
{
require("dbconn.inc");
if(isset($_POST['sm']))
{
 $eng=$_POST['eng'];
 $vie=$_POST['vie'];
 $sql="Insert into words(eng, vie) values('".$eng."','".$vie."')";
 $res=mysql_query($sql,$link);
 //header("Location: admin.php");
?>
<script language=Javascript>window.location="admin.php";</script>
<?

}
else
 echo("Insert data !!");
mysql_close($link);
}
?>

Save with name admin.php

upload these three files to your host
admin.php to insert more words into your db

base on these code you can make more dict, exp: fr-vie
comp...
and create more field forexp: adjective, noun, verb...

sorry for my bad english ( i'm from Vietnam )

[bigmonkey]

great job, i like your idea. I was gonna make a world dictionary for all languages I will let u know when i start that project!

Maybe u can help

[puccavn]

okie !!
Try the best to help you !!

[frumau]

I am new to php and have a question. I would like to make a dictionary the way you told but when you mention: "create a database with name: dict
and run these query".", do you mean that I should put that query file in the database file of my root directory?

[puccavn]

run that query on phpmyadmin or write small PHP script to run it !!
This query will make an table in your database

[frumau]

Well I got phpmyadmin working and I entered your info. I adapted it cause I want a Dutch Thai Dictionary. But somehow the data I enter doesn't reach my table in the database. Here's your slightly altered script:

Admin.php:

<?php
echo("<a href=index.php>Home</a>
");
if(isset($_GET['act']))
{
$do=$_GET['act'];
switch($do)
{
case 'form': show_form(); break;
case 'sm': submited(); break;
default: show_form();
}

}
else
show_form();
function show_form()
{
?>
<form name=frm method=POST action=admin.php?act=sm>
Nederlands: <input type=text name="nl">

Thai: <input type=text name="th">

<input type=submit name=sm value="Submit">
</form>
<?
}
function submited()
{
require("dbconn.inc");
if(isset($_POST['sm']))
{
$nl=$_POST['nl'];
$th=$_POST['th'];
$sql="Insert into words(nl, th) values('".$nl."','".$th."')";
$res=mysql_query($sql,$link);
//header("Location: admin.php");
?>
<script language=Javascript>window.location="admin.php";</script>
<?

}
else
echo("Insert data !!");
mysql_close($link);
}
?>

And index.php:

<?php
echo("<a href=admin.php>ACP</a>
");

if(isset($_GET['act']))
{
$do=$_GET['act'];
switch($do)
{
case 'form': show_form();break;
case 'sm' : submited();break;
default : show_form; break;
}

}
else
{
show_form();
}

function show_form()
{
?><title>Woordenboek</title>
<form name=frm method=POST action="index.php?act=sm">

Word : <input type=text name="word"> <input type=submit name="sbm" value="Submit">
</form>
<?

}
function submited()
{

require("dbconn.inc");
//if(isset($_POST['sbm']))
//{
$word=$_POST['word'];

$sql="select * from words where eng like '".$word."'";
//echo($sql);
$result=mysql_query($sql,$link);
if(@mysql_num_rows($result)!=0)
{
while($rows=mysql_fetch_array($result))
{
$vie=$rows["vie"];
}
echo("Word$word in Thai is : $vie
");
?>
<form name=frm method=POST action="index.php?act=sm">

Word : <input type=text name="word"> <input type="submit" name="sbm" value="Submit">
</form>
<?
}
else
echo("Don't know that word !! My database is not update!");
//}
mysql_close($link);

}
?>

Do you see any errors?

Thanx,

Jasper

[pratik]

nice.. i tried it with my free hsot.. it worked then after few days later few host shut down .lol

[frumau]

I fixed the problem. Had to change the char-set code for the connection to the Mysql server, for the index page and for the Mysql database and table to UTF-8 and now everything is working out very nicely. Thanks for the code!!

[gilson_rosa]

Hy! Guys!!! I´m learning PHP and I´d like to create a Chinese-Portuguese dictionary, but how can I type Chinese characters? Portuguese has special signals and cannot be displayed properly. What should I do?

[frumau]

Use Unicode as char set for the transfer of the code, the database and the page you will have your dictionary on (encoding="utf-8" see Gateway2Thailand Dictionary ). I think unicode covers chinese characters as well. Portuguese for sure.

Cheers,