Sedang Disiapkan

Gmed PHP Script

We need to modify the PHP PRINT function below as follow:

1. To print only 10 lines per page.

2. Provide NEXT and PREV buttons to view the next 10 lines or the

previous 10 lines.

3. The first field on each record, RECKEY int(5), to generate a link

to [url removed, login to view]$RECKEY and display the link

text VerMas in the first column instead of the $RECKEY.

4. Provide a simple script for [url removed, login to view] that grabs the variable $RECKEY

from the URL to retrieve the corresponding record and provide a form to

display/update the following record fields: NAMEKEY. NAMELN2, ADDRLN1,

ADDRLN2,CTYESZIP, PHONENO.

When an UPDATE button is pressed to update the record, request a password

to allow the update. Check the password with "cpc123" to validate it. If

the password is correct update the record if not display "Invalid Password"

and a "return to previous page button". After update display "Record Updated"

and a "return to previous page button".

*************************Query and Print PHP Routine************************

// Perform SQL query

$CTY1 = $_POST['CITY'];

if ($CTY1==00) {

$query = "SELECT RECKEY, CITYKEY, SPECKEY, NAMEKEY, PHONENO FROM Providers

WHERE (SPECCDE = 48 or SPECCDE = 49) ORDER BY NAMEKEY";

} else {

$query = "SELECT RECKEY, CITYKEY, SPECKEY, NAMEKEY, PHONENO FROM Providers

WHERE (SPECCDE = 48 or SPECCDE = 49) AND CITYCDE = $CTY1 ORDER BY NAMEKEY";

}

$result = mysql_query($query) or die('Query failed: ' . mysql_error());

// Print results

echo "<center>

<table width=760 cellpadding=2 cellspacing=0 border=1 align=center>\n";

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {

echo "\t<tr>\n";

foreach ($line as $col_value) {

$recvar = $_RECKEY;

$reclink = 'href="[url removed, login to view]$recvar"';

echo $recvar;

echo "\t\t<td><font face=arial size=2 color=white>$col_value</td>\n";

}

echo "\t</tr>\n";

}

echo "</table>\n";

// Release results

mysql_free_result($result);

// Close the connection

mysql_close($link);

****************************** end of PHP routine *****************************

Kemahiran:

Lihat lebih lanjut: gmed script, php id, perform line, int size, gmed, sql script , rec, prev, modify previous script, int, die line, sql update text, sql update field text, php connection, php color, php connection select, sql retrieve table, php modify form, php font color, function check php, php script sql, retrieve url, invalid script, script function, update text sql

Tentang Majikan:
( 6 ulasan ) Vega Alta, Puerto Rico

ID Projek: #389041

Dianugerahkan kepada:

DumkaSIM

Hello. I offer you configurable object oriented solution for your needs. Can be done as soon as needed. My experience: over 5 years in PHP/MySQL programming. I placed this bid to try the freelance.com , task is simple. Lagi

$50 USD dalam sehari
(2 Ulasan)
2.0

9 pekerja bebas membida secara purata $79 untuk pekerjaan ini

Maven

will love to work on it. please accept so that we can start.

$120 USD dalam sehari
(82 Ulasan)
5.8
NeoWebSoftware

I am PHP Developer. I am highly available to work on it instantly. Thank you!

$100 USD dalam 0 hari
(75 Ulasan)
3.6
wincent

easy & quick work.

$100 USD dalam sehari
(113 Ulasan)
3.7
toinnisfree

pls chk pmb

$100 USD dalam 2 hari
(719 Ulasan)
2.2
zeroneit

Dear Sir I have very interest in your project. I developed many Web site and application for 3 years. I have many skill and experience in PHP. If I work with you, I'll do my best to complete your project without Lagi

$80 USD dalam sehari
(6 Ulasan)
1.8
smartty2hotty82

we would provide you quality

$65 USD dalam sehari
(0 Ulasan)
0.0
piravin

Though im new to elance.com, im not new to php coding. With lot of experience im sure i can offer u the best professional touch at unbelievable price.

$40 USD dalam 2 hari
(0 Ulasan)
0.0
amama

just let me do it

$60 USD dalam 2 hari
(2 Ulasan)
0.0