Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › PHP and mysql database
New Posts  All Forums:Forum Nav:

PHP and mysql database

post #1 of 18
5/1/10 at 5:34pm
Thread Starter 
Ok So I made a registration type page. Now I need to pass that information from a php page into a mysql server(I have wamp set up on my computer).

How would I go about doing this. I looked at the w3 school's site and I'm not sure what I'm reading. (ignore the css)


the values I would like to pass through are "Email" and "Password". The name of the mysql database is Customers.

Code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
    <meta http-equiv="content-type" content="text/html;charset=utf-8" />
    <title>Electronics R US</title>
    <link type="text/css" href="menu.css" rel="stylesheet" />
    <script type="text/javascript" src="jquery.js"></script>
    <script type="text/javascript" src="menu.js"></script>
</head>
<body>

<style type="text/css">
* { margin:0;
    padding:0;
}
html { background:#444; }
body {
    margin:0px auto;
    width:75%;
    height:1200px;
    background:#ffffff;
    overflow:hidden;
}
div#menu {
top:50px;  
}
div#menu {
top:25px;  
}
div#copyright { display: none; }
</style>

<div id="menu">
    <ul class="menu">
        <li><a href="#" class="parent"><span>Home</span></a>
            
        </li>
<li><a href="#" class="parent"><span>TVs&Audio</span></a>
            <div><ul>
                <li><a href="#" class="parent"><span>Samsung</span></a></li>
                <li><a href="#"><span>Sony</span></a></li>
                <li><a href="#"><span>LG</span></a></li>
            </ul></div>
        </li>
<li><a href="#" class="parent"><span>Audio&Music</span></a>
            <div><ul>
                <li><a href="#" class="parent"><span>Classical</span></a></li>
                <li><a href="#"><span>Hip Hop/Rap</span></a></li>
<li><a href="#"><span>Pop</span></a></li>
                <li><a href="#"><span>R&B</span></a></li>
<li><a href="#"><span>Rock</span></a></li>
            </ul></div>
        </li>
<li><a href="#" class="parent"><span>Car&GPS</span></a>
            <div><ul>
                <li><a href="#" class="parent"><span>Garmin</span></a></li>
                <li><a href="#"><span>TomTom</span></a></li>
                <li><a href="#"><span>Megellan</span></a></li>
            </ul></div>
        </li>
<li><a href="#" class="parent"><span>Cameras</span></a>
            <div><ul>
                <li><a href="#" class="parent"><span>Sony</span></a></li>
                <li><a href="#"><span>Samsung</span></a></li>
                <li><a href="#"><span>Nikon</span></a></li>
            </ul></div>
        </li>
<li><a href="#" class="parent"><span>Computers</span></a>
            <div><ul>
                <li><a href="#" class="parent"><span>HP/Compaq</span></a></li>
                <li><a href="#"><span>Dell</span></a></li>
                <li><a href="#"><span>Gateway</span></a></li>
            </ul></div>
        </li>
<li><a href="#" class="parent"><span>Video Games</span></a>
            <div><ul>
                <li><a href="#" class="parent"><span>Playstation</span></a></li>
                <li><a href="#"><span>Xbox 360</span></a></li>
                <li><a href="#"><span>Wii</span></a></li>
            </ul></div>
        </li>
        
<li><a href="#"><span>Copmpany Info</span></a>
           
        </li>
        <li><a href="#"><span>Help</span></a></li>
        <li class="last"><a href="#"><span>Contacts</span></a></li>

            
        </li>
    </ul>
</div>
<pre>





</pre>
<h2>Website User name and Password</h2>
<hr />





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

<table border="0">
<tr>
  <td width = 50%;>Email</td>
  <td> <input type="text" name="Email"/></td>

</tr>
<tr>
  <td>Verify Email</td>
  <td><input type="text" name="VerifyEmail"/></td>

</tr>
<form name=myForm onSubmit="return validatePwd()">
<tr>
  <td>Enter Password</td>
  <td><input type=password name=password maxlength=12></td>

</tr>
<tr>
  <td>Verify Password</td>
  <td> <input type=password name=password2 maxlength=12></td>

</tr>
</form>
</table>
<hr /><pre>


</pre>
<strong>Billing Information</strong>
<hr />
This address must match the address that your monthly credit card statement or monthly bank statement is sent to.<br />If this condition is not met, your order will not be processed. To prevent unnecessary delays, <br />please verify that your billing address matches the address on your statement before ordering.</td></tr>
<table border ="0">
<tr>
  <td width = 45%;>First Name</td>
  <td><input type="text" name="FirstName"/></td>

</tr>
<tr>
  <td>Last Name</td>
  <td><input type="text" name="LastNAme"/></td>

</tr>
<tr>
  <td>Comapny Name</td>
  <td><input type="text" name="CompanyName"/></td>

</tr>
<tr>
  <td>Address</td>
  <td><input type="text" name="Address"/></td>

</tr>
<tr>
  <td>Address 2</td>
  <td><input type="text" name="Address2"/></td>

</tr>
<tr>
  <td>City</td>
  <td><input type="text" name="City"/></td>
</tr>
<tr>
  <td>State</td>
  <td><select name="SState" id="SState" tabindex="0" size="1"  ><option value="AA">AA</option><option value="AP">AP</option><option value="AE">AE</option><option value="AK" selected="selected">ALASKA</option><option value="AL">ALABAMA</option><option value="AR">ARKANSAS</option><option value="AZ">ARIZONA</option><option value="CA">CALIFORNIA</option><option value="CO">COLORADO</option><option value="CT">CONNECTICUT</option><option value="DC">DISTRICT OF COLUMBIA</option><option value="DE">DELAWARE</option><option value="FL">FL</option><option value="GA">GEORGIA</option><option value="HI">HAWAII</option><option value="IA">IOWA</option><option value="ID">IDAHO</option><option value="IL">ILLINOIS</option><option value="IN">INDIANA</option><option value="KS">KANSAS</option><option value="KY">KENTUCKY</option><option value="LA">LOUISIANA</option><option value="MA">MASSACHUSETTS</option><option value="MD">MARYLAND</option><option value="ME">MAINE</option><option value="MI">MICHIGAN</option><option value="MN">MINNESOTA</option><option value="MO">MISSOURI</option><option value="MS">MISSISSIPPI</option><option value="MT">MONTANA</option><option value="NC">NORTH CAROLINA</option><option value="ND">NORTH DAKOTA</option><option value="NE">NEBRASKA</option><option value="NH">NEW HAMPSHIRE</option><option value="NJ">NEW JERSEY</option><option value="NM">NEW MEXICO</option><option value="NV">NEVADA</option><option value="NY">NEW YORK</option><option value="OH">OHIO</option><option value="OK">OKLAHOMA</option><option value="OR">OREGON</option><option value="PA">PENNSYLVANIA</option><option value="PR">PUERTO RICO</option><option value="RI">RHODE ISLAND</option><option value="SC">SOUTH CAROLINA</option><option value="SD">SOUTH DAKOTA</option><option value="TN">TENNESSEE</option><option value="TX">TEXAS</option><option value="UT">UTAH</option><option value="VA">VIRGINIA</option><option value="VT">VERMONT</option><option value="WA">WASHINGTON</option><option value="WI">WISCONSIN</option><option value="WV">WEST VIRGINIA</option><option value="WY">WYOMING</option></select></td>


</tr>
<tr>
  <td>Zip Code</td>
  <td><input type="text" name="ZipCode"/></td>

</tr>
  <td>Phone number</td>
  <td>(<input name="ShippingPhone_tel1" id="ShippingPhone_tel1" size="3" class="tel3" maxlength="3" type="text"  />
     <input name="ShippingPhone_originalTel1" id="ShippingPhone_originalTel1" 
       type="hidden" />
     <input name="ShippingPhone_originalTel2" "ShippingPhone_originalTel2" 
       type="hidden" />
     <input name="ShippingPhone_originalTel3" id="ShippingPhone_originalTel3" 
       type="hidden" />

     <input name="ShippingPhone_checkTel1" id="ShippingPhone_checkTel1"
type="hidden" value="0" />) &nbsp;<input name="ShippingPhone_tel2" id="ShippingPhone_tel2" 
          size="3" class="tel3" maxlength="3" type="text"  />-&nbsp;<input
name="ShippingPhone_tel3" id="ShippingPhone_tel3" 
 size="4" class="tel4" maxlength="4" type="text"  /></td>

</tr>

</table>




  


<div style = "width: 50%; height: 200px; overflow: scroll"> 
This is a bunch of text that you are suppose to agree to when signing up for a website. Of course no one really reads this so I'm just gonna type a bunch of random stuff. Also you agree that I can have your first born child if you decide to buy something from me. I feel like taking a nap right now but if you have any question don't hit up the site admin because he could really careless about your problems when he has his own. What's that? You need help. Well google is your friend try it out sometimes. Or hey how bout you actually get up and try it before whining you can't do it.Hey look! It scrolls!1 WEEEEEEEE<br /> EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br />EEEEEEEE<br /> Oh man that was a blast. Now go buy some stuff! Or I'll kill a kitten. I MEAN IT!!!!</div>


I have read, and agree to abide by the terms service of this site <input type="checkbox" name="TOSagree" value="TOSagree" />
<input type="submit" value = "Submit" />
</form>

</body>
</html>
The Feather Weight
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6700 Intel DP45SG Visiontek HD 4870 2x2GB DDR3 1066 
Hard DriveOptical DriveOSMonitor
320 Western Digital + 1TB Black Caviar WD Samsung Sata vista ultimate x64/Windows 7 Ultimate 64x Samsung T220 22 inch 
KeyboardPowerCaseMouse
Dynex(Temp until G15) BFG 800 Watt Antec 900 Logitech G5 Gaming mouse 
Mouse Pad
Commando(none) 
View all
  hide details  
Reply
The Feather Weight
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6700 Intel DP45SG Visiontek HD 4870 2x2GB DDR3 1066 
Hard DriveOptical DriveOSMonitor
320 Western Digital + 1TB Black Caviar WD Samsung Sata vista ultimate x64/Windows 7 Ultimate 64x Samsung T220 22 inch 
KeyboardPowerCaseMouse
Dynex(Temp until G15) BFG 800 Watt Antec 900 Logitech G5 Gaming mouse 
Mouse Pad
Commando(none) 
View all
  hide details  
Reply
post #2 of 18
5/1/10 at 8:22pm
This should do the trick. Not 100% guaranteed to work. Did it all in OCN's text-editor, so no blaming me.

Code:
<?php
        $email = $_POST['Email'];
        $emailVerify = $_POST['VerifyEmail'];
    
        $hostname = "localhost";
        $user = "root";
        $password = "";

        $connect = mysql_connect($hostname, $user, $password) or die(mysql.error());

         mysql_select_db("Customers", $connect);

         $sql = "INSERT INTO $tablename VALUES($email, $emailVerify)";

         $query = mysql_query($sql);

         mysql_close($connect);
?>
Personal PC
(13 items)
  		  
CPUMotherboardGraphicsRAM
AMD Phenom II 720 Gigabyte MA-790X-UD4P MSI GeForce 9800GT 4GB OCZ Reapers DDR2 1150 @ 800 
Hard DriveOSMonitorPower
Seagate Barracude 250gb * 2 Ubuntu 10.04 23" Dell SP2309W (2048x1152) PC Power & Cooling 610 
Case
Antec Three Hundred 
View all
  hide details  
Reply
Personal PC
(13 items)
  		  
CPUMotherboardGraphicsRAM
AMD Phenom II 720 Gigabyte MA-790X-UD4P MSI GeForce 9800GT 4GB OCZ Reapers DDR2 1150 @ 800 
Hard DriveOSMonitorPower
Seagate Barracude 250gb * 2 Ubuntu 10.04 23" Dell SP2309W (2048x1152) PC Power & Cooling 610 
Case
Antec Three Hundred 
View all
  hide details  
Reply
post #3 of 18
5/1/10 at 10:27pm
Thread Starter 
I would stiick this on the page i posted correct? Or would I post this on signup.html?

ok I posted it on the page I got up there and then went to the sql database and saw no new entries(after I filled out the form on the site) This is what I see.

what could I be doing wrong?

Edit: after taking a second look I need to create a table. Will try that first and post what happens

Edited by gex80 - 5/1/10 at 10:38pm
The Feather Weight
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6700 Intel DP45SG Visiontek HD 4870 2x2GB DDR3 1066 
Hard DriveOptical DriveOSMonitor
320 Western Digital + 1TB Black Caviar WD Samsung Sata vista ultimate x64/Windows 7 Ultimate 64x Samsung T220 22 inch 
KeyboardPowerCaseMouse
Dynex(Temp until G15) BFG 800 Watt Antec 900 Logitech G5 Gaming mouse 
Mouse Pad
Commando(none) 
View all
  hide details  
Reply
The Feather Weight
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6700 Intel DP45SG Visiontek HD 4870 2x2GB DDR3 1066 
Hard DriveOptical DriveOSMonitor
320 Western Digital + 1TB Black Caviar WD Samsung Sata vista ultimate x64/Windows 7 Ultimate 64x Samsung T220 22 inch 
KeyboardPowerCaseMouse
Dynex(Temp until G15) BFG 800 Watt Antec 900 Logitech G5 Gaming mouse 
Mouse Pad
Commando(none) 
View all
  hide details  
Reply
post #4 of 18
5/2/10 at 1:37am
Quote:
Originally Posted by godsgift2dagame View Post
This should do the trick. Not 100% guaranteed to work. Did it all in OCN's text-editor, so no blaming me.

Code:
<?php
        $email = $_POST['Email'];
        $emailVerify = $_POST['VerifyEmail'];
        $password = $_POST['password'];
        $passwordVerify = $_POST['password2'];

        if $email == $emailVerify && $password == passwordVerify {
        $passwordmd5 = md5($password);

        $hostname = "localhost";
        $user = "root";
        $password = "";
         
        $connect = mysql_connect($hostname, $user, $password) or die(mysql.error());

         mysql_select_db("Customers", $connect);

         $sql = "INSERT INTO $tablename VALUES($email, $passwordmd5)";

         $query = mysql_query($sql);

         mysql_close($connect);
}
else
{
//Add your customised errors here.
}
?>
Fixed - now stores password in database in md5 form, removed email verify in database also checks if email and email verify are same.
This was also done on OCN editor, so no blaming me if I make syntax mistakes which I commonly do.
EDIT: added a password checking, if password and password verify is same then continues the working.
Edited by Console-hater - 5/2/10 at 1:43am
Stalker's computer.
(13 items)
  		  
CPUMotherboardGraphicsRAM
AMD centi-core @ 2.39THZ. High end AM9 motherboard. AMD Radeon HD 9870. 4x1TB RAM @ 1337GHZ. 
Hard DriveOptical DriveOSMonitor
50 Petabtye SSD. 2x Blu-ray drive. Windows 13 Ultimate 128bit. OLED monitor @ 4K resolution. 
PowerCase
No PSU, it runs on 5 potatoes per month. Antec one thousand three hundred thirty-seven. 
View all
  hide details  
Reply
Stalker's computer.
(13 items)
  		  
CPUMotherboardGraphicsRAM
AMD centi-core @ 2.39THZ. High end AM9 motherboard. AMD Radeon HD 9870. 4x1TB RAM @ 1337GHZ. 
Hard DriveOptical DriveOSMonitor
50 Petabtye SSD. 2x Blu-ray drive. Windows 13 Ultimate 128bit. OLED monitor @ 4K resolution. 
PowerCase
No PSU, it runs on 5 potatoes per month. Antec one thousand three hundred thirty-seven. 
View all
  hide details  
Reply
post #5 of 18
5/2/10 at 1:38am
Thread Starter 
Ok I got the database up and running and I have a registration script that adds to the table. With the help of this site: http://php.about.com/od/finishedphp1...login_code.htm. Thanks.

Now I got a new problem. With my login script by it's self It renders everything correctly. Like if I make a php file with only the login script it will show the user name and password and submit button like it is suppose to. But when I insert said script onto my page, some of the code displays on my page.

Is it possible to just keep the php separate and have like a css type link?(Keep the php in a seperate doc but have it run on the other page)
The Feather Weight
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6700 Intel DP45SG Visiontek HD 4870 2x2GB DDR3 1066 
Hard DriveOptical DriveOSMonitor
320 Western Digital + 1TB Black Caviar WD Samsung Sata vista ultimate x64/Windows 7 Ultimate 64x Samsung T220 22 inch 
KeyboardPowerCaseMouse
Dynex(Temp until G15) BFG 800 Watt Antec 900 Logitech G5 Gaming mouse 
Mouse Pad
Commando(none) 
View all
  hide details  
Reply
The Feather Weight
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6700 Intel DP45SG Visiontek HD 4870 2x2GB DDR3 1066 
Hard DriveOptical DriveOSMonitor
320 Western Digital + 1TB Black Caviar WD Samsung Sata vista ultimate x64/Windows 7 Ultimate 64x Samsung T220 22 inch 
KeyboardPowerCaseMouse
Dynex(Temp until G15) BFG 800 Watt Antec 900 Logitech G5 Gaming mouse 
Mouse Pad
Commando(none) 
View all
  hide details  
Reply
post #6 of 18
5/2/10 at 1:45am
Anyway, on my code and godsgift2dagame's, is vulnerable to MYSQL attacks, which can be dangerous and might even take over your website. I recommend you to check tutorials how to stop MYSQL attacks.

EDIT: I can't understand what you're saying/want. Do you mean you want to separate PHP from your website? If so, then there's really no need to do this since all of PHP codes on webpage are parsed and removed before it is being passed to other person.
Edited by Console-hater - 5/2/10 at 1:49am
Stalker's computer.
(13 items)
  		  
CPUMotherboardGraphicsRAM
AMD centi-core @ 2.39THZ. High end AM9 motherboard. AMD Radeon HD 9870. 4x1TB RAM @ 1337GHZ. 
Hard DriveOptical DriveOSMonitor
50 Petabtye SSD. 2x Blu-ray drive. Windows 13 Ultimate 128bit. OLED monitor @ 4K resolution. 
PowerCase
No PSU, it runs on 5 potatoes per month. Antec one thousand three hundred thirty-seven. 
View all
  hide details  
Reply
Stalker's computer.
(13 items)
  		  
CPUMotherboardGraphicsRAM
AMD centi-core @ 2.39THZ. High end AM9 motherboard. AMD Radeon HD 9870. 4x1TB RAM @ 1337GHZ. 
Hard DriveOptical DriveOSMonitor
50 Petabtye SSD. 2x Blu-ray drive. Windows 13 Ultimate 128bit. OLED monitor @ 4K resolution. 
PowerCase
No PSU, it runs on 5 potatoes per month. Antec one thousand three hundred thirty-seven. 
View all
  hide details  
Reply
post #7 of 18
5/2/10 at 1:51am
Thread Starter 
Quote:
Originally Posted by Console-hater View Post
Anyway, on my code and godsgift2dagame's, is vulnerable to MYSQL attacks, which can be dangerous and might even take over your website. I recommend you to check tutorials how to stop MYSQL attacks.
well this is for a school project so I'm not worried about that.

Also I figured out the external php linking.

Turns out that you can't link external php to an html(unless I'm doing it wrong)

So I had to turn homepage.html to homepage.php and put <?php include("script name.php"); ?> and it works.
The Feather Weight
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6700 Intel DP45SG Visiontek HD 4870 2x2GB DDR3 1066 
Hard DriveOptical DriveOSMonitor
320 Western Digital + 1TB Black Caviar WD Samsung Sata vista ultimate x64/Windows 7 Ultimate 64x Samsung T220 22 inch 
KeyboardPowerCaseMouse
Dynex(Temp until G15) BFG 800 Watt Antec 900 Logitech G5 Gaming mouse 
Mouse Pad
Commando(none) 
View all
  hide details  
Reply
The Feather Weight
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6700 Intel DP45SG Visiontek HD 4870 2x2GB DDR3 1066 
Hard DriveOptical DriveOSMonitor
320 Western Digital + 1TB Black Caviar WD Samsung Sata vista ultimate x64/Windows 7 Ultimate 64x Samsung T220 22 inch 
KeyboardPowerCaseMouse
Dynex(Temp until G15) BFG 800 Watt Antec 900 Logitech G5 Gaming mouse 
Mouse Pad
Commando(none) 
View all
  hide details  
Reply
post #8 of 18
5/2/10 at 1:54am
Quote:
Originally Posted by gex80 View Post
well this is for a school project so I'm not worried about that.

Also I figured out the external php linking.

Turns out that you can't link external php to an html(unless I'm doing it wrong)

So I had to turn homepage.html to homepage.php and put <?php include("script name.php"); ?> and it works.
Yep but there is way to do this. By editing your .htaccess file, try make them to parse html file like PHP. Try finding it on google. But this type method is not commonly used.
Stalker's computer.
(13 items)
  		  
