editing the values in the form and submit to the mysql database

27 New Member

Hi experts,

I have a form with many textboxes,listb oxes in php.I have a edit button to edit the values in the form.once i click the edit button the existing values should be displayed so that the user can edit those particular values and also that should be updated in the mysql database.kindly reply me as early as possible.

Thanks

Feb 24 '09 #1

Subscribe Reply

2169

TheServant

1,168

Recognized Expert Top Contributor

So when the user clicks edit do you want the page to reload or to just display/enable the text boxes? If you reload you need to send the form to itself (via the action attribute) and check if the method of the page load is "post" and if so, you can have different options with the form via using PHP.
If you don't want the page to load, you need to use javascript to change the form inputs properties and show the "submit" button.

I am not going to write the code for you as the purpose of these forums is not to work for nothing, but help those with some code they already have. Try and get this script working and if you get stuck come back and we'll be happy to help.

PS - How much do you know about PHP and/or MySQL?

Feb 24 '09 #2

Markus

6,050

Recognized Expert Expert

I don't see a question in that post. Please revise your post to include a question and sufficient details of your problem. Also, you should post the code you have attempted to solved your problem with - we do not hand out code.

Moderator.

Feb 24 '09 #3

ahilar12

New Member

hi experts,
I have attached the code for the form and the database connection.
I want the code to edit the existing values in the form and to store the edited values in the database.

res.html

Expand|Select|Wrap|Line Numbers

 
<html>

<head>

<title>post resume</title>

<meta http-equiv=Content-Type" content="text/html">

</head>

<body bgcolor="#CECECE">
 
<h2 style="text-align:center;font-family:courier new;color:#CC3333;font-size:30"><marquee>POST RESUME PAGE</marquee><h2/>

<script type="text/javascript">

function checkform()

{

  var cemail,cmobile,cpercentage,ckeyskills,csalary;

  with(window.document.resumeform)

  {

    cemail=email;

    cmobile=mobile;

    cpercentage=percentage;

    ckeyskills=keyskills;

    csalary=salary;
 
    }
 
    if(trim(cemail.value)=="")

    {

        alert("please enter your email id");

        cemail.focus();

        return false;

    }

    else if(trim(cmobile.value)=="")

    {

        alert("please enter your mobile number");

        cmobile.focus();

        return false;

    }
 
    else if(trim(cpercentage.value)=="")

    {

        alert("please enter your correct percentage");

        cpercentage.focus();

        return false;

    }
 
    else if(trim(ckeyskills.value)=="")

    {

        alert("please enter the keyskills");

        ckeyskills.focus();

        return false;

    }

    else

    {

         cemail.value=trim(cemail.value);

         emobile.value=trim(emobile.value);

         cpercentage.value=trim(cpercentage.value);

         ckeyskills.value=trim(ckeyskills.value);

    }
 
    function trim(str)

    {
 
        return str.replace(/^\s+|\s+$/g,'');
 
    }
 
}
 
</script>
 
<?php
 
echo "Welcome ";
 
?>
 
<form action="res.php" onsubmit="return validate_form(this)" method="POST" name="resumeform" >
 
<table  cellpadding="80" cellspacing="50" >
 
<tr>

<td ><h2>Contact Info</h2></td>

<td ><h2>Educational Info</h2></td>

</tr>
 
</table>
 
<table  cellspacing="10" cellpadding="8">
 
<td>EMAIL</td>

<td><input type="text" name="email"/>eg.abc@gmail.com<font color="red"> *mandatory</font>
 
</td>
 
<td>HIGHEST QUALIFICATION</td>

<td>

<select name="qualification" id="qualification">

<option value="msc" >M.Sc</option>

<option value="mca">MCA</option>

<option value="be">B.E</option>

<option value="mba">MBA</option>

<option value="mtech">M.Tech</option>

</select>

</td>    

</tr>
 
<tr>

<td>MOBILE</td>

<td><input type="text" name="mobile" /><font color="red">*mandatory</font></td>
 
