Closed

Simple PHP/MySQL Script(repost)

This project was awarded to alanmunoz for $63.75 USD.

Get free quotes for a project like this
Employer working
Project Budget
$30 - $5000 USD
Total Bids
23
Project Description

PHP 4.4.8 Compatable

MySQL 4.1.22-standard

Looking for a quick and simple PHP script that will take several fields from a database and input them into a template, ouptuting HTML

Example Template:

<table>

<tr>

<td>Description</td>

<td/>%%DESCRIPTION%%</td>

</tr>

</table>

Example Database:

Description = "Nice 3 bedroom 2 bathroom home on 3 acres with shop."

Example Output:

<table>

<tr>

<td>Description</td>

<td/>Nice 3 bedroom 2 bathroom home on 3 acres with shop.</td>

</tr>

</table>

Database Fields and Variables Needed:

%%VIRTUALTOUR%%

%%TITLE%%

%%LINK%%

%%WEBLINK%%

%%IMGFILENAME%%

%%IMGLINK%%

%%FOOTER1%%

%%FOOTER2%%

%%ADDRESS%%

%%CITY%%

%%STATE%%

%%ZIP%%

%%MLS%%

%%PRICE%%

tbl_properties

propertyID (pk)

virtualtour

link

weblink

imgfilename

imglink

footer1

footer2

active

address

city

state

zip

mls

price

tbl_templates

templateID (pk)

template

active

tbl_users

userID (pk)

username

password

active

Workflow:

Login

Dashboard lists tblProperties (where active = true) (make a toggle to show inactive properties if needed)

Property listed as

MLS ? Price ? Address City, State Zip

MLS ? Price ? Address City, State Zip

MLS ? Price ? Address City, State Zip

MLS ? Price ? Address City, State Zip

clicking on MLS brings up screen to show all info to Review/Update/Delete

Below opportunity to select template from dropdown and generate HTML to be copied and pasted (needs to save any changes in updates if needed before generating HTML)

User copies HTML generated from selected template can exit to main dashboard

User can repeat or log out.

Need SIMPLE interface to Create,Review,Update,Mark user inactive - single role just for a tool.

Deliverables to be Zip File with Install Scripts + PHP Files + Instructions

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online