Jump to content

can you help

bob2006

By bob2006
in PHP Coding Help

Recommended Posts

bob2006 Member

bob2006

Posted
Posted

The code i have been working on will not insert the info in to the database there is the part that is for the insert 

//Insert Oder Info 
$insert=mysql_query("INSERT INTO `order`(order_number,userid,user_name) VALUES 
(''; '$user_id', '$username)")or die(mysql_error());

 

and here is the whole script 

<? 
session_start();
$sid=session_id();
INCLUDE('db.php'); 
?><?
if($_GET['act'] == "") { 
if($_SESSION['username'] && $_SESSION['password']) { 
echo("Your logged in already!"); 
} else { 
echo("<table align='center'>
<tr><td colspan='2'><center>Register:</center></td></tr>
<form action='?act=check&sid=$sid' method='POST' name='register'> 
<tr><td>First Name:</td><td><input type='text' name='first' size='22'></td></tr> 
<tr><td>Last Name</td><td><input type='text' name='last' size='22'></td></tr> 

<tr><td>Username:</td><td><input type='text' name='username' size='22'></td></tr>

<tr><td colspan='2' align='right'>")
?>

</td></tr> 
<tr><td>Password:</td><td><input type='password' name='password' size='22'></td></tr> 
<tr><td>Password Confirm:</td><td><input type='password' name='password2' size='22'></td></tr> 
<tr><td>E-Mail:</td><td><input type='text' name='email12' size='22'></td></tr>
<tr><td>PayPal Email:</td><td><input type='text' name='pay_email' size='22'> If paying with PayPal</td></tr>
<tr><td>Domain:</td><td><input type='text' name='domain'  size='22'></td></tr>
<tr><td>Gender:</td><td><input type='radio' name='gender' value=male>Male <input type=radio name=gender value=female>Female 
<input type='radio' name='gender' checked value='Not Sure'>Not Sure</td></tr> 
<tr><td>Hosting Package:<td>
<select name="package">
<option value="Basic Hosting"> 
Basic Hosting   
100 Megs Of space
500 Megs Of Bandwidth
500 Email
Cpanel
$8.95</option>
<option value="Silver Hosting">
Silver Hosting
200 Megs Of space
1000 Megs Of Bandwidth
1000 Email
Cpanel
$12.50</option>
<option value="Gold Hosting">
<p style='margin-top: 0; margin-bottom: 0'>Gold Hosting
500 Megs Of space
2000 Megs Of Bandwidth
2000 Email
Cpanel
$15.550</option>
<option value="Super Hosting">
Super Hosting
1000 Megs Of space
5000 Megs Of Bandwidth
5000 Email
Cpanel
$19.00</option>
</select>

<?
echo(" <tr><td>City:</td><td><input type='text' name='city' size='22'></td></tr><tr><td>Zip:</td><td><input type='text' name='zip' size='22'></td></tr><tr><td>State:<td><select name='state'>	
<option value='ALABAMA'>Alabama</option>
<option value='ALASKA'>Alaska</option>
<option value='ARIZONA'>Arizona</option>
<option value='ARKANSAS'>Arkansas</option>
<option value='CALIFORNIA'>California</option>
<option value='COLORADO'>Colorado</option>
<option value='CONNECTICUT'>Connecticut</option>
<option value='DELAWARE'>Delaware</option>
<option value='WASHINGTON DC'>Washington DC</option>
<option value='FLORIDA'>Florida</option>
<option value='GEORGIA'>Georgia</option>
<option value='HAWAII'>Hawaii</option>
<option value='IDAHO'>Idaho</option>
<option value='ILLINOIS'>Illinois</option>
<option value='INDIANA'>Indiana</option>
<option value='IOWA'>Iowa</option>
<option value='KANSAS'>Kansas</option>
<option value='KENTUCKY'>Kentucky</option>
<option value='LOUISIANA'>Louisiana</option>
<option value='MAINE'>Maine</option>
<option value='MARYLAND'>Maryland</option>
<option value='MASSACHUSETTS'>Massachusetts</option>
<option value='MICHIGAN'>Michigan</option>
<option value='MINNESOTA'>Minnesota</option>
<option value='MISSISSIPPI'>Mississippi</option>
<option value='MISSOURI'>Missouri</option>
<option value='MONTANA'>Montana</option>
<option value='NEBRASKA'>Nebraska</option>
<option value='NEVADA'>Nevada</option>
<option value='NEW HAMPSHIRE'>New Hampshire</option>
<option value='NEW JERSEY'>New Jersey</option>
<option value='NEW MEXICO'>New Mexico</option>
<option value='NEW YORK'>New York</option>
<option value='NORTH CAROLINA'>North Carolina</option>
<option value='NORTH DAKOTA'>North Dakota</option>
<option value='OHIO'>Ohio</option>
<option value='OKLAHOMA'>Oklahoma</option>
<option value='OREGON'>Oregon</option>
<option value='PENNSYLVANIA'>Pennsylvania</option>
<option value='RHODE ISLAND'>Rhode Island</option>
<option value='SOUTH CAROLINA'>South Carolina</option>
<option value='SOUTH DAKOTA'>South Dakota</option>
<option value='TENNESSEE'>Tennessee</option>
<option value='TEXAS'>Texas</option>
<option value='UTAH'>Utah</option>
<option value='VERMONT'>Vermont</option>
<option value='VIRGINIA'>Virginia</option>
<option value='WASHINGTON'>Washington</option>
<option value='WEST VIRGINIA'>West Virginia</option>
<option value='WISCONSIN'>Wisconsin</option>
<option value='WYOMING'>Wyoming</option>

</select>
<tr><td>Country:<br></td><td>

<select name='country'>
<option value='AF'>Afghanistan</option>
<option value='AL'>Albania</option>
<option value='DZ'>Algeria</option>
<option value='AS'>American Samoa</option>
<option value='AD'>Andorra</option>
<option value='AO'>Angola</option>
<option value='AI'>Anguilla</option>
<option value='AQ'>Antarctica</option>
<option value='AG'>Antigua and Barbuda</option>
<option value='AR'>Argentina</option>
<option value='AM'>Armenia</option>
<option value='AW'>Aruba</option>
<option value='AU'>Australia</option>
<option value='AT'>Austria</option>
<option value='AZ'>Azerbaijan</option>
<option value='BS'>Bahamas</option>
<option value='BH'>Bahrain</option>
<option value='BD'>Bangladesh</option>
<option value='BB'>Barbados</option>
<option value='BY'>Belarus</option>
<option value='BE'>Belgium</option>
<option value='BZ'>Belize</option>
<option value='BJ'>Benin</option>
<option value='BM'>Bermuda</option>
<option value='BT'>Bhutan</option>
<option value='BO'>Bolivia</option>
<option value='BA'>Bosnia and Herzegowina</option>
<option value='BW'>Botswana</option>
<option value='BV'>Bouvet Island</option>
<option value='BR'>Brazil</option>
<option value='IO'>British Indian Ocean Territory</option>
<option value='BN'>Brunei Darussalam</option>
<option value='BG'>Bulgaria</option>
<option value='BF'>Burkina Faso</option>
<option value='BI'>Burundi</option>
<option value='KH'>Cambodia</option>
<option value='CM'>Cameroon</option>
<option value='CA'>Canada</option>
<option value='CV'>Cape Verde</option>
<option value='KY'>Cayman Islands</option>
<option value='CF'>Central African Republic</option>
<option value='TD'>Chad</option>
<option value='CL'>Chile</option>
<option value='CN'>China</option>
<option value='CX'>Christmas Island</option>
<option value='CC'>Cocoa (Keeling) Islands</option>
<option value='CO'>Colombia</option>
<option value='KM'>Comoros</option>
<option value='CG'>Congo</option>
<option value='CK'>Cook Islands</option>
<option value='CR'>Costa Rica</option>
<option value='CI'>Cote Divoire</option>
<option value='CT'>Croatia (Hrvatska)</option>
<option value='CU'>Cuba</option>
<option value='CY'>Cyprus</option>
<option value='CZ'>Czech Republic</option>
<option value='DK'>Denmark</option>
<option value='DJ'>Djibouti</option>
<option value='DM'>Dominica</option>
<option value='DO'>Dominican Republic</option>
<option value='TP'>East Timor</option>
<option value='EC'>Ecuador</option>
<option value='EG'>Egypt</option>
<option value='SV'>El Salvador</option>
<option value='GQ'>Equatorial Guinea</option>
<option value='ER'>Eritrea</option>
<option value='EE'>Estonia</option>
<option value='ET'>Ethiopia</option>
<option value='FK'>Falkland Islands (Malvinas)</option>
<option value='FO'>Faroe Islands</option>
<option value='FJ'>Fiji</option>
<option value='FI'>Finland</option>
<option value='FR'>France</option>
<option value='GA'>Gabon</option>
<option value='GM'>Gambia</option>
<option value='GE'>Georgia</option>
<option value='DE'>Germany</option>
<option value='GH'>Ghana</option>
<option value='GI'>Gibraltar</option>
<option value='GR'>Greece</option>
<option value='GL'>Greenland</option>
<option value='GD'>Grenada</option>
<option value='GU'>Guam</option>
<option value='GT'>Guatemala</option>
<option value='GN'>Guinea</option>
<option value='GW'>Guinea-Bissau</option>
<option value='GY'>Guyana</option>
<option value='HT'>Haiti</option>
<option value='HM'>Heard and Mc Donald Islands</option>
<option value='HN'>Honduras</option>
<option value='HK'>Hong Kong</option>
<option value='HU'>Hungary</option>
<option value='IS'>Iceland</option>
<option value='IN'>India</option>
<option value='ID'>Indonesia</option>
<option value='IR'>Iran (Islamic Republic of)</option>
<option value='IQ'>Iraq</option>
<option value='IE'>Ireland</option>
<option value='IL'>Israel</option>
<option value='IT'>Italy</option>
<option value='JM'>Jamaica</option>
<option value='JP'>Japan</option>
<option value='JO'>Jordan</option>
<option value='KZ'>Kazakhstan</option>
<option value='KE'>Kenya</option>
<option value='KI'>Kiribati</option>
<option value='KP'>Korea,  Democratic Peoples Republic of</option>
<option value='KR'>Korea,  Republic of</option>
<option value='KW'>Kuwait</option>
<option value='KG'>Kyrgyzstan</option>
<option value='LA'>Lao Peoples Democratic Republic</option>
<option value='LV'>Latvia</option>
<option value='LB'>Lebanon</option>
<option value='LS'>Lesotho</option>
<option value='LR'>Liberia</option>
<option value='LY'>Libyan Arab Jamahiriya</option>
<option value='LI'>Liechtenstein</option>
<option value='LT'>Lithuania</option>
<option value='LU'>Luxembourg</option>
<option value='MO'>Macau</option>
<option value='MK'>Macedonia, The Former Yugoslav Republic of</option>
<option value='MG'>Madagascar</option>
<option value='MW'>Malawi</option>
<option value='MY'>Malaysia</option>
<option value='MV'>Maldives</option>
<option value='ML'>Mali</option>
<option value='MT'>Malta</option>
<option value='MH'>Marshall Islands</option>
<option value='MR'>Mauritania</option>
<option value='MU'>Mauritius</option>
<option value='MX'>Mexico</option>
<option value='FM'>Micronesia, Federated States of</option>
<option value='MD'>Moldova,  Republic of</option>
<option value='MC'>Monaco</option>
<option value='MN'>Mongolia</option>
<option value='MS'>Montserrat</option>
<option value='MA'>Morocco</option>
<option value='MZ'>Mozambique</option>
<option value='MM'>Myanmar</option>
<option value='NA'>Namibia</option>
<option value='NR'>Nauru</option>
<option value='NP'>Nepal</option>
<option value='NL'>Netherlands</option>
<option value='AN'>Netherlands Antilles</option>
<option value='NZ'>New Zealand</option>
<option value='NI'>Nicaragua</option>
<option value='NE'>Niger</option>
<option value='NG'>Nigeria</option>
<option value='NU'>Niue</option>
<option value='NF'>Norfolk Island</option>
<option value='MP'>Northern Mariana Islands</option>
<option value='NO'>Norway</option>
<option value='OM'>Oman</option>
<option value='PK'>Pakistan</option>
<option value='PW'>Palau</option>
<option value='PA'>Panama</option>
<option value='PG'>Papua New Guinea</option>
<option value='PY'>Paraguay</option>
<option value='PE'>Peru</option>
<option value='PH'>Philippines</option>
<option value='PN'>Pitcairn</option>
<option value='PL'>Poland</option>
<option value='PT'>Portugal</option>
<option value='PR'>Puerto Rico</option>
<option value='QA'>Qatar</option>
<option value='RO'>Romania</option>
<option value='RU'>Russian Federation</option>
<option value='RW'>Rwanda</option>
<option value='KN'>Saint Kitts and Nevis</option>
<option value='LC'>Saint Lucia</option>
<option value='VC'>Saint Vincent and the Grenadines</option>
<option value='WS'>Samoa</option>
<option value='SM'>San Marino</option>
<option value='ST'>Sao Tome and Principe</option>
<option value='SA'>Saudi Arabia</option>
<option value='SN'>Senegal</option>
<option value='SC'>Seychelles</option>
<option value='SL'>Sierra Leone</option>
<option value='SG'>Singapore</option>
<option value='SK'>Slovakia (Slovak Republic)</option>
<option value='SI'>Slovenia</option>
<option value='Sb'>Solomon Islands</option>
<option value='SO'>Somalia</option>
<option value='ZA'>South Africa</option>
<option value='GS'>South Georgia and the South Sandwich Islands</option>
<option value='ES'>Spain</option>
<option value='LK'>Sri Lanka</option>
<option value='SH'>St. Helena</option>
<option value='SD'>Sudan</option>
<option value='SR'>Suriname</option>
<option value='SJ'>Svalbard and Jan Mayen Islands</option>
<option value='SZ'>Swaziland</option>
<option value='SE'>Sweden</option>
<option value='CH'>Switzerland</option>
<option value='SY'>Syrian ArabRepublic</option>
<option value='TW'>Taiwan</option>
<option value='TJ'>Tajikistan</option>
<option value='TZ'>Tanzania,  United Republic of</option>
<option value='TH'>Thailand</option>
<option value='TG'>Togo</option>
<option value='TK'>Tokelau</option>
<option value='TO'>Tonga</option>
<option value='TT'>Trinidad and Tobago</option>
<option value='TN'>Tunisia</option>
<option value='TR'>Turkey</option>
<option value='TM'>Turkmenistan</option>
<option value='TC'>Turks and Caicos Islands</option>
<option value='TV'>Tuvalu</option>
<option value='UG'>Uganda</option>
<option value='UA'>Ukraine</option>
<option value='AE'>United ArabEmirates</option>
<option value='UK'>United Kingdom</option>
<option selected='selected' value='US'>United States</option>
<option value='UM'>United States Minor Outlying Islands</option>
<option value='UY'>Uruguay</option>
<option value='UZ'>Uzbekistan</option>
<option value='VU'>Vanuatu</option>
<option value='VA'>Vatican City State(Holy See)</option>
<option value='VE'>Venezuela</option>
<option value='VN'>Viet Nam</option>
<option value='VG'>Virgin Islands (British)</option>
<option value='VI'>Virgin Islands (U.S.)</option>
<option value='EH'>Western Sahara</option>
<option value='YE'>Yeman</option>
<option value='YU'>Yugoslavia</option>
<option value='ZR'>Zaire</option>
<option value='ZM'>Zambia</option>
<option value='ZW'>Zimbabwe</option>

</select>

</td></tr> 
<tr><td>Birth Date:<br>mm/dd/yyyy</td><td><select name='month'>
<option value='1'>1</option>
<option value='2'>2</option>
<option value='3'>3</option>
<option value='4'>4</option>
<option value='5'>5</option>
<option value='6'>6</option>
<option value='7'>7</option>
<option value='8'>8</option>
<option value='9'>9</option>
<option value='10'>10</option>
<option value='11'>11</option>
<option value='12'>12</option>
</select>/<select name='day'>
<option value='1'>1</option>
<option value='2'>2</option>
<option value='3'>3</option>
<option value='4'>4</option>
<option value='5'>5</option>
<option value='6'>6</option>
<option value='7'>7</option>
<option value='8'>8</option>
<option value='9'>9</option>
<option value='10'>10</option>
<option value='11'>11</option>
<option value='12'>12</option>
<option value='13'>13</option>
<option value='14'>14</option>
<option value='15'>15</option>
<option value='16'>16</option>
<option value='17'>17</option>
<option value='18'>18</option>
<option value='19'>19</option>
<option value='20'>20</option>
<option value='21'>21</option>
<option value='22'>22</option>
<option value='23'>23</option>
<option value='24'>24</option>
<option value='25'>25</option>
<option value='26'>26</option>
<option value='27'>27</option>
<option value='28'>28</option>
<option value='29'>29</option>
<option value='30'>30</option>
<option value='31'>31</option>
</select>/<select name='year'>
<option value='1992'>1992</option>
<option value='1991'>1991</option>
<option value='1990'>1990</option>
<option value='1989'>1989</option>
<option value='1988'>1988</option>
<option value='1987'>1987</option>
<option value='1986'>1986</option>
<option value='1985'>1985</option>
<option value='1984'>1984</option>
<option value='1983'>1983</option>
<option value='1982'>1982</option>
<option value='1981'>1981</option>
<option value='1980'>1980</option>
<option value='1979'>1979</option>
<option value='1978'>1978</option>
<option value='1977'>1977</option>
<option value='1976'>1976</option>
<option value='1975'>1975</option>
<option value='1974'>1974</option>
<option value='1973'>1973</option>
<option value='1972'>1972</option>
<option value='1971'>1971</option>
<option value='1970'>1970</option>
<option value='1969'>1969</option>
<option value='1968'>1968</option>
<option value='1967'>1967</option>
<option value='1966'>1966</option>
<option value='1965'>1965</option>
<option value='1964'>1964</option>
<option value='1963'>1963</option>
<option value='1962'>1962</option>
<option value='1961'>1961</option>
<option value='1960'>1960</option>
<option value='1959'>1959</option>
<option value='1958'>1958</option>
<option value='1957'>1957</option>
<option value='1956'>1956</option>
<option value='1955'>1955</option>
<option value='1954'>1954</option>
<option value='1953'>1953</option>
<option value='1952'>1952</option>
<option value='1951'>1951</option>
<option value='1950'>1950</option>
<option value='1949'>1949</option>
<option value='1948'>1948</option>
<option value='1947'>1947</option>
<option value='1946'>1946</option>
<option value='1945'>1945</option>
<option value='1944'>1944</option>
<option value='1943'>1943</option>
<option value='1942'>1942</option>
<option value='1941'>1941</option>
<option value='1940'>1940</option>
<option value='1939'>1939</option>
<option value='1938'>1938</option>
<option value='1937'>1937</option>
<option value='1936'>1936</option>
<option value='1935'>1935</option>
<option value='1934'>1934</option>
<option value='1933'>1933</option>
<option value='1932'>1932</option>
<option value='1931'>1931</option>
<option value='1930'>1930</option>
<option value='1929'>1929</option>
<option value='1928'>1928</option>
<option value='1927'>1927</option>
<option value='1926'>1926</option>
<option value='1925'>1925</option>
<option value='1924'>1924</option>
<option value='1923'>1923</option>
<option value='1922'>1922</option>
<option value='1921'>1921</option>
<option value='1920'>1920</option>
<option value='1919'>1919</option>
<option value='1918'>1918</option>
<option value='1917'>1917</option>
<option value='1916'>1916</option>
<option value='1915'>1915</option>
<option value='1914'>1914</option>
<option value='1913'>1913</option>
<option value='1912'>1912</option>
<option value='1911'>1911</option>
<option value='1910'>1910</option>
<option value='1909'>1909</option>
<option value='1908'>1908</option>
<option value='1907'>1907</option>
<option value='1906'>1906</option>
<tr><td><input type='submit' name='submit' value='Sign Up Now!'></td></tr> 
</form> 
</table>"); 
} 
}
if($_GET['act'] == "check") { 
if(!$_POST['username'] || !$_POST['password'] || !$_POST['password2'] || !$_POST['city'] || !$_POST['zip'] || !$_POST['state']  || !$_POST['email12']) { 
echo("<a href=%22javascript:history.go(-1)/%22>Go back and fill out all fields, correctly!</a>"); 
} else { 
$username=$_POST['username']; 

$check=mysql_query("SELECT * FROM `users` WHERE username = '$username'")or die(mysql_error()); 
$Numb=mysql_num_rows($check); 

if($Numb =='1') { 
echo("Sorry The Username You Chose Is Not Available Please<a href=%22javascript:history.go(-1)/%22>Go Back</a> And Choose A Different Username"); 
} else  
if($password != $password2) { 
echo("Sorry Your Passwords Didn't Match<a href=%22javascript:history.go(-1)/%22> Go back</a> To Fix This Error"); 
} else { 

$username=addslashes($username); 
$password=$password; 
$date=date("M j, Y"); 
$first=$first;
$last=$last;

$package=$_POST['package'];
if($package=="Basic Hosting") {
$price="8.95";
}
else
if($package=="Silver Hosting") {
$price="12.50";
}
else
if($package=="Gold Hosting") {
$price="15.50";
}
else
if($package=="Super Hosting") {
$price="19.00";
}
//Insert Oder Info 
$insert=mysql_query("INSERT INTO `order`(order_number,userid,user_name) VALUES 
(''; '$user_id', '$username)")or die(mysql_error()); 



//Create User In Database
$INSERT=mysql_query("INSERT INTO `users`(user_id,username,password,date_joined,email,first_name,last_name,city,country,zip,birth_month,birth_day,birth_year,state,gender,domain,package,price,paypal) VALUES 
('', '$username', '$password', '$date', '$email12', '$first', '$last', '$city',  '$country', '$zip', '$month', '$day', '$year', '$state', '$gender', '$domain', '$package', '$price', '$pay_email')")or die(mysql_error()); 


$data = mysql_query("SELECT * FROM users WHERE username='$username'") 
or die(mysql_error()); 
while($info = mysql_fetch_array( $data )) 
{ 
//pull user info from database

$user_id=$info['user_id'];
}



$data2 = mysql_query("SELECT * FROM order WHERE userid='$user_id'") 
or die(mysql_error()); 
while($info2 = mysql_fetch_array( $data )) 
{ 
//pull user info from database

$order_number=$info2['order_number'];
}

echo("<center>You Have Successfully Registered The Last Step Is to Pay For the Hosting Services:<br /> 
<B>Thank you :</B> $first  $last!<br /><br>Package: $package Price: $$price<br>Domain: $domain
<br>Customer Number:$user_id<br>Order Number:$order_number

<br>
<form action='https://www.paypal.com/cgi-bin/webscr' method='post'>
<input type='image' src='http://www.citrushostingplus.com/images/subscribe.gif' border='0' name='submit' alt='Make payments with PayPal - it's fast, free and secure!' width='73' height='44'>
<img alt='' border='0' src='https://www.paypal.com/en_US/i/scr/pixel.gif' width='1' height='1'>
<input type='hidden' name='cmd' value='_xclick-subscriptions'>
<input type='hidden' name='business' value='[email protected]'>
<input type='hidden' name='item_name' value='$package'>
<input type='hidden' name='item_number' value='001'>
<input type='hidden' name='no_shipping' value='1'>
<input type='hidden' name='no_note' value='1'>
<input type='hidden' name='currency_code' value='USD'>
<input type='hidden' name='lc' value='US'>
<input type='hidden' name='bn' value='PP-SubscriptionsBF'>
<input type='hidden' name='a3' value='$price'>
<input type='hidden' name='p3' value='30'>
<input type='hidden' name='t3' value='D'>
<input type='hidden' name='src' value='1'>
<input type='hidden' name='sra' value='1'>
</form>
<table align='center'> 
</tr></table>");  

} 
} 
} 

?>

Link to comment
https://forums.phpfreaks.com/topic/49883-can-you-help/
Share on other sites
bob2006 Member

bob2006

Posted
  • Author
Posted

now iam have a problem pulling the info out if te database this code should work but is not

here is the code 

$dat = mysql_query("SELECT * FROM 'order' WHERE userid='$userid'") 
or die(mysql_error());while($inf = mysql_fetch_array( $dat )) 
{ 
//pull user info from database

$order_number=$inf['order_number'];
}

it is part of the same script as above

 

Link to comment
https://forums.phpfreaks.com/topic/49883-can-you-help/#findComment-244749
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.