0

hi!!m doing my college project on "online digital photo printing"where a customer can upload,edit and order photos at home
the problem i am facing is:-i want to provide my users a "price list of photo type(passport size=rs XXX,stampsize=rs YYY)"
and these prices should be entered by "admin"in a form..that gets updated back to the user as static html page...prices should get apdated in a database....i am using php mysql....what i have to do...please lemme kno..will be waiting..thank you.

3
Contributors
8
Replies
39
Views
3 Years
Discussion Span
Last Post by diafol
-1

What is it you are looking for though. Do you have a specific question? What have you tried already?

0

I'm assuming that you have to code this from scratch and not use a cms or similar like coppermine (http://coppermine-gallery.net/).

Are users allowed to set their own prices (through an admin page) or are prices set by the admin him/herself (i.e. "the site"/you)?

If you set the prices then you could have a related table...

prices

price_id
photo_type
price_dollars
price_from (date from which price becomes active)

That way all photos are priced automatically. That's just an idea off the top of my head though. I think only few, if any, gallery/image sellers have a single set price for each type of photo. You could make it more flexible by adding "price banding", e.g. A, B, C, D (e.g. relating to quality). Again maybe not so useful.

As effu asks - "What have you tried already" and have you got any code that you can share with us so that we may help you properly.

0

