Ad:

JavaScript / DHTML / AJAX Discussion Thread
Unsolved
Views: 2715

Dec 5th, 2007

trying to create a 'simple' admin page to update mysql dbase

Expand Post »

Hi,

I am trying to create a 'simple' admin page where certain (authorized) people can update data in the database or add new info to it. The issue i've run into is after i created the form and have all the fields how do i tell which one(s) the user has typed into/edited so i can use that info in a query.

I was thinking i might need to use the onchange event but not sure how i'd track each field that was changed and then update only those, i even checked some of phpmyadmin's code to see how they do it but couldnt really figure it out.

Help plz

ray_broome

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

25 posts
since Aug 2004

Permalink

Dec 5th, 2007

Re: trying to create a 'simple' admin page to update mysql dbase

Well that's more of a PHP thing, not so much with JavaScript. You can't do alot(anything?) in Javascript to interact with a database.

ShawnCplus

Sponsor

Reputation Points: 520

Solved Threads: 268

Code Monkey

Offline

1,564 posts
since Apr 2005

Permalink

Dec 5th, 2007

Re: trying to create a 'simple' admin page to update mysql dbase

well the thing is i'm not interacting with the database at this point. The 'fields' i'm referring to are the html form fields where a user would type things such as a name, etc.

e.g. If i had:

JavaScript / DHTML / AJAX Syntax (Toggle Plain Text)
Search for a Plant to update:
Scientific Name _____
Common Name _____
[Search]
Search for a Plant to update:
Scientific Name _____
Common Name _____
[Search]

How do i tell which field the user has typed in here (sci name/com name or both) so that i can pass that text into a query later on.

ray_broome

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

25 posts
since Aug 2004

Permalink

Dec 5th, 2007

Re: trying to create a 'simple' admin page to update mysql dbase

JavaScript / DHTML / AJAX Syntax (Toggle Plain Text)
var blah = document.getElementById(<textbox id>);
if(blah.value == "")
  alert("blah is empty");
var blah = document.getElementById(<textbox id>);
if(blah.value == "")
  alert("blah is empty");

ShawnCplus

Sponsor

Reputation Points: 520

Solved Threads: 268

Code Monkey

Offline

1,564 posts
since Apr 2005

Permalink

Dec 6th, 2007

Re: trying to create a 'simple' admin page to update mysql dbase

You can just validate it through javascript(Or to check if that field has some value or not.) But, Its much easier if you do it in php. eg.

php Syntax (Toggle Plain Text)
 if(isset($_POST['sci_name'])){
echo "Scientific name is ". $_POST['sci_name'];
}
if(isset($_POST['name'])){
echo "General name is ". $_POST['name'];
}
 if(isset($_POST['sci_name'])){
echo "Scientific name is ". $_POST['sci_name'];
}
if(isset($_POST['name'])){
echo "General name is ". $_POST['name'];
}

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in JavaScript / DHTML / AJAX Forum Timeline: cant get the spacing on menu bottons to change

Next Thread in JavaScript / DHTML / AJAX Forum Timeline: JavaScript not working in Internet Explorer 7

DaniWeb Message

Cancel Changes

User Name
Password