Data entry

Fri, 08 Jun 2012 22:53:56 -0700

Hello guys!
I'm making a multi-lingual dictionary. I have a problem with the data entry. I want to check if the word already exists in dictionaries database. if yes, notify me, else, insert it. Also the English table should contain this word. for example, the word feu = fire in french, if I added it, my script should check if 'fire' exists in english dictionary, if not add it.
I get funny results. I know it's due to a mistake in my code. I need your help.

<?php
/*
1- check if data exists in $Dictionary table, if yes, notify me, else, insert and show confirmation.
2- check if $translation exists in English dictionary, if yes, notify me, else, insert it as a new english word.
*/

//inputs
$dictionary = $_POST['language'];
$word = $_POST['word'];
$translation = $_POST['translation'];
$wordtype = $_POST['wordtype'];
$extra = $_POST['extra'];

$con= mysql_connect("localhost","root","")or die('couldn\'t connect to mysql'. mysql_error());
mysql_select_db("dictionaries",$con);

$check  = mysql_query("SELECT COUNT(*) FROM $dictionary WHERE Word = '$word'",$con);
$checkEnglish = mysql_query("SELECT COUNT(Word) FROM English WHERE Word = '$translation'",$con);
$updateEnglish = mysql_query("INSERT INTO English(Word,Translation,Wordtype)Values('$transla
tion','$translation','$wordtype')",$con);
$query =mysql_query("INSERT INTO ".$dictionary." (Word,Translation,Wordtype,extra) values('$word','$translation','$wordtype','$extra'
)",$con);

print"
<HTML>
<HEAD>
<style type='text/css'>
A:active
	{
	font-weight:bold;color:orange;
	text-decoration:none;
	}
A:hover
	{
        font-weight:bold;
        color:crimson;
        text-decoration:underline;
        }
UL
	{
	font-weight:bold;color:royalblue;
        }</style><title> echo ".$dictionary." database entry </title><body bgcolor=#EFEFEF>

 ";

     if(mysql_num_rows($check)>0)
	{
	print "<br> ".$word." already exists in ".$dictionary." database";
	}
	 else
	{
	mysql_query($query,$con)or die('couldnt execute query:'. mysql_error());
print " <img src=images/flags/$dictionary.png>&nbsp;<H1><font color=#004080> $dictionary Database entry</H1>
<TABLE style=\"width:250px;height:200; background:#e9e9e9;border:1px dotted #808080;color:#004080;font:12pt tahoma;\">
	<TR BGCOLOR=#C0C0C0>
		<TD ALIGN=CENTER VALIGN=MIDDLE><B>Word</B></TD>
		<TD ALIGN=CENTER VALIGN=MIDDLE>$word</TD>
	</TR>
	<TR BGCOLOR=#8080C0>
		<TD ALIGN=CENTER VALIGN=MIDDLE><B>Translation</B></TD>
		<TD ALIGN=CENTER VALIGN=MIDDLE>$translation</TD>
	</TR>
	<TR BGCOLOR=#C0C0C0>
		<TD ALIGN=CENTER VALIGN=MIDDLE><B>Word Type</B></TD>
		<TD ALIGN=CENTER VALIGN=MIDDLE>$wordtype</TD>
	</TR>
	<TR BGCOLOR=#8080C0>
		<TD ALIGN=CENTER VALIGN=MIDDLE><B>Dictionary</B></TD>
		<TD ALIGN=CENTER VALIGN=MIDDLE>$dictionary</TD>
	</TR>
</TABLE>";
       }
 		if(mysql_num_rows($checkEnglish)!=0)
                	{
			print "<BR><b>$translation</b> is already found in the English dictionary";
			}
                else
			{
       				mysql_query($updateEnglish,$con);
       				echo "$translation was not found in English dictionary, I just added it there.<br>";
			}



 mysql_close($con);
?>     <p>
<A href="dataentry.html">Ok</a>
</h1></body></html>

thanks

'Data entry' Thread RSS Feed

Data entry