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