<td>PERCENTAGE</td>

<td><input type="text" name="percentage"/><font color="red">*mandatory</font></td>
 
</tr>
 
<tr>
 
<td>LOCATION</td>

<td>

<select name="location" id="location">

<option value="chennai">Chennai</option>

<option value="mumbai">Mumbai</option>

<option value="delhi">Delhi</option>

<option value="kolkatta">Kolkatta</option>

</select>

</td>    
 
<td>INSTITUTE</td>

<td>

<select name="institute" id="institute">

<option value="anna" >Anna University</option>

<option value="mca">University of Madras</option>

<option value="be">AnnaMalai University</option>

<option value="mba">Kamaraj University</option>

<option value="mtech">Manonmaniam University</option>

</select>

</td>    
 
</tr>
 
<tr>
 
<td>COUNTRY</td>

<td><input type="text" name="country"/></td>
 
<td>OTHERS</td>

<td><input type="text" name="others"/>others specify here</td>
 
</tr>
 
<tr>
 
<td>ADDRESS</td>

<td>

<textarea wrap="virtual" name="address" rows="3" cols="15" STYLE="scrollbar-face-color: #317B9C;

scrollbar-track-color: #87B4C9;

scrollbar-arrow-color: #54A1C4;

scrollbar-3dlight-color: #B8D7E6;

scrollbar-shadow-color: #1E6180;

scrollbar-highlight-color: #7CBCDA;

scrollbar-darkshadow-color: #1E6180">

</textarea>

</td>
 
</tr>
 
</table>
 
<table cellpadding="70" cellspacing="50" >
 
<tr>

<td ><h2>Professional Info</h2></td>

<td ><h2>Preferences Info</h2></td>

</tr>
 
</table>
 
<table border="0" cellspacing="10" cellpadding="8">
 
<tr>
 
<td>JOB CATEGORY</td>
 
<td>

<select name="jobcategory" id="jobcategory">

<option value="software">Software</option>

<option value="networking">Networking</option>

<option value="finance">Finance</option>

<option value="sales">Sales</option>

</select>
 
</td>
 
<td>PREFERRED JOB LOCATION</td>
 
<td>

<select name="joblocation" id="joblocation">

<option value="chennai" >Chennai</option>

<option value="delhi">Delhi</option>

<option value="kolkatta">Kolkatta</option>

<option value="mumbai">Mumbai</option>

</select>

</td>    

</tr>
 
<tr>

<td>EXPERIENCE</td>

<td>

<select name="experience" id="experience">

<option value="0" >1</option>

<option value="1" >1</option>

<option value="2">2</option>

<option value="3">3</option>

<option value="4">4</option>

</select>

</td>    
 
<td>SALARY EXPECTATION</td>

<td><input type="text" name="salary"/></td>
 
</tr>
 
<tr>
 
<td>KEY SKILLS</td>

<td>

<input type="text" name="keyskills"/><font color="red">* mandatory</font>

</td>    
 
<td>RESUME TITLE</td>

<td>

<input type="text" name="resumetitle"/>

</td>    
 
</tr>
 
<tr>
 
<td>EMPLOYER</td>

<td><input type="text" name="employer"/></td>
 
<td><a href="upload.html"><strong>CLICK HERE TO UPLOAD YOUR RESUME</strong></a>

</tr>
 
<!-- <td>UPLOAD RESUME</td>

<td>

<form action="uploadfile.php" method="POST">

<input type="file" name="file" id="file" accept="text/doc"/>

</td>

</form>

</tr>
 
<tr>

<td></td><td></td>

<td>OR COPY RESUME AND PASTE HERE</td>
 
<td>

<textarea rows="5" cols="30" name="copyresume">

</textarea>

</td>
 
</tr>

 -->
 
</table>
 
</br>
 
 <form><center> <input type="submit" name="send" value="POST RESUME" onclick="return checkform()" style="color:#FF6666;background:#FFFFCC" /></center></form>

 <form><center> <input type="submit" value="EDIT RESUME" style="color:#FF6666;background:#FFFFCC" /></center></form>
 
