LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
Reload this Page [SOLVED] help needed critically
User Name
Password
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.

Notices


Reply
  Search this Thread
Old 04-14-2010, 07:07 AM   #1
a7mlinux
Member
 
Registered: Apr 2009
Distribution: RHEL 5, Fedora 10
Posts: 116

Rep: Reputation: 17
Unhappy help needed critically

hi every body I'm working on php - mysql, I have this error ant end of file and I dont know where it is come from
Code:
<?php
//connection database
$con = mysql_connect("localhost","root","");
       if (!$con)
	   {
	   die('Could not connect: ' . mysql_error());
//create database
       if (mysql_query("CREATE DATABASE mydb",$con))
       {
	   echo "database created";
	   }
	   else
	   {
	   echo "Error creating database: " . mysql_error();
	   }
//create table
mysql_select_db("mydb",$con);
$ctable = "CREATE TABLE employee
(
`docNo` int( 10 ) NOT NULL ,
`name` varchar( 60 ) COLLATE utf8_unicode_ci NOT NULL ,
`nick` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`tribe` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`brthPlace` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`brthDatDay` int( 2 ) NOT NULL ,
`brthDatMnth` int( 2 ) NOT NULL ,
`brthDatYer` int( 4 ) NOT NULL ,
`nat` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`natPlace` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`natDatDay` int( 2 ) NOT NULL ,
`natDatMnth` int( 2 ) NOT NULL ,
`natDatYer` int( 4 ) NOT NULL ,
`parName` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`parAddr` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`currLive` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`currLiveSqr` int( 10 ) NOT NULL ,
`currLiveHsNo` int( 10 ) NOT NULL ,
`phone` int( 15 ) NOT NULL,
`rel` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`marStat` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`wifName` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`wifWrkAddr` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`fsChName` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`fsChAge` int( 2 ) NOT NULL ,
`fsChWrk` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`secChName` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`secChAge` int( 2 ) NOT NULL ,
`secChWrk` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`thChName` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`thChAge` int( 2 ) NOT NULL ,
`thChWrk` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`frChName` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`frChAge` int( 2 ) NOT NULL ,
`frChWrk` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`fiChName` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`fiChAge` int( 2 ) NOT NULL ,
`fiChWrk` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`siChName` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`siChAge` int( 2 ) NOT NULL ,
`siChWrk` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`stLevBsc` varchar( 40 ) utf8_unicode_ci NOT NULL ,          
`stLevMed` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`stLevHi` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`stLevUni` varchar( 40 ) utf8_unicode_ci NOT NULL ,                
`idNo` varchar( 10 ) utf8_unicode_ci NOT NULL ,               
`idPlace` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`idDatDay` int( 2 ) NOT NULL ,              
`idDatMnth` int( 2 ) NOT NULL ,               
`idDatYer` int( 4 ) NOT NULL ,               
`dlNo` varchar( 10 ) utf8_unicode_ci NOT NULL ,               
`dlPlace` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`dlDatDay` int( 2 ) NOT NULL ,               
`dlDatMnth` int( 2 ) NOT NULL ,                
`dlDatYer` int( 4 ) NOT NULL ,              
`pNo` varchar( 10 ) utf8_unicode_ci NOT NULL ,               
`pPlace` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`pDatDay` int( 2 ) NOT NULL ,               
`pDatMnth` int( 2 ) NOT NULL ,                
`pDatyer` int( 4 ) NOT NULL ,                
`fsBfName` varchar( 40 ) utf8_unicode_ci NOT NULL ,                
`fsBfWrk` varchar( 40 ) utf8_unicode_ci NOT NULL ,              
`fsBfAddr` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`secBfName` varchar( 40 ) utf8_unicode_ci NOT NULL ,             
`secBfWrk` varchar( 40 ) utf8_unicode_ci NOT NULL ,             
`secBfAddr` varchar( 40 ) utf8_unicode_ci NOT NULL ,              
`thBfName` varchar( 40 ) utf8_unicode_ci NOT NULL ,              
`thBfWrk` varchar( 40 ) utf8_unicode_ci NOT NULL ,              
`thBfAddr` varchar( 40 ) utf8_unicode_ci NOT NULL ,              
`fsBkName` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`fsBkWrk` varchar( 40 ) utf8_unicode_ci NOT NULL ,              
`fsBkAddr` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`secBkName` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`secBkWrk` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`secBkAddr` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`thBkName` varchar( 40 ) utf8_unicode_ci NOT NULL ,              
`thBkWrk` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`thBkAddr` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`actSpo` varchar( 40 ) utf8_unicode_ci NOT NULL ,              
`actSo` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`actPl` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`fsPn` varchar( 40 ) utf8_unicode_ci NOT NULL ,              
`secPn` varchar( 40 ) utf8_unicode_ci NOT NULL ,              
`thPn` varchar( 40 ) utf8_unicode_ci NOT NULL
)";
mysql_query($ctable,$con)
or die(mysql_error());
?>
the error say:
parse error: parse error in C:\................\xxx.php on line 109, which is the line contain ?>
Last edited by a7mlinux; 04-14-2010 at 07:11 AM.
 
Old 04-14-2010, 07:15 AM   #2
PMP
Member
 
Registered: Apr 2009
Location: ~
Distribution: RHEL, Fedora
Posts: 381

Rep: Reputation: 58
I feel you missed matching closing bracket of first if block.

Please write a meaningful title to fetch more answers !!
 
1 members found this post helpful.
Old 04-14-2010, 07:23 AM   #3
Sergei Steshenko
Senior Member
 
Registered: May 2005
Posts: 4,481

Rep: Reputation: 454Reputation: 454Reputation: 454Reputation: 454Reputation: 454
Quote:
Originally Posted by a7mlinux View Post
hi every body I'm working on php - mysql, I have this error ant end of file and I dont know where it is come from
Code:
<?php
//connection database
$con = mysql_connect("localhost","root","");
       if (!$con)
	   {
	   die('Could not connect: ' . mysql_error());
//create database
       if (mysql_query("CREATE DATABASE mydb",$con))
       {
	   echo "database created";
	   }
	   else
	   {
	   echo "Error creating database: " . mysql_error();
	   }
//create table
mysql_select_db("mydb",$con);
$ctable = "CREATE TABLE employee
(
`docNo` int( 10 ) NOT NULL ,
`name` varchar( 60 ) COLLATE utf8_unicode_ci NOT NULL ,
`nick` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`tribe` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`brthPlace` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`brthDatDay` int( 2 ) NOT NULL ,
`brthDatMnth` int( 2 ) NOT NULL ,
`brthDatYer` int( 4 ) NOT NULL ,
`nat` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`natPlace` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`natDatDay` int( 2 ) NOT NULL ,
`natDatMnth` int( 2 ) NOT NULL ,
`natDatYer` int( 4 ) NOT NULL ,
`parName` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`parAddr` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`currLive` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`currLiveSqr` int( 10 ) NOT NULL ,
`currLiveHsNo` int( 10 ) NOT NULL ,
`phone` int( 15 ) NOT NULL,
`rel` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`marStat` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`wifName` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`wifWrkAddr` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`fsChName` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`fsChAge` int( 2 ) NOT NULL ,
`fsChWrk` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`secChName` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`secChAge` int( 2 ) NOT NULL ,
`secChWrk` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`thChName` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`thChAge` int( 2 ) NOT NULL ,
`thChWrk` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`frChName` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`frChAge` int( 2 ) NOT NULL ,
`frChWrk` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`fiChName` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`fiChAge` int( 2 ) NOT NULL ,
`fiChWrk` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`siChName` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`siChAge` int( 2 ) NOT NULL ,
`siChWrk` varchar( 40 ) COLLATE utf8_unicode_ci NOT NULL ,
`stLevBsc` varchar( 40 ) utf8_unicode_ci NOT NULL ,          
`stLevMed` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`stLevHi` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`stLevUni` varchar( 40 ) utf8_unicode_ci NOT NULL ,                
`idNo` varchar( 10 ) utf8_unicode_ci NOT NULL ,               
`idPlace` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`idDatDay` int( 2 ) NOT NULL ,              
`idDatMnth` int( 2 ) NOT NULL ,               
`idDatYer` int( 4 ) NOT NULL ,               
`dlNo` varchar( 10 ) utf8_unicode_ci NOT NULL ,               
`dlPlace` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`dlDatDay` int( 2 ) NOT NULL ,               
`dlDatMnth` int( 2 ) NOT NULL ,                
`dlDatYer` int( 4 ) NOT NULL ,              
`pNo` varchar( 10 ) utf8_unicode_ci NOT NULL ,               
`pPlace` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`pDatDay` int( 2 ) NOT NULL ,               
`pDatMnth` int( 2 ) NOT NULL ,                
`pDatyer` int( 4 ) NOT NULL ,                
`fsBfName` varchar( 40 ) utf8_unicode_ci NOT NULL ,                
`fsBfWrk` varchar( 40 ) utf8_unicode_ci NOT NULL ,              
`fsBfAddr` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`secBfName` varchar( 40 ) utf8_unicode_ci NOT NULL ,             
`secBfWrk` varchar( 40 ) utf8_unicode_ci NOT NULL ,             
`secBfAddr` varchar( 40 ) utf8_unicode_ci NOT NULL ,              
`thBfName` varchar( 40 ) utf8_unicode_ci NOT NULL ,              
`thBfWrk` varchar( 40 ) utf8_unicode_ci NOT NULL ,              
`thBfAddr` varchar( 40 ) utf8_unicode_ci NOT NULL ,              
`fsBkName` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`fsBkWrk` varchar( 40 ) utf8_unicode_ci NOT NULL ,              
`fsBkAddr` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`secBkName` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`secBkWrk` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`secBkAddr` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`thBkName` varchar( 40 ) utf8_unicode_ci NOT NULL ,              
`thBkWrk` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`thBkAddr` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`actSpo` varchar( 40 ) utf8_unicode_ci NOT NULL ,              
`actSo` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`actPl` varchar( 40 ) utf8_unicode_ci NOT NULL ,               
`fsPn` varchar( 40 ) utf8_unicode_ci NOT NULL ,              
`secPn` varchar( 40 ) utf8_unicode_ci NOT NULL ,              
`thPn` varchar( 40 ) utf8_unicode_ci NOT NULL
)";
mysql_query($ctable,$con)
or die(mysql_error());
?>
the error say:
parse error: parse error in C:\................\xxx.php on line 109, which is the line contain ?>
Start commenting out "blocks" until you get no error - this is to determine the "big" piece of code containing the error.
 
Old 04-14-2010, 09:10 AM   #4
graemef
Senior Member
 
Registered: Nov 2005
Location: Hanoi
Distribution: Fedora 13, Ubuntu 10.04
Posts: 2,379

Rep: Reputation: 148Reputation: 148
Each open brace must have a close brace associated with it. Check them carefully.

Using consistent indentation often helps in such a scenario.
 
Old 04-14-2010, 09:30 AM   #5
Sergei Steshenko
Senior Member
 
Registered: May 2005
Posts: 4,481

Rep: Reputation: 454Reputation: 454Reputation: 454Reputation: 454Reputation: 454
Quote:
Originally Posted by graemef View Post
Each open brace must have a close brace associated with it. Check them carefully.

Using consistent indentation often helps in such a scenario.
Indentation is indeed horrible; it looks like the problem is with closing the body of the very first 'if', but because of indentation I might be wrong.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help needed for make file problem : make: *** No rule to make target `flash', needed rameshsatyavaram Linux - Newbie 3 09-11-2008 02:13 AM
XGL needed for Beryl is conflicting with OpenGL needed for Cedega chunkeydelight Linux - Desktop 2 07-18-2007 05:50 AM
Errors installing Q, which is needed for Lex, which is needed for PHP Virtuality Linux - Software 1 05-29-2007 04:47 PM
help needed sailu_mvn Programming 2 03-24-2005 06:50 AM
help needed trolsbane Linux - Hardware 3 09-06-2003 03:36 PM

LinuxQuestions.org > Forums > Non-*NIX Forums > Programming

All times are GMT -5. The time now is 11:26 AM.

Contact Us - Advertising Info - Rules - Privacy - LQ Merchandise - Donations - Contributing Member - LQ Sitemap -
Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration