PHP School Assignment? Project Due Tomorrow? Chat LIVE With A Programming Expert!

Programming Help

Web Development



What's Here?

  • Members: 300,333
  • Replies: 825,651
  • Topics: 137,391
  • Snippets: 4,417
  • Tutorials: 1,147
  • Total Online: 1,687
  • Members: 113
  • Guests: 1,574

Welcome to Dream.In.Code
Become a PHP Expert!

Join 300,333 PHP Programmers for FREE! Get instant access to thousands of PHP experts, tutorials, code snippets, and more! There are 1,687 people online right now. Registration is fast and FREE... Join Now!




Adding Data to datbase and taking it from datbase

 

Adding Data to datbase and taking it from datbase
nick1200

27 May, 2009 - 01:56 PM
Post #1

D.I.C Addict
****

Joined: 21 Mar, 2009
Posts: 551



Thanked: 6 times
My Contributions
the title mite make this sound funny but ive bene having alook at this bit of code for a few hours

i have made a sell pokemon page and buy pokemon page


i have got the buy pokemon page pulling data from the datbase


but the sell page got to add data to the datbase i have enter data by hand and the buy page shows it so ive done a bit rite lol


i wanna make a sell page so the suer picks a slot 1 -6 and it takes what ever is in that slot

and adds it to the datbase and shows it on the buy page


so the user sells the pokemon and it end s up on the buy page

but i cant seem to get it from the user to the datbase lol

sellpokemon.php

CODE


<table border="0"
                cellpadding="0" cellspacing="0" width="107%">
                  <td width="100%"><tr>
                    <td width="54" valign="top"><p align="center"><br>
                    <br>
                    </td>
                    <td width="326" valign="top"><p>&nbsp;</p>
                    
                    <form name="myform" id="myform" action="" method="post">
        <p>What slot do you want to Sell?
            <select name="pokeSLOT" id="pokeSLOT" style="width:50px;">
                <option value=""></option>
                <?php for ($x=1;$x<7;$x++) { echo '<option value="'.$x.'">'.$x.'</option>'; } ?>
            </select></p>
            
                      <p>&nbsp;</p></td>
                  </tr>
                     <td><p align="center">Price You Would Like For The Pokemon  </p>
                         <p align="center">
                           <input type="int" name="cost" maxlength="30">
                               </p>
                         <p align="center">
                           <input name="submit" type="submit" value="Sell" />
                         </p>
                         <p align="left">&nbsp; </p></td>
                    <p>&nbsp;</p>
                    <p>&nbsp;</p>
                  
                </table>




BuyPokemon

CODE


<table border="0"
                cellpadding="0" cellspacing="0" width="107%">
                  <td width="100%"><tr>
                    <td width="54" valign="top"><p align="center"><br>
                    <br>
                    </td>
                    <td width="326" valign="top"><p>&nbsp;</p>
                    
                    <form name="myform" id="myform" action="" method="post">
        <p>What slot do you want to Buy For?
            <select name="pokeSLOT" id="pokeSLOT" style="width:50px;">
                <option value=""></option>
                <?php for ($x=1;$x<7;$x++) { echo '<option value="'.$x.'">'.$x.'</option>'; } ?>
            </select></p>
            
            
    
                      <p>&nbsp;</p></td>
                  </tr>
                    <p>&nbsp;</p>
                    <p>&nbsp;</p>
                    <p>&nbsp;</p>
                            <?php    
    $sql = "SELECT username, pokemon, cost, pokePIC FROM Poke_sell
             ORDER BY cost ASC LIMIT 190";
    $res = mysql_query($sql) or die(mysql_error());
    
    echo '<tr>';        
        $third = 1;
        
        while ($v = mysql_fetch_array($res)) {
            echo '
            <th scope="row"><p><img src="pokemon/'.$v[pokePIC].'" width="60" height="60"></p>
                <p>&pound;'.$v[cost].'</p>
                <p>'.$v[pokemon].'</p>
                <p>'.$v[username].'</p>
            <input type="button" name="Buy_Me" value="Buy Me"
                onclick="Buy_Pokemon(\''.$v[username].'\',\''.$v[pokemon].'\',\''.$v[cost].'\');"/>
            </th>';
            if (($third%3) == 0) {
                echo '</tr>';
            }
            $third++;
        }
                
    echo '</tr>';
    
?>
<script language="JavaScript" type="text/javascript">
    function Buy_Pokemon(VAR, NAME, PRICE) {
      SelectedBox = document.getElementById('pokeSLOT').value
      UserMoney = <?php echo $pokemon->money; ?>
        
        if(PRICE > UserMoney) {
            alert("You cannot afford this pokemon, please choose another or come back at a later time.");
            return;
        }        
        if(SelectedBox == ''){
            alert("YOU MUST CHOOSE A SLOT TO BUY FOR!");
            return;
        }
        ConfirmBuy = confirm("You are about to purchase "+NAME+" for slot# "+SelectedBox+", continue?");
        
        if (ConfirmBuy) {
            document.getElementById("pokemon_buy").value = VAR;
            document.myform.submit();
        } else {
            return;
        }
    }
</script>
  
                </table>





in the datbase i have made a new table poke_sell so everything every 1 sells goes there i have added coullums

username
pokemon
Cost
time_stamp
pokePIC

im only filling in the pokemon and cost with that bit of cod ( sellpokemon)

when i need to fill in the rest i guess ?

This post has been edited by nick1200: 27 May, 2009 - 01:59 PM

User is offlineProfile CardPM
+Quote Post


CTphpnwb

RE: Adding Data To Datbase And Taking It From Datbase

27 May, 2009 - 02:41 PM
Post #2

D.I.C Lover
Group Icon

Joined: 8 Aug, 2008
Posts: 2,065



Thanked: 151 times
Dream Kudos: 100
Expert In: PHP

My Contributions
Have you noticed that the more code you write, the harder it becomes to keep track of everything? That's why we have functions. They help us reduce the complexity, but even with them, things still get convoluted, which is why we have OOP. Start thinking about using an object:
CODE
<?php
class general {
    var    $id;
    var $keyname= "id";
    var    $row;
    public    $table = array("newtable","Another_table","A3rdTable","options","parts");
    var    $dblink;
    var    $servername='localhost';
    var    $dbusername='root';
    var    $dbpassword='root';
    var    $dbname='newtest';

    function __construct() {
        $this->dblink = mysql_connect ($this->servername, $this->dbusername,$this->dbpassword) or die('CONNECTION ERROR: Could not connect to MySQL');
        mysql_select_db($this->dbname,$this->dblink) or  ('Could not open database '.mysql_error());
    }
        
    function read_table($tablenum) {
        $query = "SELECT * FROM ".$this->table[$tablenum]." where ".$this->keyname." = '".$this->id."'";
        $dbdata = mysql_query($query,$this->dblink) or die('Error reading from '.$this->table[$tablenum]." ".mysql_error());
        $this->row = mysql_fetch_array($dbdata);
    }
    
    function update_table($tablenum) {
        $query = "update ".$this->table[$tablenum]." set ";
        foreach($this->row as $key => $value) {
            if(!is_numeric($key) && $key != "id") {
                $query .= $key." = '".$value."', ";
            }
        }
        $query = substr($query,0,-2)." where ".$this->keyname." ='".$this->id."'";
        mysql_query($query,$this->dblink) or die("Error updating ".$this->table[$tablenum]." ".mysql_error());
    }

    function addrecord($tablenum) {
        $query = "insert into ".$this->table[$tablenum]." (";
        $end_query = ") values (";
        foreach($this->row as $key => $value) {
            if(!is_numeric($key) && $key != "id") {
                $query .= $key.", ";
                $end_query .= "'".$value."', ";
                }
            }
        $end_query = substr($end_query,0,-2).")";    
        $query = substr($query,0,-2).$end_query;
        mysql_query($query,$this->dblink) or die("Error updating ".$this->table[$tablenum]." ".mysql_error());
    }

    function display() {
        $line = "";
        foreach($this->row as $key => $value) {
            if(!is_numeric($key) && $key != "id") {
                $line .= $value." -- ";
                }
            }
            echo $line."<br>";
        }

    function droprecord($tablenum,$dropid) {
        $query = "Delete from ".$this->table[$tablenum]." where ".$this->keyname." = '".$dropid."'";
        echo $query;
        mysql_query($query,$this->dblink) or die("Error updating ".$this->table[$tablenum]." ".mysql_error());
        }

}    

?>
User is online!Profile CardPM
+Quote Post

nick1200

RE: Adding Data To Datbase And Taking It From Datbase

27 May, 2009 - 02:46 PM
Post #3

D.I.C Addict
****

Joined: 21 Mar, 2009
Posts: 551



Thanked: 6 times
My Contributions
QUOTE(CTphpnwb @ 27 May, 2009 - 02:41 PM) *

Have you noticed that the more code you write, the harder it becomes to keep track of everything? That's why we have functions. They help us reduce the complexity, but even with them, things still get convoluted, which is why we have OOP. Start thinking about using an object:
CODE
<?php
class general {
    var    $id;
    var $keyname= "id";
    var    $row;
    public    $table = array("newtable","Another_table","A3rdTable","options","parts");
    var    $dblink;
    var    $servername='localhost';
    var    $dbusername='root';
    var    $dbpassword='root';
    var    $dbname='newtest';

