Проблем с AJAX заявка

Nihtewalk · 28 Февруари 2010

Така,проблема е category и sub_category не се пращат до PHP файла :/Другите са наред.Когато махна JavaScript-а тоест оставя само PHP е добре всичко...

Код:

 <script type="text/javascript">
   
function delayer(){
    window.location = "my_acc.php"
}

  $(function(){
     

    
     $("#submit").click(function(){

        var category = $("#Category").val();
        var sub_category = $("#SubCat").val();
        var task = $("#task").val();
        var title = $("#title").val();
        var description = $("#description").val();
        var country = $("#country").val();
        var city = $("#city").val();
        var zip_code = $("#zip_code").val();
        var adress = $("#adress").val();
        var stage = $("#stage").val();
        var time = $("#time").val();
        var bid_number = $("#bid_number").val();

        $("<img src='load.gif' id='loading' />").appendTo("#result");
        $.ajax({
        url: "create_engine.php",
        type:"POST",
        data: "category=" + category + "&sub_category=" + sub_category + "&task=" + task + "&title=" + title +
         "&description=" + description + "&country=" + country + "&city=" + city + "&zip_code=" + zip_code +
         "&adress=" + adress + "&time=" + time + "&stage=" + stage + "&bid_number=" + bid_number,
         success: function(result){

         $("#table").hide();
         $("#result").hide().html(result).fadeIn("slow");
         $("#loading").remove();
         setTimeout('delayer()', 3000);

     }

        });
        return false;
     });
  });
</script>

Eто го и PHP файла :

Код:

<?php
session_start();
include 'common.php';


$category = $_POST['Category'];
$sub_category = $_POST['SubCat'];
$task = $_POST['task'];
$title = $_POST['title'];
$description = $_POST['description'];
$country = $_POST['country'];
$city = $_POST['city'];
$zip_code = $_POST['zip_code'];
$adress = $_POST['adress'];
$stage = $_POST['stage'];
$time = $_POST['time'];
$bid_number = $_POST['bid_number'];

$insert = "INSERT INTO projects (`category`,`sub_category`,`task`,`title`,`description`,`country`,`city`,`zip_code`,`adress`,stage,time,bid_number)
 VALUES ('$category','$sub_category','$task','$title','$description','$country','$city','$zip_code','$adress','$time','$stage','$bid_number')";

$result = mysql_query($insert) or die(mysql_error());

?>

slideR · 28 Февруари 2010

дай и HTML

Nihtewalk · 28 Февруари 2010

HTML-a е добре,защото като оставя само PHP си е добре

slideR · 28 Февруари 2010

Направи ли си id-тата

Nihtewalk · 28 Февруари 2010

Ид-тата на самите input-и?

slideR · 28 Февруари 2010

да, затова дай html када

Nihtewalk · 28 Февруари 2010

echo "
<br /><br />
<table align='center' cellspacing='1px' id='table' >
<form name='drop_list' action='create_engine.php' method='POST' >

<tr><td colspan='2'><p class='definitions'><b>Select Your Job Type</b></p></td><td></td></tr>
<tr><td colspan='2'><select id='Category' name='Category' onChange='SelectSubCat();' >
<option value=''>Please Select Your Job Type</option>
</select></td><td></td></tr>
<tr><td width='200px' align='center'><b><p class='definitions'>Select Your Job Category</p></b></td>
<td width='200px' align='center'><b><p class='definitions'>Select Your Task</p></b></td></tr>

<tr><td align='center'>
<select id='SubCat' name='SubCat'>
<option value=''>Please Select Job Category</option>
<option value=''></option>
</select></td>

<td align='center'><select id='task' name='task'>
<option value=''>Select Task</option>
<option value=''></option>
</select></td></tr>

