|
PHP - Moved: Php/mysql Create A Common Field
This topic has been moved to MySQL Help.
http://www.phpfreaks.com/forums/index.php?topic=321735.0 Similar TutorialsIn my mysql database i have a field that records peoples details one part of the details is their county/region they live in. It records the county in a normal varchar field however i need a simple php script that searching the database and finds the most common county so i can then return to the screen where the most popular region for my members. Thank you for reading. This topic has been moved to Miscellaneous. http://www.phpfreaks.com/forums/index.php?topic=318572.0 This topic has been moved to MySQL Help. http://www.phpfreaks.com/forums/index.php?topic=351353.0 This topic has been moved to MySQL Help. http://www.phpfreaks.com/forums/index.php?topic=334042.0 Hi: I'm going crazy trying to do the following: I'm making a job registration process where the user registers on one php page to the website, must acknowlege and email receipt using an activate php page, then is directed to upload their C.V. (resume) based on the email address they enter in the active page output. I then run an upload page to store the resume in teh MySQL db based on the users email address in the same record. If I isolate the process of the user registering to the db, it works perfectly. If I isolate the file upload process into the db, it works perfect. I simply cannot upload teh file to the existing record based on teh email form field matching the user_email field in the db. With the processes together, teh user is activated, but teh file is not uploaded. Maybe I've simply been at this too long today, but am compeled to get through it by end day. If anyone can help sugest a better way or help me fix this, I will soo greatly appreciate it. My code is as follows for the 2 pages. ---------activate.php------- <?php session_start(); include ('reg_dbc.php'); if (!isset($_GET['usr']) && !isset($_GET['code']) ) { $msg = "ERROR: The code does not match.."; exit(); } $rsCode = mysql_query("SELECT activation_code from subscribers where user_email='$_GET[usr]'") or die(mysql_error()); list($acode) = mysql_fetch_array($rsCode); if ($_GET['code'] == $acode) { mysql_query("update subscribers set user_activated=1 where user_email='$_GET[usr]'") or die(mysql_error()); echo "<h3><center>Thank You! This is step 2 of 3. </h3>Your email is confirmed. Please upload your C.V. now to complete step 3.</center>"; } else { echo "ERROR: Incorrect activation code... not valid"; } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta content="text/html; charset=utf-8" http-equiv="Content-Type" /> <title>Job application activation</title> </head> <body> <center> <br/><br/><br/> <p align="center"> <form name="form1" method="post" action="upload.php" style="padding:5px;"> <p>Re-enter you Email : <input name="email" type="text" id="email"/></p></form> <form enctype="multipart/form-data" action="upload.php" method="POST"> <input type="hidden" name="MAX_FILE_SIZE" value="4000000"> Upload your C.V.: <input name="userfile" type="file" id="userfile"> <input name="upload" type="submit" id="upload" value="Upload your C.V."/></form> </p> </center> </body> </html> --------upload.php---------- <?php session_start(); if (!isset($_GET['usr']) && !isset($_GET['code']) ) { $msg = "ERROR: The code does not match.."; exit(); } if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0) { $fileName = $_FILES['userfile']['name']; $tmpName = $_FILES['userfile']['tmp_name']; $fileSize = $_FILES['userfile']['size']; $fileType = $_FILES['userfile']['type']; $email = $_POST['email']['user_email']; $fp = fopen($tmpName, 'r'); $content = fread($fp, filesize($tmpName)); $content = addslashes($content); fclose($fp); if(!get_magic_quotes_gpc()) { $fileName = addslashes($fileName); } include 'reg_dbc.php'; $query = "UPDATE subscribers WHERE $email = user_email (name, size, type, content ) ". "VALUES ('$fileName', '$fileSize', '$fileType', '$content')"; mysql_query($query) or die('Error, query failed'); mysql_close($dbname); } ?> <center> <br/> <br/> <br/> <br/> Thank you for uploading your <?php echo "$fileName"; ?> file, completing your registration, and providing us your C.V. for this position. <br/> <br/> <br/> We will contact you if your canditature qualifies. </center> Hi guys i have to create text field & enter data and store in the data base. here im able to create text field but couldn't insert the data. so could anyone please check this code for me. <body> <form method="POST" action="cell.php"> Enter the number of question <input type="text" name="question"> <input type="submit"> <?php $value=$_POST['question']; for($i=0;$i<$value;$i++) { echo "Question NO:"; echo '<input type="text" name="qno">'."\t"; echo "Enter Marks:"; echo '<input type="text" name="marks">'."\t"; echo "<br>"; } ?> </form> <form name="form1" method="post" action="cellresult.php"> <label> <input type="submit" name="Submit" value="Submit"> </label> </form> </body> cellresult.php <body> <?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("test", $con); $sql="INSERT INTO cell (QNO,MARKS) VALUES ('$_POST[qno]','$_POST[marks]')"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "1 record added"; mysql_close($con) ?> </body>
Hi guys,
<form id='contact-form".$KitchConfigID."' name='contact-form".$KitchConfigID."' action='_pages/_kitchenconfig/adm_saveKitchConfig.php?Nav=".$NavHash."&kcid=".$KitchConfigID."' method='POST'>
<div class='row'>
<div class='col-sm-12'>
<div class='md-form mb-0 form-sm'>
<input value='".$KitchConfig."' type='text' id='configname".$KitchConfigID."' name='configname".$KitchConfigID ."' class='form-control'>
<label for='configname".$KitchConfigID ."' class=''>Config Name:</label>
</div>
</div>
</div>
<div class='row'>
<div class='col-sm-12'>
<div class='md-form mb-0 form-sm'>
<select id='designer_".$KitchConfigID."' name='designer_".$KitchConfigID."' class='mdb-select md-form' searchable='Search here..' onchange='changeInput(this.value, ".$SelField.");'>");
$designersql = "SELECT * FROM `tbl_contacts` ORDER BY `FirstName`";
$resultdesigner = $conn->query($designersql);
if ($resultdesigner->num_rows > 0) {
$resultdesigner->MoveFirst;
echo("<option value='designer_".$KitchConfigID."'></option>");
while($rowdesigner = $resultdesigner->fetch_assoc()) {
$DesignerName = $rowdesigner["FirstName"]." ".$rowdesigner["LastName"];
$DesignerID = $rowdesigner["ContactID"];
if($rowdesigner["ContactID"]==$rowkitch["Designer"]){
echo("<option value='".$DesignerID."' selected='selected'>".$DesignerName."</option>");
}
else {
echo("<option value='".$DesignerID."'>".$DesignerName."</option>");
}
}
}
echo("</select>
<input type='text' name='".$SelField."' value='' />
<label for='designer_".$KitchConfigID."' class=''>Designer:</label>
</div>
</div>
</div>
<div class='md-form mb-0 float-right'>
<button type='submit' class='btn btn-outline-danger waves-effect btn-sm float-right'>Save <i class='fas fa-magic ml-1'></i></button>
</div>
$upd_KitchConfigID = $_GET["kcid"];
if(isset($_POST["configname$upd_KitchConfigID"]))
{
$upd_KitchConfig = $_POST["configname$upd_KitchConfigID"];
}
else
{
$upd_KitchConfig = 'NotSet';
$ErrMsg = $ErrMsg . 'No KitchConfig, ';
}
if(isset($_POST["designer$upd_KitchConfigID"]))
{
$upd_KitchConfigDesigner = $_POST["designer_$upd_KitchConfigID"];
}
else
{
$upd_KitchConfigDesigner = 1;
$ErrMsg = $ErrMsg . 'No Designer, ';
}
echo("designer_$upd_KitchConfigID: ".$_POST["designer_$upd_KitchConfigID"]."<br><br>");
This topic has been moved to mod_rewrite. http://www.phpfreaks.com/forums/index.php?topic=352032.0 This topic has been moved to Miscellaneous. http://www.phpfreaks.com/forums/index.php?topic=334031.0 This topic has been moved to Miscellaneous. http://www.phpfreaks.com/forums/index.php?topic=313625.0 This topic has been moved to PHP Applications. http://www.phpfreaks.com/forums/index.php?topic=359282.0 This topic has been moved to MySQL Help. http://www.phpfreaks.com/forums/index.php?topic=331655.0 This topic has been moved to MySQL Help. http://www.phpfreaks.com/forums/index.php?topic=318755.0 Hello guys, i want to create array from mysql what is the script for this...? value like $data = array("1" => .0032, "2" => .0028, "3" => .0021, "4" => .0033, "5" => .0034, "6" => .0031, "7" => .0036, "8" => .0027, "9" => .0024, "10" => .0021, "11" => .0026, "12" => .0024, "13" => .0036, "14" => .0028, "15" => .0025); This topic has been moved to Application Design. http://www.phpfreaks.com/forums/index.php?topic=314453.0 This topic has been moved to Other Libraries and Frameworks. http://www.phpfreaks.com/forums/index.php?topic=355753.0 |
|||||||