</form>

</body>

</head>

</html>

res.php

Expand|Select|Wrap|Line Numbers

 
<?php
 
$con=mysql_connect("localhost","root","");

if(!con)

{

    die("cannot connect".mysql_error());

}
 
    mysql_select_db("resume_db",$con);
 
    mysql_query("insert into res_table
 
    (uname,email,qualification,mobile,percentage,location,institute,country,others,address,jobcategory,joblocation,experience,salary,keyskills,resumetitle,employer) 
 
    values
 
    ('$_POST[uname]','$_POST[email]','$_POST[qualification]','$_POST[mobile]','$_POST[percentage]','$_POST[location]','$_POST[institute]','$_POST[country]','$_POST[others]','$_POST[address]','$_POST[jobcategory]','$_POST[joblocation]','$_POST[experience]','$_POST[salary]','$_POST[keyskills]','$_POST[resumetitle]','$_POST[employer]')") or die(mysql_error());
 
     $result = mysql_query("SELECT * FROM res_table");
 
      echo "<h3>"."You have successfully uploaded your resume"."</h3>."."<br/>";
 
       echo "<h4>"."The contents uploaded in your  resume are as follows"."<h4>";
 
while($row = mysql_fetch_array($result))

  {
 
      echo "<table align='left' cellspacing='8' cellpadding='20'>";
 
  echo "<tr>"."<td>"."<b>"."Email:"."&nbsp;"."&nbsp;".$row['email']."</td>"."</tr>";

  echo "<tr>"."<td>"."<b>"."Mobile:"."&nbsp;"."&nbsp;".$row['mobile']."</td>"."</tr>";

  echo "<tr>"."<td>"."<b>"."Location:"."&nbsp;"."&nbsp;".$row['location']."</td>"."</tr>";

  echo "<tr>"."<td>". "<b>"."Country:"."&nbsp;"."&nbsp;".$row['country']."</td>"."</tr>";

  echo "<tr>"."<td>"."<b>"."Address:"."&nbsp;"."&nbsp;".$row['address']."</td>"."</tr>";

  echo "<tr>"."<td>"."<b>"."Qualification:"."&nbsp;"."&nbsp;".$row['qualification']."</td>"."<tr>";

  echo "<tr>"."<td>"."<b>"."Percentage:"."&nbsp;"."&nbsp;".$row['percentage']."</td>"."</tr>";

  echo "<tr>"."<td>"."<b>"."Institute:"."&nbsp;"."&nbsp;".$row['institute']."</td>"."</tr>";
 
     echo "</table>";
 
    echo "<table align='center' cellspacing='8' cellpadding='20'>";
 
 echo "<tr>"."<td>"."<b>"."Job Category:"."&nbsp;"."&nbsp;".$row['jobcategory'] ."</td>"."</tr>";

  echo "<tr>"."<td>"."<b>"."Job Location:"."&nbsp;"."&nbsp;".$row['joblocation']."</td>"."</tr>";

  echo "<tr>"."<td>"."<b>"."Experience:"."&nbsp;"."&nbsp;".$row['experience']."</td>"."</tr>";

  echo "<tr>"."<td>"."<b>"."Salary:"."&nbsp;"."&nbsp;".$row['salary']."</td>"."</tr>";

  echo "<tr>"."<td>"."<b>"."KeySkills:"."&nbsp;"."&nbsp;".$row['keyskills']."</td>"."</tr>";

  echo "<tr>"."<td>"."<b>"."Resume Title:"."&nbsp;"."&nbsp;".$row['resumtitle']."</td>"."</tr>";

  echo "<tr>"."<td>"."<b>"."Employer:"."&nbsp;"."&nbsp;".$row['employer']."</td>"."</tr>";

    echo "<tr>"."<td>"."<b>"."Others:"."&nbsp;"."&nbsp;".$row['others']."</td>"."</tr>";
 
       echo "</table>";
 
  }
 
 ?>

kindly somebody help me out on this code.urgent.

Thanks

Feb 26 '09 #4

hoopy

New Member

The code display on this site is not wide enough in my opinion.

What exactly are you trying to achieve? I assume its an basic insert of a record, then pulling it out again and displaying it?

When you insert the data you could then get the last ID entered with mysql_insert_id () then you can pull it out again I guess something like:

Expand|Select|Wrap|Line Numbers

 mysql_query(".. insert all the data here ..");

$some_id = mysql_insert_id();

$display_q = mysql_query(" select foo from bar where some_id = '$some_id' ");

$row = mysql_fetch_array($display_q);

Then display the data as need be. It seems like you are trying to pull everything again and display it.

Can you advise what the actual problem is.

Thanks.

Feb 26 '09 #5

ahilar12

New Member

Thanks for u r reply hoopy,
I m a beginner to php.so the code will not be that much wide enough.any way i m developing a small demo application like a jobsite for my project.
created a login page,profile page and the post resume page to input the details of the candidates.here i have 2 buttons one to post resume and the other is to edit resume .
if we click the edit resume button the existing values of the user should be populated in the inputboxes and listboxes and the user is allowed to edit those values and once the edit resume button is clicked the values gets updated in the database and displayed again.
Able to catch atleast to some extent.pls try to help me out on this.need a sample code for this.

Thanks

Feb 26 '09 #6

hoopy

New Member

I dont know how you have your DB setup and I have dont have a lot of time right now but if you can follow this then you can see quite simply how it works. Say your DB Is laid out like this:

Expand|Select|Wrap|Line Numbers

 --

-- Database: `job_db`

--
 
CREATE TABLE `resumes` (

  `user_id` int(10) unsigned NOT NULL auto_increment,

  `full_name` varchar(100) NOT NULL,

  `salary` varchar(100) NOT NULL,

  `joined` int(11) NOT NULL,

  PRIMARY KEY  (`user_id`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 ;

Say you had this basic example as your form:

Expand|Select|Wrap|Line Numbers

 <form action="display.php" method="post">

Full Name: <input type="text" name="full_name"> <br />

Salary: <input type="text" name="salary"> <br />

<input type="submit" name="submit" value="Insert">

</form>

Then display.php would be like this:

Expand|Select|Wrap|Line Numbers

 <?
 
// db connection

mysql_connect("localhost", "root", "")

  or die(mysql_error());

mysql_select_db("job_db")

  or die(mysql_error());
 
// sanitise user input

$full_name = mysql_real_escape_string($_POST['full_name']);

$salary = mysql_real_escape_string($_POST['salary']);

$time = time();
 
// insert the data

mysql_query("

  INSERT INTO resumes 

  (full_name, salary, joined)

  VALUES

  ('$full_name', '$salary', $time)

") or die(mysql_error());
 
// retrieve the last id inserted 

$user_id = mysql_insert_id();
 
// pull it back out

$query = mysql_query("

  SELECT full_name, salary, joined 

  FROM resumes 

  WHERE user_id = '$user_id' 

") or die(mysql_error());
 
// store the row

$row = mysql_fetch_array($query);
 
// display the output 

echo ("Name: " . $row['full_name'] . "<br />");

echo ("Salary: " . $row['salary'] . "<br />");

echo ("Joined: " . strftime("%H:%M %d/%m/%y", $row['joined']));
 
?>

I have tried to keep it as simple as possible. So if you went to that form, and entered those variables it would sanitise the input. Input the data into the table then retrieve the ID which was just inserted, pull it out again and display it.

So it may look something like:

Expand|Select|Wrap|Line Numbers

 Name: Hoopy

Salary: 100

Joined: 17:40 26/02/09

If you follow this principle with your code then you should be OK. mysql_insert_id is what you need to look into and the ID it will return is determined by how your database table is setup.

Also the comment about the width was not about your code, it was about the width which Bytes makes the code display, its always a bit too narrow imo.

Hope this help. Good Luck.

Feb 26 '09 #7

ahilar12

New Member

hi hoopy,

Good After noon,
thanks for u r code.i will check out and revert back to u.

Thanks

Feb 27 '09 #8

Markus

6,050

Recognized Expert Expert

Please keep off-topic discussion outside of this thread please.

Thank you.

- Markus.

Feb 27 '09 #9

Similar topics

4432

form data will not post

by: Nomen Nescio | last post by:

can anyone be so kind as to look at http://www.mysolution.ws/HYPOCRITE.php and let me know why it isn't passing the form data to http://www.mysolution.ws/insertHYPOCRITES.php for the most part, the scripts were created with http://phpcodegenie.sourceforge.net/

PHP

2391

Problems with formatting and editing a php script

by: Dan Weeb | last post by:

Hi All, I have struggled through this far with help from many of you so thanks. I am stuck again. I am really new to this so don't be harsh :-) There are a few problems. You can run the script here http://www.pbrown.com/research/test1.php to see the formatting issues Formatting Issues

PHP

1781

Editing and Updating Text

by: Bob Kaku | last post by:

I'm trying to create a text editing and updating capability to help someone who wants to maintain content on a web page without having to know any HTML or use a web authoring tool and FTP'ng the contents. I've already created a screen whereby the person can create new content with a PHP program that inserts into a MySQL table. But, I'm having a little trouble in creating the edit/update functionality. Can somebody help me out? Thanks. ...

PHP

3658

Selecting Table row records for editing

by: webhigh | last post by:

I¹m not sure if this a PHP question or an MySQL question but here it goes. I have a repeat region of a table called userid What I¹m trying to accomplish is being able to edit the record and then update it by clicking a submit button on the same line. I¹m doing it this way so the user can quickly update a number of records one at a time. I know I could do this by passing the userid info to a detail page but really want to do it the way...

PHP

1024

Overall editing DataGrids

by: Sebi | last post by:

Hello All, I'm having problems, reading the new Values from CheckBox in a DataGrid. my Code Behind is C# I do exactly what other samples do, but I allways get the Initial Values instead of the current values choosen by the user!!

ASP.NET

7039

Storing dynamic form values in Arrays for display & insert

by: assgar | last post by:

Hi Developemnt on win2003 server. Final server will be linux Apache,Mysql and PHP is being used. I use 2 scripts(form and process). The form displays multiple dynamic rows with chechboxs, input box for units of service, description of the service and each row has its own dropdown list of unit fees that apply. Each dynamically created row will return 3 values fee1_choice, fee1_unit and fee1_money. Note The above informaton is...

PHP

2498

Insert List menu values to Mysql

by: dongletran06 | last post by:

Hi, Please help me find out what wrong with my codes in inputting from my form to mysql database using drop down menu. Below is the codes I used. Only the drop down is not working but the "input text" are successfully adding data to mysql. I just try first using the month as drop down. The month data type I used in mysql database is varchar. Im new in PHP please help me. Thanks <?php /* Created on: 10/12/2006 */ ?> <html> <body> <?php...

PHP

3195

INSERT INTO statement won't take variables as values!

by: adamace5o | last post by:

When i try to use post variables with php and mysql i can't get the insert into statement to accept varibles as values. If i use 'test' instead of $test it does work. I suspect it is something to do with the javascript im using but i can print the correct values so why am i unable to use them to enter data to a database? sorry i am new to all this here is the updatedata.php file <?php session_start(); $host="localhost"; // Host...

MySQL Database

2942

problem with inserting file name in database

by: liberty1 | last post by:

Hi everyone. I appreciate your effort at helping newbies like me. I have the following problems and will appreciate urgent help. PROBLEM NUMBER 1: Using PHP and MySQL, I am able to upload picture successfully unto the server but not so with the file name of the picture even though other parameters in my form got inserted successfuly in the database. I have read several posts on this topic including here on this site but I can't get around...

PHP

7883

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8261

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8019

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

6674

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

5839

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5418

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

3911

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1490

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1223

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General