CPUMotherboardGraphicsRAM
AMD centi-core @ 2.39THZ. High end AM9 motherboard. AMD Radeon HD 9870. 4x1TB RAM @ 1337GHZ. 
Hard DriveOptical DriveOSMonitor
50 Petabtye SSD. 2x Blu-ray drive. Windows 13 Ultimate 128bit. OLED monitor @ 4K resolution. 
PowerCase
No PSU, it runs on 5 potatoes per month. Antec one thousand three hundred thirty-seven. 
View all
  hide details  
Reply
Stalker's computer.
(13 items)
  		  
CPUMotherboardGraphicsRAM
AMD centi-core @ 2.39THZ. High end AM9 motherboard. AMD Radeon HD 9870. 4x1TB RAM @ 1337GHZ. 
Hard DriveOptical DriveOSMonitor
50 Petabtye SSD. 2x Blu-ray drive. Windows 13 Ultimate 128bit. OLED monitor @ 4K resolution. 
PowerCase
No PSU, it runs on 5 potatoes per month. Antec one thousand three hundred thirty-seven. 
View all
  hide details  
Reply
post #9 of 18
5/2/10 at 7:40am
Thread Starter 
Why do I keep getting a syntax error when I try to make this table?
Code:
CREATE TABLE Customer_Order (
order_number INT(6) NOT NULL AUTO_INCREMENT,
order_date DATE NOT NULL,
shipping_fee DECIMAL(9,2),
sales_tax DECIMAL(9,2),
submitted ENUM(“yesâ€,’no’),
ship_name VARCHAR(50),
ship_street VARCHAR(50),
ship_city VARCHAR(50),
ship_state VARCHAR(2),
ship_zip VARCHAR(10),
email VARCHAR(50),
phone VARCHAR(20),
PRIMARY KEY(order_number) );
The Feather Weight
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6700 Intel DP45SG Visiontek HD 4870 2x2GB DDR3 1066 
Hard DriveOptical DriveOSMonitor
320 Western Digital + 1TB Black Caviar WD Samsung Sata vista ultimate x64/Windows 7 Ultimate 64x Samsung T220 22 inch 
KeyboardPowerCaseMouse
Dynex(Temp until G15) BFG 800 Watt Antec 900 Logitech G5 Gaming mouse 
Mouse Pad
Commando(none) 
View all
  hide details  
Reply
The Feather Weight
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6700 Intel DP45SG Visiontek HD 4870 2x2GB DDR3 1066 
Hard DriveOptical DriveOSMonitor
320 Western Digital + 1TB Black Caviar WD Samsung Sata vista ultimate x64/Windows 7 Ultimate 64x Samsung T220 22 inch 
KeyboardPowerCaseMouse
Dynex(Temp until G15) BFG 800 Watt Antec 900 Logitech G5 Gaming mouse 
Mouse Pad
Commando(none) 
View all
  hide details  
Reply
post #10 of 18
5/2/10 at 9:00am
Thread Starter 
Wow over 4k views pretty popular topic?

Neways I got the table to insert and now my registration page links to the table and database and it creates a table that stores their information such as account balance(DEC 9,2) Name, address, account ID(int 6) and more that is entered in at the time of sign up (so editing that data is not important now.)

How do I go about making a script that would add and subtract datatype DEC(9,2) from a null value from the sql server. I will write a script that makes sure Value added or subjected remain >= 0(meaning you can't withdraw more money then you have. lol I got 29.5 hours to get this done.
The Feather Weight
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6700 Intel DP45SG Visiontek HD 4870 2x2GB DDR3 1066 
Hard DriveOptical DriveOSMonitor
320 Western Digital + 1TB Black Caviar WD Samsung Sata vista ultimate x64/Windows 7 Ultimate 64x Samsung T220 22 inch 
KeyboardPowerCaseMouse
Dynex(Temp until G15) BFG 800 Watt Antec 900 Logitech G5 Gaming mouse 
Mouse Pad
Commando(none) 
View all
  hide details  
Reply
The Feather Weight
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6700 Intel DP45SG Visiontek HD 4870 2x2GB DDR3 1066 
Hard DriveOptical DriveOSMonitor
320 Western Digital + 1TB Black Caviar WD Samsung Sata vista ultimate x64/Windows 7 Ultimate 64x Samsung T220 22 inch 
KeyboardPowerCaseMouse
Dynex(Temp until G15) BFG 800 Watt Antec 900 Logitech G5 Gaming mouse 
Mouse Pad
Commando(none) 
View all
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Coding and Programming
Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › PHP and mysql database