Closed

Joomla - PHP to Delete and Update a table

Must have 'experience':

1. Joomla 1.5

2. PHP/MySQL

Plus Points but not a must:

1. Writing Plugins, Components and Modules

2. RSFormPro and in particular mod_rsform_list

3. Jumi

4. Experience with CB

Must have examples of custom coding in Joomla 1.5 !

AGAIN.

Must have examples of custom coding in Joomla 1.5 !

I am a PHP/MySQL deverloper and am ONLY interested in someone with actual experience in custom coding (PHP) in Joomla 1.5

DETAILS:

+++++++++++++++++++++++++++++

I have a custom table with data entered through a form in Joomla

Table1:

id - SubissionID - FieldName - FieldValue

-------------------------------

1 - 1 - FirstName - Mike

2 - 1 - LastName - Smith

3 - 1 - UserID - 52

4 - 2 - FirstName - John

5 - 2 - LastName - Doe

6 - 2 - UserID - 53

......

I am displaying each SubmissionID in a row.

eg,

Mike Smith - Edit - Delete

John Doe - Edit - Delete

What YOU need to do:

1. On clicking Edit, it should take the visitor to a form that will display the FieldValue s and the visitor can change the value and submit.

Upon submit the data should update in the MySQL table.

Basically run SQL Update.....WHERE SubmissionID = ?

2. On clicking Delete, it should pop up a message that says "Are you sure you want to delete this record ?", with YES and CANCEL buttons.

Clicking YES will delete the particular record.

Basically run DELETE ....WHERE SubmissionID = ?

Clicking CANCEL will do nothing.

All the data were originally entered by members (CB is used).

Members should be able to delete only the data they themselves inserted before.

The funcationality to add the data is already done. So you don't need to do that.

IMPORTANT:

So your code will need to make sure the records being deleted belongs to the member.

For instance if you send the SubmissionID through the URL

eg, http://www......com/..../?SubmissionID=2

and then

DELETE ....WHERE SubmissionID = $_GET['SubmissionID']

That could be a PROBLEM.

Any programmer can easily throw in a different SubmissionID on the URL and delete and update records that they are not supposed to.

Therefore, your code must validate if the records belong to the member (UserID).

+++++++++++++++++++++++++++++

OK, that's a lot of technical details.

I am sure it's not a tough job for the right candidate.

I have some more much tougher work.

Please provide Joomla 1.5 custom work examples.

Thanks

vj

Skills: Joomla, PHP

See more: joomla update table, mod_rsform_list joomla, query editdelete records joomla, small php mysql, update table joomla, php mysql update table joomla, update mysql joomla, you can do what you want to do, www custom writing com, what is sql coding, what do you need to do a programmer, php sql programmer, php deverloper, php components, php and sql programmer, i am a php programmer, custom code joomla, code for update in php, be smith, joomla php update table, joomla jumi table delete row, update table row joomla, joomla delete records table php, update records joomla, jumi mysql

About the Employer:
( 1 review ) Jersey City, United States

Project ID: #463413

14 freelancers are bidding on average $126 for this job

qtsteam

Please check PMB for details, Thanks.

$140 USD in 5 days
(135 Reviews)
8.4
VALUEONWEB

We have reviewed your project, kindly check pmb for more details

$200 USD in 4 days
(215 Reviews)
7.9
omtechnologies

Joomla Component Builder at your service. Please check PMB for details.

$150 USD in 1 day
(158 Reviews)
7.4
nkakwani

Lets do it. Thanks!!!

$150 USD in 1 day
(35 Reviews)
5.6
azsolution

hello, I have worked many projects with zend, joomla cms, pure PHP + MYSQL. so I can do this one for you. Please contact with me and we will discuss and work together. Thanks. Latest sites that I have built: - http More

$50 USD in 2 days
(25 Reviews)
5.6
hasanur

Please check your PM

$50 USD in 1 day
(25 Reviews)
4.9
earlysail

Lets start now. Kindly check PM for proposal.

$200 USD in 2 days
(7 Reviews)
4.6
ingxiong

Don't use GET

$30 USD in 1 day
(6 Reviews)
4.3
warlockleviathan

Hi. This doesnt sound too difficult. Ive been doing customisation of Joomla sinc it came out. And Ive got experience using Jumi and CB. Check your PM for my portfolio

$175 USD in 2 days
(4 Reviews)
3.8
ruetcse329

I am confident to do [url removed, login to view] Check PM.

$80 USD in 2 days
(8 Reviews)
3.4
joomlafaces

Please check PM. Thank you.

$250 USD in 4 days
(2 Reviews)
1.0
bulentant

Hi, I have knowledge on joomla and worked in many joomla projects

$50 USD in 7 days
(0 Reviews)
0.0
subhajyoti007

Hello Sir, I have gone through your requirements and ready to start your project. I have been working for two years and developed near about seventy websites. I assure you that I will exactly what you want. You will be More

$145 USD in 2 days
(0 Reviews)
0.0
greatworld

Dear Sir, I'm a php/mysql/joomla developer. I'm interested in your project and i think i could apply for it. Here is the time to get more comments so I would bid lowest if possible. You can view my recent works here: More

$100 USD in 3 days
(1 Review)
0.0