<tr><td colspan='2'><b>Title:</b></td></tr>
<tr><td colspan='2'><input type='text' name='title' id='title'></td></tr>
<tr><td colspan='2'><b>Description:</b></td></tr>
<tr><td colspan='2'><textarea rows=5 cols=25 name='description' id='description' ></textarea></td></tr>
<tr><td colspan='1' align='center'><b>Country:</b></td><td colspan='1' align='center' ><b>City:</b></td></tr>
<tr><td colspan='1' align='center'><select name='country' id='country' style='width:150px;'>
<option value='United States' selected='selected'>United States</option>
<option value='Canada'>Canada</option>
<option value='United Kingdom' >United Kingdom</option>
<option value='Ireland' >Ireland</option>
<option value='Australia' >Australia</option>
<option value='New Zealand' >New Zealand</option>
<option value='null' >-------------------</option>
<option value='Afghanistan'>Afghanistan</option>
<option value='Albania'>Albania</option>
<option value='Algeria'>Algeria</option>
<option value='American Samoa'>American Samoa</option>
<option value='Andorra'>Andorra</option>
<option value='Angola'>Angola</option>
<option value='Anguilla'>Anguilla</option>
<option value='Antarctica'>Antarctica</option>
<option value='Antigua and Barbuda'>Antigua and Barbuda</option>
<option value='Argentina'>Argentina</option>
<option value='Armenia'>Armenia</option>
<option value='Aruba'>Aruba</option>
<option value='Australia'>Australia</option>
<option value='Austria'>Austria</option>
<option value='Azerbaijan'>Azerbaijan</option>
<option value='Bahamas'>Bahamas</option>
<option value='Bahrain'>Bahrain</option>
<option value='Bangladesh'>Bangladesh</option>
<option value='Barbados'>Barbados</option>
<option value='Belarus'>Belarus</option>
<option value='Belgium'>Belgium</option>
<option value='Belize'>Belize</option>
<option value='Benin'>Benin</option>
<option value='Bermuda'>Bermuda</option>
<option value='Bhutan'>Bhutan</option>
<option value='Bolivia'>Bolivia</option>
<option value='Bosnia and Herzegovina'>Bosnia and Herzegovina</option>
<option value='Botswana'>Botswana</option>
<option value='Bouvet Island'>Bouvet Island</option>
<option value='Brazil'>Brazil</option>
<option value='British Indian Ocean Territory'>British Indian Ocean Territory</option>
<option value='Brunei Darussalam'>Brunei Darussalam</option>
<option value='Bulgaria'>Bulgaria</option>
<option value='Burkina Faso'>Burkina Faso</option>
<option value='Burundi'>Burundi</option>
<option value='Cambodia'>Cambodia</option>
<option value='Cameroon'>Cameroon</option>
<option value='Canada'>Canada</option>
<option value='Cape Verde'>Cape Verde</option>
<option value='Cayman Islands'>Cayman Islands</option>
<option value='Central African Republic'>Central African Republic</option>
<option value='Chad'>Chad</option>
<option value='Chile'>Chile</option>
<option value='China'>China</option>
<option value='Christmas Island'>Christmas Island</option>
<option value='Cocos (Keeling) Islands'>Cocos (Keeling) Islands</option>
<option value='Colombia'>Colombia</option>
<option value='Comoros'>Comoros</option>
<option value='Congo'>Congo</option>
<option value='Congo, The Democratic Republic of The'>Congo, The Democratic Republic of The</option>
<option value='Cook Islands'>Cook Islands</option>
<option value='Costa Rica'>Costa Rica</option>
<option value='Cote D'ivoire'>Cote D'ivoire</option>
<option value='Croatia'>Croatia</option>
<option value='Cuba'>Cuba</option>
<option value='Cyprus'>Cyprus</option>
<option value='Czech Republic'>Czech Republic</option>
<option value='Denmark'>Denmark</option>
<option value='Djibouti'>Djibouti</option>
<option value='Dominica'>Dominica</option>
<option value='Dominican Republic'>Dominican Republic</option>
<option value='Ecuador'>Ecuador</option>
<option value='Egypt'>Egypt</option>
<option value='El Salvador'>El Salvador</option>
<option value='Equatorial Guinea'>Equatorial Guinea</option>
<option value='Eritrea'>Eritrea</option>
<option value='Estonia'>Estonia</option>
<option value='Ethiopia'>Ethiopia</option>
<option value='Falkland Islands (Malvinas)'>Falkland Islands (Malvinas)</option>
<option value='Faroe Islands'>Faroe Islands</option>
<option value='Fiji'>Fiji</option>
<option value='Finland'>Finland</option>
<option value='France'>France</option>
<option value='French Guiana'>French Guiana</option>
<option value='French Polynesia'>French Polynesia</option>
<option value='French Southern Territories'>French Southern Territories</option>
<option value='Gabon'>Gabon</option>
<option value='Gambia'>Gambia</option>
<option value='Georgia'>Georgia</option>
<option value='Germany'>Germany</option>
<option value='Ghana'>Ghana</option>
<option value='Gibraltar'>Gibraltar</option>
<option value='Greece'>Greece</option>
<option value='Greenland'>Greenland</option>
<option value='Grenada'>Grenada</option>
<option value='Guadeloupe'>Guadeloupe</option>
<option value='Guam'>Guam</option>
<option value='Guatemala'>Guatemala</option>
<option value='Guinea'>Guinea</option>
<option value='Guinea-bissau'>Guinea-bissau</option>
<option value='Guyana'>Guyana</option>
<option value='Haiti'>Haiti</option>
<option value='Heard Island and Mcdonald Islands'>Heard Island and Mcdonald Islands</option>
<option value='Holy See (Vatican City State)'>Holy See (Vatican City State)</option>
<option value='Honduras'>Honduras</option>
<option value='Hong Kong'>Hong Kong</option>
<option value='Hungary'>Hungary</option>
<option value='Iceland'>Iceland</option>
<option value='India'>India</option>
<option value='Indonesia'>Indonesia</option>
<option value='Iran, Islamic Republic of'>Iran, Islamic Republic of</option>
<option value='Iraq'>Iraq</option>
<option value='Ireland'>Ireland</option>
<option value='Israel'>Israel</option>
<option value='Italy'>Italy</option>
<option value='Jamaica'>Jamaica</option>
<option value='Japan'>Japan</option>
<option value='Jordan'>Jordan</option>
<option value='Kazakhstan'>Kazakhstan</option>
<option value='Kenya'>Kenya</option>
<option value='Kiribati'>Kiribati</option>
<option value='Korea, Democratic People's Republic of'>Korea, Democratic People's Republic of</option>
<option value='Korea, Republic of'>Korea, Republic of</option>
<option value='Kuwait'>Kuwait</option>
<option value='Kyrgyzstan'>Kyrgyzstan</option>
<option value='Lao People's Democratic Republic'>Lao People's Democratic Republic</option>
<option value='Latvia'>Latvia</option>
<option value='Lebanon'>Lebanon</option>
<option value='Lesotho'>Lesotho</option>
<option value='Liberia'>Liberia</option>
<option value='Libyan Arab Jamahiriya'>Libyan Arab Jamahiriya</option>
<option value='Liechtenstein'>Liechtenstein</option>
<option value='Lithuania'>Lithuania</option>
<option value='Luxembourg'>Luxembourg</option>
<option value='Macao'>Macao</option>
<option value='Macedonia, The Former Yugoslav Republic of'>Macedonia, The Former Yugoslav Republic of</option>
<option value='Madagascar'>Madagascar</option>
<option value='Malawi'>Malawi</option>
<option value='Malaysia'>Malaysia</option>
<option value='Maldives'>Maldives</option>
<option value='Mali'>Mali</option>
<option value='Malta'>Malta</option>
<option value='Marshall Islands'>Marshall Islands</option>
<option value='Martinique'>Martinique</option>
<option value='Mauritania'>Mauritania</option>
<option value='Mauritius'>Mauritius</option>
<option value='Mayotte'>Mayotte</option>
<option value='Mexico'>Mexico</option>
<option value='Micronesia, Federated States of'>Micronesia, Federated States of</option>
<option value='Moldova, Republic of'>Moldova, Republic of</option>
<option value='Monaco'>Monaco</option>
<option value='Mongolia'>Mongolia</option>
<option value='Montserrat'>Montserrat</option>
<option value='Morocco'>Morocco</option>
<option value='Mozambique'>Mozambique</option>
<option value='Myanmar'>Myanmar</option>
<option value='Namibia'>Namibia</option>
<option value='Nauru'>Nauru</option>
<option value='Nepal'>Nepal</option>
<option value='Netherlands'>Netherlands</option>
<option value='Netherlands Antilles'>Netherlands Antilles</option>
<option value='New Caledonia'>New Caledonia</option>
<option value='New Zealand'>New Zealand</option>
<option value='Nicaragua'>Nicaragua</option>
<option value='Niger'>Niger</option>
<option value='Nigeria'>Nigeria</option>
<option value='Niue'>Niue</option>
<option value='Norfolk Island'>Norfolk Island</option>
<option value='Northern Mariana Islands'>Northern Mariana Islands</option>
<option value='Norway'>Norway</option>
<option value='Oman'>Oman</option>
<option value='Pakistan'>Pakistan</option>
<option value='Palau'>Palau</option>
<option value='Palestinian Territory, Occupied'>Palestinian Territory, Occupied</option>
<option value='Panama'>Panama</option>
<option value='Papua New Guinea'>Papua New Guinea</option>
<option value='Paraguay'>Paraguay</option>
<option value='Peru'>Peru</option>
<option value='Philippines'>Philippines</option>
<option value='Pitcairn'>Pitcairn</option>
<option value='Poland'>Poland</option>
<option value='Portugal'>Portugal</option>
<option value='Puerto Rico'>Puerto Rico</option>
<option value='Qatar'>Qatar</option>
<option value='Reunion'>Reunion</option>
<option value='Romania'>Romania</option>
<option value='Russian Federation'>Russian Federation</option>
<option value='Rwanda'>Rwanda</option>
<option value='Saint Helena'>Saint Helena</option>
<option value='Saint Kitts and Nevis'>Saint Kitts and Nevis</option>
<option value='Saint Lucia'>Saint Lucia</option>
<option value='Saint Pierre and Miquelon'>Saint Pierre and Miquelon</option>
<option value='Saint Vincent and The Grenadines'>Saint Vincent and The Grenadines</option>
<option value='Samoa'>Samoa</option>
<option value='San Marino'>San Marino</option>
<option value='Sao Tome and Principe'>Sao Tome and Principe</option>
<option value='Saudi Arabia'>Saudi Arabia</option>
<option value='Senegal'>Senegal</option>
<option value='Serbia and Montenegro'>Serbia and Montenegro</option>
<option value='Seychelles'>Seychelles</option>
<option value='Sierra Leone'>Sierra Leone</option>
<option value='Singapore'>Singapore</option>
<option value='Slovakia'>Slovakia</option>
<option value='Slovenia'>Slovenia</option>
<option value='Solomon Islands'>Solomon Islands</option>
<option value='Somalia'>Somalia</option>
<option value='South Africa'>South Africa</option>
<option value='South Georgia and The South Sandwich Islands'>South Georgia and The South Sandwich Islands</option>
<option value='Spain'>Spain</option>
<option value='Sri Lanka'>Sri Lanka</option>
<option value='Sudan'>Sudan</option>
<option value='Suriname'>Suriname</option>
<option value='Svalbard and Jan Mayen'>Svalbard and Jan Mayen</option>
<option value='Swaziland'>Swaziland</option>
<option value='Sweden'>Sweden</option>
<option value='Switzerland'>Switzerland</option>
<option value='Syrian Arab Republic'>Syrian Arab Republic</option>
<option value='Taiwan, Province of China'>Taiwan, Province of China</option>
<option value='Tajikistan'>Tajikistan</option>
<option value='Tanzania, United Republic of'>Tanzania, United Republic of</option>
<option value='Thailand'>Thailand</option>
<option value='Timor-leste'>Timor-leste</option>
<option value='Togo'>Togo</option>
<option value='Tokelau'>Tokelau</option>
<option value='Tonga'>Tonga</option>
<option value='Trinidad and Tobago'>Trinidad and Tobago</option>
<option value='Tunisia'>Tunisia</option>
<option value='Turkey'>Turkey</option>
<option value='Turkmenistan'>Turkmenistan</option>
<option value='Turks and Caicos Islands'>Turks and Caicos Islands</option>
<option value='Tuvalu'>Tuvalu</option>
<option value='Uganda'>Uganda</option>
<option value='Ukraine'>Ukraine</option>
<option value='United Arab Emirates'>United Arab Emirates</option>
<option value='United Kingdom'>United Kingdom</option>
<option value='United States'>United States</option>
<option value='United States Minor Outlying Islands'>United States Minor Outlying Islands</option>
<option value='Uruguay'>Uruguay</option>
<option value='Uzbekistan'>Uzbekistan</option>
<option value='Vanuatu'>Vanuatu</option>
<option value='Venezuela'>Venezuela</option>
<option value='Viet Nam'>Viet Nam</option>
<option value='Virgin Islands, British'>Virgin Islands, British</option>
<option value='Virgin Islands, U.S.'>Virgin Islands, U.S.</option>
<option value='Wallis and Futuna'>Wallis and Futuna</option>
<option value='Western Sahara'>Western Sahara</option>
<option value='Yemen'>Yemen</option>
<option value='Zambia'>Zambia</option>
<option value='Zimbabwe'>Zimbabwe</option>
</select></td>

