comment on

Here are the error messages:

[Mon Jun 10 12:18:31 2024] [error] [client 73.21.226.229] Premature en
+d of script headers: job_post_test.pl, referer: http://diversitylink.
+com/
[Mon Jun 10 12:18:31 2024] [error] [client 73.21.226.229] Bareword fou
+nd where operator expected at E:\\Pinnacle\\DiversityLink\\cgi-bin\\j
+ob_post_test.pl line 38, near "my$sth =$dbh->prepare("INSERT", refere
+r: http://diversitylink.com/
[Mon Jun 10 12:18:31 2024] [error] [client 73.21.226.229]   (Might be 
+a runaway multi-line "" string starting on line 37), referer: http://
+diversitylink.com/
[Mon Jun 10 12:18:31 2024] [error] [client 73.21.226.229] Semicolon se
+ems to be missing at E:\\Pinnacle\\DiversityLink\\cgi-bin\\job_post_t
+est.pl line 38., referer: http://diversitylink.com/
[Mon Jun 10 12:18:31 2024] [error] [client 73.21.226.229] Use of ?PATT
+ERN? without explicit operator is deprecated at E:\\Pinnacle\\Diversi
+tyLink\\cgi-bin\\job_post_test.pl line 39., referer: http://diversity
+link.com/
[Mon Jun 10 12:18:31 2024] [error] [client 73.21.226.229] Use of ?PATT
+ERN? without explicit operator is deprecated at E:\\Pinnacle\\Diversi
+tyLink\\cgi-bin\\job_post_test.pl line 39., referer: http://diversity
+link.com/
[Mon Jun 10 12:18:31 2024] [error] [client 73.21.226.229] Use of ?PATT
+ERN? without explicit operator is deprecated at E:\\Pinnacle\\Diversi
+tyLink\\cgi-bin\\job_post_test.pl line 39., referer: http://diversity
+link.com/
[Mon Jun 10 12:18:31 2024] [error] [client 73.21.226.229] Use of ?PATT
+ERN? without explicit operator is deprecated at E:\\Pinnacle\\Diversi
+tyLink\\cgi-bin\\job_post_test.pl line 39., referer: http://diversity
+link.com/
[Mon Jun 10 12:18:31 2024] [error] [client 73.21.226.229] Use of ?PATT
+ERN? without explicit operator is deprecated at E:\\Pinnacle\\Diversi
+tyLink\\cgi-bin\\job_post_test.pl line 39., referer: http://diversity
+link.com/
[Mon Jun 10 12:18:31 2024] [error] [client 73.21.226.229] Use of ?PATT
+ERN? without explicit operator is deprecated at E:\\Pinnacle\\Diversi
+tyLink\\cgi-bin\\job_post_test.pl line 39., referer: http://diversity
+link.com/
[Mon Jun 10 12:18:31 2024] [error] [client 73.21.226.229] syntax error
+ at E:\\Pinnacle\\DiversityLink\\cgi-bin\\job_post_test.pl line 38, n
+ear "my$sth =$dbh->prepare("INSERT INTO ", referer: http://diversityl
+ink.com/
[Mon Jun 10 12:18:31 2024] [error] [client 73.21.226.229] Search patte
+rn not terminated or ternary operator parsed as search pattern at E:\
+\Pinnacle\\DiversityLink\\cgi-bin\\job_post_test.pl line 39., referer
+: http://diversitylink.com/
[download]

Here is the entire code:

#!C:/Perl/bin/perl -w
##post_jobs.pl

use CGI qw(:standard);

use DBI;
print "Content-type: text/html\n\n";
###use POSIX qw(strftime);
####$shortdate = strftime "%B %d, %Y", localtime;



$JobID=param('JobID');
$EmployerID=param('EmployerID');
$EmployerName=param('EmployerName');
$Title=param('Title');
$Logo=param('Logo');
$City=param('City');
$StateProvince=param('StateProvince');
$Description=param('Description');
$Function=param('Function');
$Sector=param('Sector');
$Country=param('Country');
$Posted=param('Posted');

if ($JobID eq ""||$EmployerID eq ""||$EmployerName eq ""||$Title eq ""
+||$Logo eq ""||$City eq ""||$StateProvince eq ""||$Description eq ""|
+|
$Function eq ""||$Sector eq ""||$Country eq ""||$Posted eq ""||$Logo e
+q "")

{
print "The FORM is INCOMPLETE";

}

else {


my$dbh = DBI->connect('dbi:mysql:jobs_db', "Poster','Poster Password')
+;
my$sth =$dbh->prepare("INSERT INTO jobs (JobID,EmployerID,EmployerName
+,Title,City,StateProvince,Description,Function,Sector,Country,Posted)
Values(?,?,?,?,?,?,?,?,?,?,?)");

$sth ->execute($JobID,$EmployerID,$EmployerName,$Title,$City,$StatePro
+vince,$Description,$Function,$Sector,$Country,$Posted);
$sth ->finish();
$dbh->disconnect ();
}

 #!/usr/local/bin/perl
     print "Your Ad Was Posted.\n";

exit;
[download]

In reply to Re^2: Perl and Mysql Queries by Milti
in thread Perl and Mysql Queries by Milti

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		`&`
	<		`<`
	>		`>`
	[		`[`
	]		`]`

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.