    function __construct() {
        $this->dblink = mysql_connect ($this->servername, $this->dbusername,$this->dbpassword) or die('CONNECTION ERROR: Could not connect to MySQL');
        mysql_select_db($this->dbname,$this->dblink) or  ('Could not open database '.mysql_error());
    }
        
    function read_table($tablenum) {
        $query = "SELECT * FROM ".$this->table[$tablenum]." where ".$this->keyname." = '".$this->id."'";
        $dbdata = mysql_query($query,$this->dblink) or die('Error reading from '.$this->table[$tablenum]." ".mysql_error());
        $this->row = mysql_fetch_array($dbdata);
    }
    
    function update_table($tablenum) {
        $query = "update ".$this->table[$tablenum]." set ";
        foreach($this->row as $key => $value) {
            if(!is_numeric($key) && $key != "id") {
                $query .= $key." = '".$value."', ";
            }
        }
        $query = substr($query,0,-2)." where ".$this->keyname." ='".$this->id."'";
        mysql_query($query,$this->dblink) or die("Error updating ".$this->table[$tablenum]." ".mysql_error());
    }

    function addrecord($tablenum) {
        $query = "insert into ".$this->table[$tablenum]." (";
        $end_query = ") values (";
        foreach($this->row as $key => $value) {
            if(!is_numeric($key) && $key != "id") {
                $query .= $key.", ";
                $end_query .= "'".$value."', ";
                }
            }
        $end_query = substr($end_query,0,-2).")";    
        $query = substr($query,0,-2).$end_query;
        mysql_query($query,$this->dblink) or die("Error updating ".$this->table[$tablenum]." ".mysql_error());
    }

    function display() {
        $line = "";
        foreach($this->row as $key => $value) {
            if(!is_numeric($key) && $key != "id") {
                $line .= $value." -- ";
                }
            }
            echo $line."<br>";
        }

    function droprecord($tablenum,$dropid) {
        $query = "Delete from ".$this->table[$tablenum]." where ".$this->keyname." = '".$dropid."'";
        echo $query;
        mysql_query($query,$this->dblink) or die("Error updating ".$this->table[$tablenum]." ".mysql_error());
        }

}    

?>





that seems hard if u dont mind me saying lol
User is offlineProfile CardPM
+Quote Post

CTphpnwb

RE: Adding Data To Datbase And Taking It From Datbase

27 May, 2009 - 02:53 PM
Post #4

D.I.C Lover
Group Icon

Joined: 8 Aug, 2008
Posts: 2,065



Thanked: 151 times
Dream Kudos: 100
Expert In: PHP

My Contributions
It isn't. It's just scary, until you see what's going on. The class is made up of variables and functions. Debugging is easy because you can almost always easily tell which function isn't working right, so you've got a very small amount of code to deal with.

Here's a much simpler class, along with a couple of instances of it. You should be able to make sense of it easily. When you do, reread my general class above to see how it can read/write to a database.

CODE
<?php

class box {
    var $length;
    var $width;
    var $height;
    var $volume;
    
    function box_volume() {
        $this->volume = $this->length * $this->width * $this->height;    
    }
}

$bigbox = new box;
$bigbox->length = 20;
$bigbox->width = 30;
$bigbox->height = 40;
$bigbox->box_volume();
echo "Bigbox volume is ".$bigbox->volume."<br>";

$smallbox = new box;
$smallbox->length = 5;
$smallbox->width = 3;
$smallbox->height = 4;
$smallbox->box_volume();
echo "Smallbox volume is ".$smallbox->volume."<br>";

?>

User is online!Profile CardPM
+Quote Post

nick1200

RE: Adding Data To Datbase And Taking It From Datbase

27 May, 2009 - 02:56 PM
Post #5

D.I.C Addict
****

Joined: 21 Mar, 2009
Posts: 551



Thanked: 6 times
My Contributions
QUOTE(CTphpnwb @ 27 May, 2009 - 02:53 PM) *

It isn't. It's just scary, until you see what's going on. The class is made up of variables and functions. Debugging is easy because you can almost always easily tell which function isn't working right, so you've got a very small amount of code to deal with.

Here's a much simpler class, along with a couple of instances of it. You should be able to make sense of it easily. When you do, reread my general class above to see how it can read/write to a database.

CODE
<?php

class box {
    var $length;
    var $width;
    var $height;
    var $volume;
    
    function box_volume() {
        $this->volume = $this->length * $this->width * $this->height;    
    }
}

$bigbox = new box;
$bigbox->length = 20;
$bigbox->width = 30;
$bigbox->height = 40;
$bigbox->box_volume();
echo "Bigbox volume is ".$bigbox->volume."<br>";

$smallbox = new box;
$smallbox->length = 5;
$smallbox->width = 3;
$smallbox->height = 4;
$smallbox->box_volume();
echo "Smallbox volume is ".$smallbox->volume."<br>";