<td colspan='1' align='center'><input type='text' name='city' id='city' ></td></tr>

<tr><td colspan='2'><b>Adress:</b></td></tr>
<tr><td colspan='2'><input type='text' name='adress' id='adress'></td></tr>
<tr><td colspan='2'><b>Zip Code:</b></td></tr>

<tr><td colspan='2'><input type='text' name='zip_code' id='zip_code'></td></tr>

<tr><td colspan='1' width='200px' align='center'><b>Project Stage:</b></td><td colspan='1' width='200px' align='center'><b>Project Time Frame:</b></td></tr>

<tr><td colspan='1' width='200px' align='center'><select name='stage' id='stage'>
<option value='Ready to Hire'>Ready to Hire</option>
<option value='Planning and Budgeting'>Planning and Budgeting</option>
</select></td>

<td colspan='1' width='200px' align='center'><select name='time' id='time'>
<option value='Emergency Service Call'>Emergency Service Call</option>
<option value='0-2 Weeks'>0-2 Weeks</option>
<option value='3-4 Weeks'>3-4 Weeks</option>
<option value='1-2 Months'>Planning and Budgeting</option>
<option value='3+ Months'>Planning and Budgeting</option>
</select></td></tr>

<tr><td colspan='2' align='center'><b>Maximum number of bids desired: </b></td></tr>