thnx for ur attention
the form i want is smewhat like:-<form>photo type(passport,stamp,poster etc as label["text inputtype"....input box...](for entering respective price of photos)...and two buttons(one for inserting prices..and one for updating the entered prices....
i can now insert successfuly cant update..here is my code..please check and help me out...

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 
Transitional//EN" 

"http://www.w3.org/TR/html4/loose.dtd">

<html>
<style type="text/css">


    header, section, footer, aside, nav, article, figure, figcaption {


                                                                    display: block;}


    body {


            color: #666666;
            background-color: #f9f8f6;

            background-position: center;
            font-family: Georgia, times, serif;
            line-height: 1.4em;
            margin: 0px;}


.wrapper {
            width:1111px;
            margin: 20px auto 20px auto;
            border: 2px solid skyblue;
            background-color: #ffffff;}


nav, footer {
            clear: both;
            color: #ffffff;
            background-color: skyblue;
            height: 30px;}
nav ul {
            margin: 0px;
            padding: 5px 0px 5px 30px;}
nav li {
            display: inline;
            margin-right: 40px;}
nav li a {

            color: Green;}
nav li a:hover, nav li a.current {
                                    color: orange;}
section.courses {
            float: left;
            width: 659px;
            border-right: 1px solid #eeeeee;}
article {
            clear: both;
            overflow: auto;
            width: 100%;}
hgroup {
            margin-top:40px;}
figure {
            float: left;
            width: 290px;
            height: 220px;
            padding: 5px;
            margin: 20px;
            border: 1px solid #eeeeee;}


figcaption {    color: red;
                font-size: 100%;
                text-align: left;}
aside {
                width: 230px;
                float: left;
                padding: 0px 0px 0px 20px;}
aside section a {
                display: block;
                padding: 10px;
                border-bottom: 1px solid #eeeeee;}
aside section a:hover {
                color: blue;
                background-color: #efefef;}
a {
                color: #de6581;
                text-decoration: none;}
h1, h2, h3 {    
                font-weight: normal;}
h2 {            color: Orange;

                padding: 0px;}
h3 {
                margin: 0px 0px 10px 0px;
                color: #de6581;}


aside h2 {
                padding: 30px 0px 10px 0px;
                color: red;}
footer {
                font-size: 80%;
                padding: 7px 0px 0px 20px;}

p {             color: teal;
                font-size: 100%;
                }

footer{         text-align: center;     
                color: black;
                font-size: 15px;}


b{text-align: center;}

    input#submit {
                            color: brown;
                            text-shadow: 2px 1px 1px #ffffff;
                            border-bottom: 5px solid #b2b2b2;
                            background-color: #b9e4e3;
                            background: -webkit-gradient(linear, left top,
                            left bottom, from(#beeae9), to(#a8cfce));
                            background:
                            -moz-linear-gradient(top, #beeae9, #a8cfce);
                            background:
                            -o-linear-gradient(top, #beeae9, #a8cfce);
                            background:
                            -ms-linear-gradient(top, #beeae9, #a8cfce);}
                            input#submit:hover {
                            color: green;
                            border: 2px solid orange;
                            border-top: 2px solid #b2b2b2;
                            background-color: #a0dbc4;
                            background: -webkit-gradient(linear, left top,
                            left bottom, from(#a8cfce), to(#beeae9));
                            background:
                            -moz-linear-gradient(top, #a8cfce, #beeae9);
                            background:
                            -o-linear-gradient(top, #a8cfce, #beeae9);
                            background:
                            -ms-linear-gradient(top, #a8cfce, #beeae9);}
input#text {
                            color: brown;
                            text-shadow: 2px 1px 1px #ffffff;
                            border: 10px solid #b2b2b2;
                            background-color: #b9e4e3;
                            background: -webkit-gradient(linear, left top,
                            left bottom, from(#beeae9), to(#a8cfce));
                            background:
                            -moz-linear-gradient(top, #beeae9, #a8cfce);
                            background:
                            -o-linear-gradient(top, #beeae9, #a8cfce);
                            background:
                            -ms-linear-gradient(top, #beeae9, #a8cfce);}
input#text:hover {
                            color: green;
                            border: 2px solid orange;
                            border-top: 2px solid #b2b2b2;
                            background-color: #a0dbc4;
                            background: -webkit-gradient(linear, left top,
                            left bottom, from(#a8cfce), to(#beeae9));
                            background:
                            -moz-linear-gradient(top, #a8cfce, #beeae9);
                            background:
                            -o-linear-gradient(top, #a8cfce, #beeae9);
                            background:
                            -ms-linear-gradient(top, #a8cfce, #beeae9);}

div {

                            margin: 3px;
                            padding-bottom: 20px;
                            width: 260px;}
.title {
                            float: left;
                            width: 100px;
                            text-align: left;
                            padding-right: 0px;}

.submit {
                            text-align: right;}
label  {                    color: blue;}

h1 {                        color: Green;
                            font-family: "Monotype Corsiva";
                            font-size: 80px;}

h5{                         color: green;
                            font-size: 30px;
                            text-position: bottom center;}

fieldset {                  border: 2px solid teal;}

legend{                     color: red;
                                        }

aside section.register{     
                            width: 100px;
                            }

    img:hover {border: 2px solid skyblue;
               }
    table{ color: black;}
</style>


<head>

<title>Insert/Update Prices</title>

</head>


<h1 align="center">Insert Items or update prices </h2>
<body>

<table border="1" bgcolor="#00FF00" width="1000" align="center"  >

  <tr>

    <td align="center">Insert/Update Prices</td>

  </tr>

  <tr>

    <td>

      <table>

        <form method="post" action="input.php">

        <tr>

          <td>Photo-Type</td>

          <td><input type="text" name="type" size="20">
          </td>

        </tr>

        <tr>

          <td>Price</td>

          <td><input type="text" name="price" size="10">

          </td>

        </tr>

        <tr>

          <td></td>

          <td align="right"><input type="submit"

          name="submit" value="Sent"></td>
           <td align="right"><input type="submit"

          name="submit1" value="update"></td>

        </tr>

        </table>

      </td>

    </tr>

</table>

</body>
0

Well, it started getting interesting at line 230. Why did you include all that css? No need - just gets in the way.
Also, do not use tables for layout.
You have not 'closed the form with a </form> tag as far as I can see.

You have 2 fields: photo-type and price.

I don't see how this can work. UNLESS all photos of a certain type have a specific price.

What's the php code in the input.php page?

0
    <?php

//the example of inserting data with variable from HTML form

//input.php

mysql_connect("localhost","root","");//database connection

mysql_select_db("rate chart");

 $type='type';
 $price='price';

//inserting data order

$order = "INSERT INTO prices

            (type,price)

            VALUES

            ('$_POST[$type]',

            '$_POST[$price]')";



//declare in the order variable

$result = mysql_query($order);  //order executes

if($result){

    echo("<br>Input data is succeed");

} else{

    echo("<br>Input data is fail");

}

echo"<br>";
echo "$_POST[$type]";
echo "<br>";
echo "$_POST[$price]";



?>
0
<body>
                <div class="wrapper"><h1 align="center">Now Choose Your Own Photo type!!</h1>
    <fieldset align="center"><legend>PRICE LIST FOR PHOTO GRAPHS</LEGEND>



    <?php

//the example of inserting data with variable from HTML form

//input.php

mysql_connect("localhost","root","");//database connection

mysql_select_db("rate chart");

 $type='type';
 $price='price';

//inserting data order

$order = "select * from prices";



//declare in the order variable

$result = mysql_query($order);  //order executes

while($row = mysql_fetch_array($result)) {


      // Write the value of the column FirstName (which is now in the array $row)

      echo $row['type'] ."<br/>";
      echo "Rs".$row['price']."/"."pc" . "<br/>";

      }

    // Close the database connection
    mysql_close();


?></fieldset></div></html>
0

@diafol...bro thnx fo ur feedback..just check out ma coding...i now can successfully insert prices and phototypes...but i want to update it as well with the help of a update button on the same form as mentioned above....i wud apreciate if u just edit ma code...n make it worth updating...(waiting for ur rply)

0

To create a 2-in-1 form you'll probably need to have some sort of url identifier to decide on update or insert.

e.g. www.example.com/gallery/{user}/{image_id}/update/ [for update] or www.example.com/gallery/{user}/ [for insert]

//default values for form (insert)
$field1 = '';
$field2 = '';
$field3 = '';
$field4 = '';
$field5 = '';
$action = 'insert';

You can use mod_rewriting to get the 'GET' value
if(isset($_GET['action']) && $_GET['action'] == 'update')
{
    //get image data from image_id in url from $_GET['image_id']
    $field1 = '...from DB...';
    $field2 = '...from DB...';
    $field3 = '...from DB...';
    $field4 = '...from DB...';
    $field5 = '...from DB...';
    $action = 'update';
}

The HTML:

<form ...>
    <input name="..." value="<?php echo $field1;?>" />
    <input name="..." value="<?php echo $field2;?>" />
    <input name="..." value="<?php echo $field3;?>" />
    <input name="..." value="<?php echo $field4;?>" />
    <input name="..." value="<?php echo $field5;?>" />
    <input type="hidden" name="..." value="<?php echo $action;?>" />
    <input name="..." type="submit" value="<?php echo strtoupper($action);?>" />
</form>

Top of my head stuff - not thoroughly thought out yet.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.