| SitePoint Sponsor |
hi , i want to install PHP and Appache to connect with oracle11g database . so currently i installed PHP 5.3.6 and apache_2.2.19-x86-openssl-1.0.0d , but m unable to execute phpinfo.php , its displaying the same code in page ( http://localhost/phpinfo.php)
<?php
phpinfo();
?>
please help me .
You need to make sure apache is setup to handle the PHP code (see http://www.thesitewizard.com/php/ins...-windows.shtml)
You will also need to install the Oracle Client (see this thread)
Thank you for solution .
I created one registration form as once form is filled and click on submit button it has to store in database . so i have written the code as shown below .
<?php
// list of jobs //
$jobList = array('Developer',Database Administrator','Business Systems Analyst','Software Engineer'*/);
// sorting the jobs //
sort($jobList);
// list of countries //
$countryList = array('USA','UK,'French Polynesia','Gabon','Gambia','Georgia','Germany',);
// sorting the countries //
sort($countryList);
// looping the countries //
// jobs dropdown runtime //
$jdropdown = '';
// country dropdown runtime //
$cdropdown = '';
foreach($jobList as $job)
{
$jobName = ucwords($job);
$jdropdown .= "<option value=\"$jobName\">$jobName</option>";
}
foreach($countryList as $country)
{
$countryName = ucwords($country);
// storing country in dropdown //
$cdropdown .= "<option value=\"$countryName\">$countryName</option>";
}
$exp = '';
for($i=1; $i<35; $i++)
{
$exp .= "<option>$i</option>";
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title> registration form</title>
<link href="menu_scripts/styles.css" rel="stylesheet" type="text/css" />
<script src="menu_scripts/ga.js" async="" type="text/javascript"></script>
<!--<script type="text/javascript" src="apply_files/select.js"></script>
<!--<script type="text/javascript" src="menu_scripts/rsv.js"></script>
<script type="text/javascript">
var rules = [];
rules.push("required,form_of_address,Please enter your form of address");
rules.push("required,fromname,Please enter your first name.");
rules.push("required,lastname,Please enter your last name.");
rules.push("required,fromemail,Please enter your email address.");
rules.push("valid_email,fromemail,Please enter a valid email address.");
</script>-->
</head>
<body>
<table width="585" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td class="php_form_midbg"><div class="mid_content2"><form class="test" action="mail.php" method="post" enctype="multipart/form-data" name="form2" onsubmit="return rsv.validate(this, rules)">
<table width="560" border="0" align="center" cellpadding="0" cellspacing="0">
<tbody><tr><td style="height: 3px;"></td></tr>
<tr>
<td colspan="3" class="mid_black_bold">Please fill thee form</td>
</tr>
<tr>
<td colspan="3" class="body"> </td>
</tr>
<tr>
<td colspan="3" align="right" class="body"><span style="color: rgb(255, 66, 0);">All Fields are mandatory</span></td>
</tr>
<tr>
<td width="34%" align="right" class="body"> Job Applying for</td>
<td class="body" width="2%">/td>
<td style="font-size: 0.9em;" width="64%">
<span style="font-size: 0.9em;"> <select name="jobname" id="jobname" tabindex="1" onchange="showCD(this.value)">
<option selected="selected">Select</option>
<?php echo $jdropdown; ?>
</select> </span>
<div id="txtHint"></div>
</td>
</tr>
<tr align="right"><td style="height: 3px;"></td></tr>
<tr>
<td width="34%" align="right" class="body">Gender</td>
<td class="body" width="2%">
<td width="64%"><select name="gender" tabindex="2" id="gender">
<option selected="selected" value="">Select</option>
<option value="M">Male</option>
<option value="F">Female</option>
</select></td>
</tr>
<tr align="right"><td style="height: 3px;"></td></tr>
<tr>
<td width="34%" align="right" class="body"> First Name</td>
<td class="body" width="2%">
<td width="64%"><input tabindex="3" name="firstname" type="text"></td>
</tr>
<tr align="right"><td height="2" style="height: 3px;"></td>
</tr>
<tr>
<td width="34%" align="right" class="body"> Last Name</td>
<td class="body" width="2%">
<td width="64%"><input tabindex="4" name="lastname" type="text"></td>
</tr>
<tr align="right"><td style="height: 3px;"></td></tr>
<tr>
<td width="34%" align="right" class="body"> City</td>
<td class="body" width="2%">
<td width="64%"><input tabindex="5" name="strcity" class="textfield" type="text"></td>
</tr>
<tr align="right"><td style="height: 3px;"></td></tr>
<tr>
<td width="34%" align="right" class="body"> State</td>
<td class="body" width="2%">
<td width="64%"><input name="strstate" tabindex="6" class="textfield" type="text"></td>
</tr>
<tr align="right"><td style="height: 3px;"></td></tr>
<tr>
<td width="34%" align="right" class="body"> Country</td>
<td class="body" width="2%">
<td width="64%">
<select name="country" id="country" tabindex="7">
<option value="Select" selected="selected">Select</option>
<?php echo $cdropdown; ?>
</select>
</td>
</tr>
<tr align="right"><td style="height: 3px;"></td></tr>
<tr>
<td width="34%" align="right" class="body"> Phone No</td>
<td class="body" width="2%">
<td width="64%"><input name="strno" tabindex="8" class="textfield" type="text"></td>
</tr>
<tr align="right"><td style="height: 3px;"></td></tr>
<tr>
<td width="34%" align="right" class="body"> Email</td>
<td class="body" width="2%">
<td width="64%"><input tabindex="9" name="fromemail" type="text"></td>
</tr>
<tr align="right"><td style="height: 3px;"></td></tr>
<tr>
<td width="34%" align="right" class="body"> Total work experience in years</td>
<td class="body" width="2%">
<td width="64%">
<select name="totalexp" id="totalexp" tabindex="10">
<option selected="selected" value=" ">Select</option>
<?php echo $exp; ?>
</select>
</td>
</tr>
<tr align="right"><td style="height: 3px;"></td></tr>
<tr>
<td width="34%" align="right" class="body"> Comments</td>
<td class="body" width="2%">
<td width="64%"><textarea rows="4" cols="25" name="strcomments" tabindex="11"></textarea></td>
</tr>
<tr align="right"><td style="height: 3px;"></td></tr>
<tr>
<td width="34%" align="right" class="body"> Resume</td>
<td class="body" width="2%">
<td width="64%">
<input name="filename" tabindex="12" type="file"></td>
</tr>
<tr><td style="height: 3px;"></td></tr>
<tr>
<td colspan="3" align="center"><table width="120" border="0">
<tr>
<td><input tabindex="13" name="btnSub2" value="Submit" type="submit" /></td>
<td><input tabindex="14" name="btnSub3" value="Cancel" type="submit" /></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="3" align="center"> </td>
</tr>
<tr>
<td colspan="3" align="center"> </td>
</tr>
</tbody>
</table>
</form></td>
</tr>
<tr>
<td> </td>
</tr>
</table>
</body>
</html>
I have written the code to store the form info .. to mysql database .. so m getting error as unexpected variable . please help me .
<?php
function control($val,$min,$max,$ctype,$check)
{
if($check == 'Y')
{
// no spaces are allowed //
$secure = strip_tags(stripslashes(str_replace(' ','',(htmlentities($val)))));
}
else
{
// spaces are allowed //
$secure = strip_tags(stripslashes(trim(htmlentities($val))));
}
if($secure == '')
{
echo "Enter ".$ctype;
exit();
}
else if(strlen($secure) < $min)
{
echo "Enter Minimum ".$min." Characters ".$ctype;
exit();
}
else if(strlen($secure) > $max)
{
echo "Enter Maximum ".$max." Characters ".$ctype;
exit();
}
return $secure;
}
function userdata()
{
if(isset($_POST['btnSub2']))
{
$job_name=control($_POST['jobname'],2,100,'Job Applying For','N');
$gender=control($_POST['gender'],1,1,'Gender','Y');
$first_name=control($_POST['firstname'],1,30,'First Name','N');
$last_name=control($_POST['lastname'],1,30,'Last Name','N');
$city=control($_POST['strcity'],2,50,'City','N');
$state=control($_POST['strstate'],2,50,'State','N');
$country=control($_POST['country'],2,50,'Country','N');
$phone_mobile=control($_POST['strno'],8,15,'Phone','Y');
$email=control($_POST['fromemail'],5,60,'Email Address','Y');
$experience=control($_POST['totalexp'],1,2,'Experience','Y');
$comment=control($_POST['strcomments'],10,500,'Comment','N');
$file_name = str_replace('_','',$_FILES['filename']['name']);
$file_error = $_FILES['filename']['error'];
if(!is_numeric($strno))
{
echo "Phone/Mobile Should be Numeric";
}
else
(
$upload = false;
$explode_file = explode('.',$file_name)
$extension_supplied = $explode_file[count($explode_file) - 1];
$extension_allowed = array('doc','docx');
for($check=0; $check<count($extension_allowed); $check++)
{
if($extension_supplied == $extension_allowed[$check])
{
$upload = true;
}
}
// current timestamp //
$timestamp = time();
// temporary file name //
$tmp_file_name = strtolower($fname)."_".strtolower($lname)."_".$timestamp."_".$file_name;
// target directory //
$target = "resume_coll/".$tmp_file_name;
if($upload == true)
{
// connecting to database server //
mysql_connect('db.domain.net','dbo3','glo');
mysql_select_db('db1234566');
$sql = "select email from tbl_user_details where email='$email'";
if(mysql_num_rows(mysql_query($sql)) == 0)
{
$sql = "select phone_mobile from tbl_user_details where phone_mobile='$phone'";
if(mysql_num_rows(mysql_query($sql)) == 0)
{
$sql = "insert into tbl_user_details values('','$job','$gender','$fname','$lname','$city','$state','$country',$phone,'$email',$experience,'$comment','$tmp_file_name',now())";
if(mysql_query($sql))
{
if(is_uploaded_file($_FILES['filename']['tmp_name']))
{
if(move_uploaded_file($_FILES['filename']['tmp_name'],$target))
{
$message ="
<table>
<tr><th colspan=3 style='text-align:left;'>User Details</th></tr>
<tr><td>First Name</td><td>
<tr><td>Last Name</td><td>
<tr><td>City</td><td>
<tr><td>State</td><td>
<tr><td>Country</td><td>
<tr><td>Phone/Mobile</td><td>
<tr><td>Email</td><td>
<tr><td>Experience</td><td>
<tr><td>Comment</td><td>
<tr><td>Resume</td><td>
</table>";
$receiver = 'mydomain.com';
$subject = "Resume Uploaded by ".ucwords($fname)." ".ucwords($lname);
echo "in resume upload";
$headers = "From:".$email."\r\n"."Reply-To:".$email."\r\n";
$headers .= "Content-type: text/html\r\n";
//$message = htmlentities($message);
$mail = mail($receiver,$subject,$message,$headers);
if($mail)
{
echo "You will receive a confirmation E-mail with User Name and Password information ";
}
else
{
echo "Internet Connection Problem";
}
}
else
{
echo "Resume not Transfer to Server";
}
}
else
{
echo "Resume is not Uploaded.";
}
}
}
else
{
echo "This Phone/Mobile is Already Existed";
}
}
else
{
echo "This Email Already Uploaded Resume";
}
}
else
{
echo "Invalid File Extension (<b>$extension_supplied</b>) to Upload.";
}
}
}
}
function execute_code()
{
return userdata();
}
echo execute_code();
?>
Put your PHP code in [ php ] [/ php ] (without the spaces) and tell me what line number (or give the entire error message). Its' too hard to read this, the way it is posted.
ok sorry, m unable to upload the file to database ( i want to store the file in the given target path) and now its giving error as ( Invalid File Extension () to Upload. )
<?php
function control($val,$min,$max,$ctype,$check)
{
-----
}
function userdata()
{ if(isset($_POST['btnSub2']))
{$resume_file_name = str_replace('_','',$_FILES['filename']['name']);
$file_error = $_FILES['filename']['error'];
if(!is_numeric($strno))
{
echo "Phone/Mobile Should be Numeric";
}
else
{
$upload = false;
echo "4Phone/Mobile Should be Numeric";
$explode_file = explode('.',$filename);
$extension_supplied = $explode_file[count($explode_file) - 1];
$extension_allowed = array('.doc','.docx');
for($check=0; $check<count($extension_allowed); $check++)
{if($extension_supplied == $extension_allowed[$check])
{$upload = true;}
}
// current timestamp //
$timestamp = time();
// temporary file name //
$tmp_file_name = strtolower($firstname)."_".strtolower($lastname)."_".$timestamp."_".$filename;
// target directory //
$target = "abc/resume_coll/".$tmp_file_name;
echo ".$target ,.$temp_file_name ";
if($upload == true)
{// connecting to database server //
$sql=mysql_connect('db42.db.com','dbo4256938','abcd123');
if (!$sql)
{die('Connection failed: ' . mysql_error());
}else
{ echo "Connection to MySQL server successful!";
} $sql = mysql_select_db($db4256938);
---------
-------
if(is_uploaded_file($_FILES['filename']['tmp_name']))
{
if(move_uploaded_file($_FILES['filename']['tmp_name'],$target))
{
$message ="
<table>-----<tr><td>Resume</td><td>
----- </table>
$receiver = 'abc@xyz.com';
$subject = "Resume Uploaded by ".ucwords($firstname)." ".ucwords($lastname);
echo "in resume upload";
$headers = "From:".$email."\r\n"."Reply-To:".$email."\r\n";
$headers .= "Content-type: text/html\r\n";
//$message = htmlentities($message);
$mail = mail($receiver,$subject,$message,$headers);
if($mail)
{
echo "You will receive a confirmation E-mail with User Name and Password information "; }
else
{
echo "Invalid File Extension (<b>$extension_supplied</b>) to Upload.";
}function execute_code()
{
return userdata();
}
echo execute_code();
?>
I want to upload the file in target path but getting error as Invalid File Extension () to Upload. please help me .
Please re-post your code putting them in [ php ] and [/ php ] tags (but remove the extra spaces inside the tags, so it formats it so it is easier to read
hi, i am trying to upload the file in target path(folder) but m getting error as invalid File Extension to upload(). kindly help me .is this code correct .?PHP Code:$resume_file_name = str_replace('_','',$_FILES['filename']['name']);
$file_error = $_FILES['filename']['error'];
if(is_numeric($strno))
{echo "Phone/Mobile Should be Numeric";
} else{
$upload == false;
$explode_file = explode('.',$filename);
$extension_supplied = $explode_file[count($explode_file) - 1];
$extension_allowed = array('.doc','.docx');
for($check=0; $check<count($extension_allowed); $check++)
{if($extension_supplied == $extension_allowed[$check])
{$upload == true;
}} //$timestamp = time();
$tmp_file_name = strtolower($firstname)."_".strtolower($lastname)."_".$timestamp."_".$filename;
$target = "mine/resume_coll/".$tmp_file_name;
if($upload == true)
{$sql=mysql_connect('db425.db.com','dbo425','abc123456');
PHP Code:function control($val,$min,$max,$ctype,$check)
{
}function userdata()
{ if(isset($_POST['btnSub2']))
{$resume_file_name = str_replace('_','',$_FILES['filename']['name']);
$file_error = $_FILES['filename']['error'];
if(!is_numeric($strno))
{echo "Phone/Mobile Should be Numeric";}
else{$upload = false;
$explode_file = explode('.',$filename);
$extension_supplied = $explode_file[count($explode_file) - 1];
$extension_allowed = array('.doc','.docx');
for($check=0; $check<count($extension_allowed); $check++)
{if($extension_supplied == $extension_allowed[$check])
{$upload = true;}
}$timestamp = time();
$tmp_file_name = strtolower($firstname)."_".strtolower($lastname)."_".$timestamp."_".$filename;
$target = "abc/resume_coll/".$tmp_file_name;
echo ".$target ,.$temp_file_name ";
if($upload == true)
{ // connecting to database server //
$sql=mysql_connect('db42.db.com','dbo4256938','abcd123');
if (!$sql)
{die('Connection failed: ' . mysql_error());
}else
{ echo "Connection to MySQL server successful!";
} $sql = mysql_select_db($db4256938);
---------
-------
if(is_uploaded_file($_FILES['filename']['tmp_name']))
{
if(move_uploaded_file($_FILES['filename']['tmp_name'],$target))
{$message ="
<table> <tr><td>Resume</td><td>/td><td><a href=http://abc.com/abc/resume_collect/$tmp_file_name>Download Now</a></td></tr>
</table>
$receiver = 'abc@xyz.com';
$subject = "Resume Uploaded by ".ucwords($firstname)." ".ucwords($lastname);
echo "in resume upload";
$headers = "From:".$email."\r\n"."Reply-To:".$email."\r\n";
$headers .= "Content-type: text/html\r\n";
//$message = htmlentities($message);
$mail = mail($receiver,$subject,$message,$headers);
if($mail)
{echo "You will receive a confirmation E-mail with User Name and Password information "; }
else
{echo "Invalid File Extension (<b>$extension_supplied</b>) to Upload.";
}function execute_code()
{return userdata();
}echo execute_code();
Okay, do you see in your paste how the formatting just seems to go crazy after $message ="?
You forgot to close the ending " for your $message variable for one.
Should bePHP Code:$message ="
<table> <tr><td>Resume</td><td>/td><td><a href=http://abc.com/abc/resume_collect/$tmp_file_name>Download Now</a></td></tr>
</table>
PHP Code:$message ="
<table> <tr><td>Resume</td><td>/td><td><a href=http://abc.com/abc/resume_collect/$tmp_file_name>Download Now</a></td></tr>
</table>";
Second, your error message isn't based on any validation of the file extension but rather the validation of whether the e-mail was sent or not.
PHP Code:if($mail) // checks mail variable...
{
echo "You will receive a confirmation E-mail with User Name and Password information ";
}
else
{
echo "Invalid File Extension (<b>$extension_supplied</b>) to Upload.";
}
Posting Permissions
Reply With Quote
Bookmarks