<tr><td colspan='2' align='center'><select name='bid_number' id='bid_number'>
<option value='5'>5</option>
<option value='7'>7</option>
<option value='10'>10</option>
<option value='15'>15</option>
<option value='No Limit'>No Limit</option>
</select></td></tr>

<tr><td colspan='2' align='center'><input type='submit' name='submit' id='submit' value='Post Project' /> </td></tr>
<input type='hidden' name='hidden' value='1' />
</form>
</table>
";

slideR · 28 Февруари 2010

<?php
session_start();
include 'common.php';

$category = $_POST['category'];
$sub_category = $_POST['sub_category'];
$task = $_POST['task'];
$title = $_POST['title'];
$description = $_POST['description'];
$country = $_POST['country'];
$city = $_POST['city'];
$zip_code = $_POST['zip_code'];
$adress = $_POST['adress'];
$stage = $_POST['stage'];
$time = $_POST['time'];
$bid_number = $_POST['bid_number'];

$insert = "INSERT INTO projects (`category`,`sub_category`,`task`,`title`,`description`,`country`,`city`,`zip_code`,`adress`,stage,time,bid_number)
VALUES ('$category','$sub_category','$task','$title','$description','$country','$city','$zip_code','$adress','$time','$stage','$bid_number')";

$result = mysql_query($insert) or die(mysql_error());

?>

Това е вече правилно :?:

Nihtewalk · 28 Февруари 2010

Пффф де съм спал и аз

Така е добре,благодаря :?:

Проблем с AJAX заявка

Nihtewalk

Registered

slideR

Registered

Nihtewalk

Registered

slideR

Registered

Nihtewalk

Registered

slideR

Registered

Nihtewalk

Registered

slideR

Registered

Nihtewalk

Registered