PHP coding and some scriptwriting

Finalizat Postat la Aug 20, 2008 S-au achitat serviciile după ce au fost prestate
Finalizat S-au achitat serviciile după ce au fost prestate

I want to modify my website. It is now built in very simple .html and .php code

? 1- I want to add a mysql database that will contain links to different .html pages that will be included in .php pages. I want to be able to work the database from an Excel page that I will then upload to the server

? 2- I will need 4 scripts that will query the database and return the results in .html form that will be included in .php pages.

? 3- 4 tables will be setup for metrics, I will need 4 queries to analyze those tables, the result will be Excel compatible

? 4- You will also code the [url removed, login to view] page that will define how the tables are setup, what goes in each cell and what style is used

## Deliverables

The mysql database

?

| You must build the database so that it is compatible with excel. I must be able to upload my excel sheets to the server.

The folders containing the images will be sent to server through FTP

Table 1 is the main table from which the [url removed, login to view], [url removed, login to view], [url removed, login to view] and the galleries are built

column 1 "date" Every day, there is? a new article added to the homepage, this column has the date that the articles are added to the homepage. Below today's article, I will display yesterday's article and below that. the article of the day before etc ... date will be formatted as [url removed, login to view], [url removed, login to view] etc ...

column 2 "main keyword" serves as the title for the gallery (the ads will be generated from the link with this keyword

column 3 "long description" includes about 60 words with 1 thumbnail (written in .html)

column 4 "short description1" this is about 20 words and will be returned as the search result, it will link to the gallery

column 5 "short description2" this is about 20 words and goes on top of gallery, this links to my sponsor and is one of the ads that will be compiled

column 6 "secondary keyword"

column 7 "message" that will be displayed at bottom of generated gallery (written in .html)

column 8 this column will have the code for the style of gallery to generate (different gallery style will be generated )

column 9 will link to [url removed, login to view] that will be used on [url removed, login to view], it will resize at 120 dpi vertical with proportions maintained

column 10 to column 20 "[url removed, login to view] to [url removed, login to view]" links to the main images from which the thumbnails and full size

? images will be generated. Format will be [url removed, login to view]

column 21 will contain "title" that will be included in generated .php file

column 22 will contain "third keyword" these will be included in .php file

column 23 will contain "short description1" but without the link, this will be included in .php file

Table 2 is the thumbnails ads table

column 1 "ad itself" this is a link to one sponsor including a link to display the actual thumbnail that serves as the ad

column 2 "main keyword"

column 3 "secondary keyword"

column 4 "third keyword"

column 5 "fourth keyword"

Table 3 is for metrics, I want to compile all clicks on the thumbnail ads

column 1 what ad is clicked on

column 2 the date on which the ad is clicked

column 3 the page on which the ad is clicked

Table 4 is for metrics, I want to compile all clicks on short description2

column 1 the date on which the ad is clicked

column 2 the page on which the ad is clicked

column 3 the link itself

Table 5 is for metrics, I want to compile all clicks on the main [url removed, login to view]

column 1 what links to other pages are clicked on the homepage

column 2 the date on which the ad is clicked

Table 6 is for metrics

column 1 all the search words that are inputted in the search box

column 2 the date on which the search word is inputted

? |

The queries

| These are the queries that will query the database, there are 4 main queries to program.

Query 1

Everyday, the script will post a new article that is about 60 words

1- I want the script to add the article of the day on top of the previous day's article which is itself on top of the previous day's article etc ... (please see the table below to get a better idea of what I want) The homepage goes back 30 days, so if today is the aug 8, it goes back to jul 9.

2- below the articles of the last 30 days, I want to post "short description1" of the previous 60 articles of the day, these will link to the actual galleries

3- The style is formatted so that each article alternates between a black and a charcoal background.

Query 2

The articles will be searchable, the return page will show "short description1" which will link to the galleries.

The search box will be located on top of the right column above the thumbnail ads

Query 3

1- Another query will list the galleries according to the first letter of "short description1".

Pages will be labeled A-C, D-G etc

Setup of the page will be the same as the setup for Query 2

Query 4 will generate the galleries

1- There will be about 4 different types of galleries according to what type of setup is associated with this gallery

2- The right column will generate ads related to the keyword associated with the gallery

3- The thumbnails in the gallery will link to [url removed, login to view] |

The ads

| How **the thumbnail ads** will display

The ads on main [url removed, login to view] will be formatted by me

The ads on the alphabetical query page will be formatted by me

The ads on the main query page (the ones called by the search box) will be relative to the main keywords of "short description1" they will display in a random manner,

They will appear in the right column |

How I want to query the metrics database

| Thumbnail ads queried will? be imported in excel to analyze.

The query will return

1- date

2- what ad

3- what page the ad was clicked on

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

Short description2 (the ones linking to my sponsors) will? be imported in excel to analyze.

The query will return

1- date

2- what ad

3- what page the ad was clicked on

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

I want to analyze the links that my surfers click on my homepage.

The queries generated (according to date) will? be imported in excel to analyze.

The query will return

1- date

2- what link

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

I want to analyze the search terms that will be inputted in the search box

The queries generated (according to date) will? be imported in excel to analyze.

The query will return

1- date

2- what words |

The [url removed, login to view] page

| There will be 4 [url removed, login to view] pages that will define the 4 main query pages.

The [url removed, login to view] page will define

1- how the tables are setup

2- what to include in each cell

3- the style of each cell |

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

The tables

The tables are formatted to fill the full screen of all sizes of monitors and to be viewable in all popular browsers. The main style for the body font is trebuchet MS size 12, color ffffff. The links are ffcc66 when static and ff0000 when rolled over.

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

Table setup for the [url removed, login to view]

<div align="center">

? ? ? <table border="1" width="800" cellspacing="0" cellpadding="0">

? ? ? ? <tr>

? ? ? ? ? <td>[url removed, login to view]</td>

? ? ? ? ? <td>

? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? <td>[url removed, login to view]</td>

? ? ? ? </tr>

? ? ? ? <tr>

? ? ? ? ? <td>[url removed, login to view]</td>

? ? ? ? ? <td>

? ? ? ? ? <div align="center">

? ? ? ? ? ? <table border="1" width="750" cellspacing="0" cellpadding="0">

? ? ? ? ? ? ? <tr>

? ? ? ? ? ? ? ? <td>

? ? ? ? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? ? ? ? <td>

? ? ? ? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? ? ? </tr>

? ? ? ? ? ? </table>

? ? ? ? ? </div>

? ? ? ? ? <div align="center">

? ? ? ? ? ? <table border="1" width="750" cellspacing="0" cellpadding="0">

? ? ? ? ? ? ? <tr>

? ? ? ? ? ? ? ? <td colspan="2">

? ? ? ? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? ? ? </tr>

? ? ? ? ? ? ? <tr>

? ? ? ? ? ? ? ? <td colspan="2">

? ? ? ? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? ? ? </tr>

? ? ? ? ? ? ? <tr>

? ? ? ? ? ? ? ? <td width="518">

? ? ? ? ? ? ? ? <p align="center">[url removed, login to view]<br>

? ? ? ? ? ? ? ? this cell will return long description with a

? ? ? ? ? ? ? ? thumbnail to the left, <br>

? ? ? ? ? ? ? ? dimension of this cell is about 80 x 600</td>

? ? ? ? ? ? ? ? <td rowspan="6" width="226">

? ? ? ? ? ? ? ? <p align="center">[url removed, login to view]<br>

? ? ? ? ? ? ? ? this cell will have one box for search term and

? ? ? ? ? ? ? ? one button for GO<br>

? ? ? ? ? ? ? ? -----------------------<br>

? ? ? ? ? ? ? ? this cell will display a series of ads of my

? ? ? ? ? ? ? ? choosing<br>

? ? ? ? ? ? ? ? <br>

? ? ? ? ? ? ? ? [url removed, login to view]<br>

? ? ? ? ? ? ? ? [url removed, login to view]<br>

? ? ? ? ? ? ? ? [url removed, login to view]<br>

? ? ? ? ? ? ? ? [url removed, login to view]<br>

? ? ? ? ? ? ? ? [url removed, login to view]<br>

? ? ? ? ? ? ? ? [url removed, login to view]<br>

? ? ? ? ? ? ? ? <br>

? ? ? ? ? ? ? ? these ads will be randomly displayed from the

? ? ? ? ? ? ? ? ads database, similar to the script already used

? ? ? ? ? ? ? ? for the days of the week<br>

? ? ? ? ? ? ? ? Background for this column will be one color</td>

? ? ? ? ? ? ? </tr>

? ? ? ? ? ? ? <tr>

? ? ? ? ? ? ? ? <td width="518">

? ? ? ? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? ? ? </tr>

? ? ? ? ? ? ? <tr>

? ? ? ? ? ? ? ? <td width="518">

? ? ? ? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? ? ? </tr>

? ? ? ? ? ? ? <tr>

? ? ? ? ? ? ? ? <td width="518">

? ? ? ? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? ? ? </tr>

? ? ? ? ? ? ? <tr>

? ? ? ? ? ? ? ? <td width="518">

? ? ? ? ? ? ? ? <p align="center">etc ... until today-30</td>

? ? ? ? ? ? ? </tr>

? ? ? ? ? ? ? <tr>

? ? ? ? ? ? ? ? <td width="518">

? ? ? ? ? ? ? ? <p align="center">These cells are formatted to alternate

? ? ? ? ? ? ? ? background between black and charcoal.</td>

? ? ? ? ? ? ? </tr>

? ? ? ? ? ? ? <tr>

? ? ? ? ? ? ? ? <td colspan="2">

? ? ? ? ? ? ? ? <p align="center">short description of today -31

? ? ? ? ? ? ? ? [url removed, login to view]</td>

? ? ? ? ? ? ? </tr>

? ? ? ? ? ? ? <tr>

? ? ? ? ? ? ? ? <td colspan="2">

? ? ? ? ? ? ? ? <p align="center">short description of today -32

? ? ? ? ? ? ? ? [url removed, login to view]</td>

? ? ? ? ? ? ? </tr>

? ? ? ? ? ? ? <tr>

? ? ? ? ? ? ? ? <td colspan="2">

? ? ? ? ? ? ? ? <p align="center">etc ... until short

? ? ? ? ? ? ? ? description of today -60 [url removed, login to view]</td>

? ? ? ? ? ? ? </tr>

? ? ? ? ? ? ? <tr>

? ? ? ? ? ? ? ? <td colspan="2">

? ? ? ? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? ? ? </tr>

? ? ? ? ? ? ? <tr>

? ? ? ? ? ? ? ? <td colspan="2">

? ? ? ? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? ? ? </tr>

? ? ? ? ? ? </table>

? ? ? ? ? </div>

? ? ? ? ? </td>

? ? ? ? ? <td>[url removed, login to view]</td>

? ? ? ? </tr>

? ? ? ? <tr>

? ? ? ? ? <td>[url removed, login to view]</td>

? ? ? ? ? <td>

? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? <td>[url removed, login to view]</td>

? ? ? ? </tr>

? ? ? </table>

? ? </div>

? </div>

</div>

<p align="center">Table setup for [url removed, login to view] and [url removed, login to view]</p>

<div align="center">

? <table border="1" width="800" cellspacing="0" cellpadding="0">

? ? <tr>

? ? ? <td>[url removed, login to view]</td>

? ? ? <td>

? ? ? <p align="center">[url removed, login to view]</td>

? ? ? <td>[url removed, login to view]</td>

? ? </tr>

? ? <tr>

? ? ? <td>[url removed, login to view]</td>

? ? ? <td>

? ? ? <div align="center">

? ? ? ? <table border="1" width="750" cellspacing="0" cellpadding="0">

? ? ? ? ? <tr>

? ? ? ? ? ? <td>

? ? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? ? <td>

? ? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? </tr>

? ? ? ? </table>

? ? ? </div>

? ? ? <div align="center">

? ? ? ? <table border="1" width="750" cellspacing="0" cellpadding="0">

? ? ? ? ? <tr>

? ? ? ? ? ? <td colspan="2">

? ? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? </tr>

? ? ? ? ? <tr>

? ? ? ? ? ? <td colspan="2">

? ? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? </tr>

? ? ? ? ? <tr>

? ? ? ? ? ? <td width="506">

? ? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? ? <td rowspan="8" width="238">

? ? ? ? ? ? <p align="center">[url removed, login to view]<br>

? ? ? ? ? ? this cell will have one box for search term and one

? ? ? ? ? ? button for GO<br>

? ? ? ? ? ? -----------------------<br>

? ? ? ? ? ? [url removed, login to view]<br>

? ? ? ? ? ? [url removed, login to view]<br>

? ? ? ? ? ? [url removed, login to view]<br>

? ? ? ? ? ? [url removed, login to view]<br>

? ? ? ? ? ? [url removed, login to view]<br>

? ? ? ? ? ? [url removed, login to view]<br>

? ? ? ? ? ? <br>

? ? ? ? ? ? the ads will be pulled out of a database, they will be

? ? ? ? ? ? relevant to the keywords attached to &quot;short

? ? ? ? ? ? description 1&quot;<br>

? ? ? ? ? ? Background will be one color</td>

? ? ? ? ? </tr>

? ? ? ? ? <tr>

? ? ? ? ? ? <td width="506">

? ? ? ? ? ? <p align="center">result+[url removed, login to view]</td>

? ? ? ? ? </tr>

? ? ? ? ? <tr>

? ? ? ? ? ? <td width="506">

? ? ? ? ? ? <p align="center">result+[url removed, login to view]</td>

? ? ? ? ? </tr>

? ? ? ? ? <tr>

? ? ? ? ? ? <td width="506">

? ? ? ? ? ? <p align="center">result+[url removed, login to view]</td>

? ? ? ? ? </tr>

? ? ? ? ? <tr>

? ? ? ? ? ? <td width="506">

? ? ? ? ? ? <p align="center">result+[url removed, login to view]</td>

? ? ? ? ? </tr>

? ? ? ? ? <tr>

? ? ? ? ? ? <td width="506">

? ? ? ? ? ? <p align="center">result+[url removed, login to view]</td>

? ? ? ? ? </tr>

? ? ? ? ? <tr>

? ? ? ? ? ? <td width="506">

? ? ? ? ? ? <p align="center">result+[url removed, login to view]</td>

? ? ? ? ? </tr>

? ? ? ? ? <tr>

? ? ? ? ? ? <td width="506">

? ? ? ? ? ? <p align="center">The center column will display&nbsp;

? ? ? ? ? ? the descriptions of up to 30 results of the search. Each

? ? ? ? ? ? resulting line will alternate background between black

? ? ? ? ? ? and charcoal.</td>

? ? ? ? ? </tr>

? ? ? ? ? <tr>

? ? ? ? ? ? <td colspan="2">

? ? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? </tr>

? ? ? ? ? <tr>

? ? ? ? ? ? <td colspan="2">

? ? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? </tr>

? ? ? ? </table>

? ? ? </div>

? ? ? </td>

? ? ? <td>[url removed, login to view]</td>

? ? </tr>

? ? <tr>

? ? ? <td>[url removed, login to view]</td>

? ? ? <td>

? ? ? <p align="center">[url removed, login to view]</td>

? ? ? <td>[url removed, login to view]</td>

? ? </tr>

? </table>

</div>

<p align="center">The gallery page</p>

<div align="center">

? <table border="1" width="800" cellspacing="0" cellpadding="0">

? ? <tr>

? ? ? <td>[url removed, login to view]</td>

? ? ? <td>

? ? ? <p align="center">[url removed, login to view]</td>

? ? ? <td>[url removed, login to view]</td>

? ? </tr>

? ? <tr>

? ? ? <td>[url removed, login to view]</td>

? ? ? <td>

? ? ? <div align="center">

? ? ? ? <table border="1" width="750" cellspacing="0" cellpadding="0">

? ? ? ? ? <tr>

? ? ? ? ? ? <td>

? ? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? ? <td>

? ? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? </tr>

? ? ? ? </table>

? ? ? </div>

? ? ? <div align="center">

? ? ? ? <table border="1" width="750" cellspacing="0" cellpadding="0">

? ? ? ? ? <tr>

? ? ? ? ? ? <td colspan="2">

? ? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? </tr>

? ? ? ? ? <tr>

? ? ? ? ? ? <td colspan="2">

? ? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? </tr>

? ? ? ? ? <tr>

? ? ? ? ? ? <td width="506">

? ? ? ? ? ? <table border="1" width="100%" cellspacing="0" cellpadding="0">

? ? ? ? ? ? ? <tr>

? ? ? ? ? ? ? ? <td align="center" colspan="3">This cell will

? ? ? ? ? ? ? ? return short description2 that links to my

? ? ? ? ? ? ? ? sponsor, <br>

? ? ? ? ? ? ? ? clicks on this link will be compiled</td>

? ? ? ? ? ? ? </tr>

? ? ? ? ? ? ? <tr>

? ? ? ? ? ? ? ? <td align="center">[url removed, login to view]</td>

? ? ? ? ? ? ? ? <td align="center">[url removed, login to view]</td>

? ? ? ? ? ? ? ? <td align="center">[url removed, login to view]</td>

? ? ? ? ? ? ? </tr>

? ? ? ? ? ? ? <tr>

? ? ? ? ? ? ? ? <td align="center">[url removed, login to view]</td>

? ? ? ? ? ? ? ? <td align="center">[url removed, login to view]</td>

? ? ? ? ? ? ? ? <td align="center">[url removed, login to view]</td>

? ? ? ? ? ? ? </tr>

? ? ? ? ? ? ? <tr>

? ? ? ? ? ? ? ? <td align="center">[url removed, login to view]</td>

? ? ? ? ? ? ? ? <td align="center">[url removed, login to view]</td>

? ? ? ? ? ? ? ? <td align="center">[url removed, login to view]</td>

? ? ? ? ? ? ? </tr>

? ? ? ? ? ? ? <tr>

? ? ? ? ? ? ? ? <td align="center">[url removed, login to view]</td>

? ? ? ? ? ? ? ? <td align="center">[url removed, login to view]</td>

? ? ? ? ? ? ? ? <td align="center">[url removed, login to view]</td>

? ? ? ? ? ? ? </tr>

? ? ? ? ? ? </table>

? ? ? ? ? ? </td>

? ? ? ? ? ? <td width="238">

? ? ? ? ? ? <p align="center">[url removed, login to view]<br>

? ? ? ? ? ? this cell will have one box for search term and one

? ? ? ? ? ? button for GO<br>

? ? ? ? ? ? -----------------------<br>

? ? ? ? ? ? [url removed, login to view]<br>

? ? ? ? ? ? [url removed, login to view]<br>

? ? ? ? ? ? [url removed, login to view]<br>

? ? ? ? ? ? [url removed, login to view]<br>

? ? ? ? ? ? [url removed, login to view]<br>

? ? ? ? ? ? [url removed, login to view]<br>

? ? ? ? ? ? <br>

? ? ? ? ? ? the ads will be pulled out of a database, they will be

? ? ? ? ? ? relevant to the keywords attached to &quot;short

? ? ? ? ? ? description 1&quot;<br>

? ? ? ? ? ? Background will be one color</td>

? ? ? ? ? </tr>

? ? ? ? ? <tr>

? ? ? ? ? ? <td colspan="2">

? ? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? </tr>

? ? ? ? ? <tr>

? ? ? ? ? ? <td colspan="2">

? ? ? ? ? ? <p align="center">[url removed, login to view]</td>

? ? ? ? ? </tr>

? ? ? ? </table>

? ? ? </div>

? ? ? </td>

? ? ? <td>[url removed, login to view]</td>

? ? </tr>

? ? <tr>

? ? ? <td>[url removed, login to view]</td>

? ? ? <td>

? ? ? <p align="center">[url removed, login to view]</td>

? ? ? <td>[url removed, login to view]</td>

? ? </tr>

? </table>

</div>

CSS Inginerie JavaScript MySQL PHP Gestionarea proiectului Arhitectură software Testare software Web Hosting Administrare site-uri web Testare site-uri web

ID Proiect: #3157015

Detalii despre proiect

12 propuneri Proiect la distanță Activ Aug 25, 2008

Acordat lui:

tiagobs

See private message.

%selectedBids___i_sum_sub_7%%project_currencyDetails_sign_sub_8% USD în 60 zile
(88 Recenzii)
6.0

12 freelanceri plasează o ofertă medie de 364$ pentru proiect

yubbsoftware

See private message.

$233.75 USD în 60 zile
(113 recenzii)
6.4
egenvw

See private message.

$212.5 USD în 60 zile
(17 recenzii)
4.5
rajkumar18

See private message.

$340 USD în 60 zile
(12 recenzii)
3.5
nepaleser

See private message.

$102 USD în 60 zile
(8 recenzii)
2.6
wisionit

See private message.

$255 USD în 60 zile
(3 recenzii)
2.2
OsamaCS

See private message.

$425 USD în 60 zile
(5 recenzii)
2.0
thecloudkernel

See private message.

$1870 USD în 60 zile
(2 recenzii)
0.9
madhuanandvw

See private message.

$212.5 USD în 60 zile
(0 recenzii)
0.0
divnesan

See private message.

$212.5 USD în 60 zile
(4 recenzii)
0.0
Softwareboy

See private message.

$127.5 USD în 60 zile
(0 recenzii)
0.0
micutzucdsvw

See private message.

$85 USD în 60 zile
(0 recenzii)
0.0