?>





ya i get what var does stores info so u dont have to keep typeing it lol

but the first code u made / sent looks hard id have to split the code up and put some on the sell age and some on the buy page

bit hard for a begginger lol

This post has been edited by nick1200: 27 May, 2009 - 03:02 PM
User is offlineProfile CardPM
+Quote Post

ShaneK

RE: Adding Data To Datbase And Taking It From Datbase

27 May, 2009 - 03:04 PM
Post #6

require_once("brain.php"); //Fatal error :/
Group Icon

Joined: 10 May, 2009
Posts: 699



Thanked: 47 times
Dream Kudos: 75
Expert In: PHP, MySQL

My Contributions
Once you get the hang of OOP you'll realize it makes it 100x easier to keep track of and modify your code.

Things like web based games and such make OOP a necessity, I highly suggest you look into actually using it.

Yours,
shane~
User is online!Profile CardPM
+Quote Post

CTphpnwb

RE: Adding Data To Datbase And Taking It From Datbase

27 May, 2009 - 03:07 PM
Post #7

D.I.C Lover
Group Icon

Joined: 8 Aug, 2008
Posts: 2,065



Thanked: 151 times
Dream Kudos: 100
Expert In: PHP

My Contributions
No, it's all one class so you'd want to keep it together. You probably don't need all the functions it contains, but if you don't use them, they're just text, so no harm done.

The functions get a little more complicated because of the database. Note that the data is all stored in the class variable: $row, which is an array. ($this->row tells the object that it's dealing with one of its own variables and not a local function variable.)

By the way, the class by itself won't do anything. You need to call it, or generate an instance of it, which is what an object is.
User is online!Profile CardPM
+Quote Post

nick1200

RE: Adding Data To Datbase And Taking It From Datbase

27 May, 2009 - 03:12 PM
Post #8

D.I.C Addict
****

Joined: 21 Mar, 2009
Posts: 551



Thanked: 6 times
My Contributions
QUOTE(ShaneK @ 27 May, 2009 - 03:04 PM) *

Once you get the hang of OOP you'll realize it makes it 100x easier to keep track of and modify your code.

Things like web based games and such make OOP a necessity, I highly suggest you look into actually using it.

Yours,
shane~


ya i have opp or varables in my site all ready lol to store peeps usernames and there pokemon lvl

but i hate using them lol

maybe this is to big to do lol




QUOTE(CTphpnwb @ 27 May, 2009 - 03:07 PM) *

No, it's all one class so you'd want to keep it together. You probably don't need all the functions it contains, but if you don't use them, they're just text, so no harm done.

The functions get a little more complicated because of the database. Note that the data is all stored in the class variable: $row, which is an array. ($this->row tells the object that it's dealing with one of its own variables and not a local function variable.)

By the way, the class by itself won't do anything. You need to call it, or generate an instance of it, which is what an object is.



well i think id need a var to get the info from the database for 1 pokemon

cus the user has 6 slots and they got to pick what slot they wanna sell

so i have added a drop don menu on that code on the sell page

so then i need to make a var to get the info for the slot they picked then id have to store that info for that slot and add it to a diffrent table poke_sell so its going from user_pokemon to poke_sell then when its added to poke sell it has to dealte from user_pokemon

then the buy page had to view everything in poke_sell and if somthing is bought it has to give the money to the user who sold it ( i have a username collum )

pretty hard wub.gif
User is offlineProfile CardPM
+Quote Post

CTphpnwb

RE: Adding Data To Datbase And Taking It From Datbase

27 May, 2009 - 03:30 PM
Post #9

D.I.C Lover
Group Icon

Joined: 8 Aug, 2008
Posts: 2,065



Thanked: 151 times
Dream Kudos: 100
Expert In: PHP

My Contributions
I'm assuming that those variables would be stored in the database, in which case they'd all be part of the $row array for that object:

$this->row['slot'] would be the slot chosen by the user: $this->row['userid']

Even your drop down menu could be a function within the class that uses these values from the array!


Edit: Not hard at all, and when you need to change something later, it will be easy!

This post has been edited by CTphpnwb: 27 May, 2009 - 03:31 PM
User is online!Profile CardPM
+Quote Post

nick1200

RE: Adding Data To Datbase And Taking It From Datbase

27 May, 2009 - 03:31 PM
Post #10

D.I.C Addict
****

Joined: 21 Mar, 2009
Posts: 551



Thanked: 6 times
My Contributions


i better look it up lol
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic

Time is now: 11/7/09 04:50PM
Invision Power Board v2.1.7 © 2009  IPS, Inc.
Licensed to: MediaGroup1

Live PHP Help!

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter Fan Us On Facebook

PHP Tutorials

Reference Sheets

PHP Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month