开发者

drop down data to appear in form php

I have some data in db,now i m making them to display 开发者_运维百科in the front end so,i ii have a update button,if i click it the selected values to come to database

dpaste.com/hold/180863

Thnx in advance.


Chk does your query is giving you any output, here :$result = mysql_query("SELECT FROM customers");

echo ur query and paste in ur SQL query panel of ur PHPmyadmin. see do u get any value or not? if it does not then ur query is incorrect

u have not ended with proper tag here:

<? php


?>

"?>"

UPDATED

<?php 

$result = mysql_query("SELECT * FROM Customer"); while($row = mysql_fetch_assoc($result)){ echo "Name: ".$row['0'].", Address:".$row['1'] .", City:".$row['city'].", pincode:".$row['pincode'].", State:".$row['state'].", Country:".$row['country'].", Phone:".$row['phone'].", Mobile:".$row['mobile'].", Fax:".$row['fax'].", Email:".$row['email'].", Website:".$row['url'].", Notes:".$row['notes']."; 

?>

u didnt put the ">" at the end in script u refrenced to

UPDATED

DAF, your url : http://localhost/up.php?customer=aaaaa,sssssssssssssss,aaaaaaa,22222Andhra+Pradesh,in,2222221,1111111,0,v@gmail.com,, is displaying all the values posted , its being appended in the url, I need to see the complete code you are working on

UPDATED

      <html>
    <body>
    <form action="up.php">


    <?php

    // Create the connection and select the DB-->
    $con = mysql_connect("localhost","root","");

    if ($con) {
       mysql_selectdb("form",$con);

       // Select records from the DB
       $query  = "SELECT * FROM customer";
       $result = mysql_query($query);

       // Display records from the table


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

           $value = $row;

       }

    }


    ?>
       <p> 
          <label for="cname"><b>Name:</b></label>
 <em>*</em><input id="cname" name="name" size="25" class="required" value="<?php echo $value['name'];?>" minlength="5" />
                     </p> 




                  <p> 
               <label for="caddress"><b>Address:</b></label>
 <em>*</em><textarea id="caddress" name="address" cols="22" class="required" minlength="3" /><?php echo $value['address'];?></textarea>

                 </p>  


                <p>  
               <label for="ccity"><b>City/Town:</b></label>
 <em>*</em><input id="ccity" name="city" size="25" value="<?php echo $value['city'];?>" class="required" minlength="5" /> 
                  </p> 

                  <p> 
               <label for="cpincode"><b>Pincode:</b></label>
 <em>*</em><input id="cpincode" name="pincode" size="25" class="required" value="<?php echo $value['cpincode'];?>" digits="5" />

                </p> 

                <p> 
               <label for="cstate"><b>State:</b></label>


 <em>*</em><select class="state" id="cstate" name="state">
<option value=""   >Select One</option> 

                    <option <?php if($value['state'] == Andaman and Nicobar){ $selected = "selected='selected'";}else{$selected = "";} echo $selected;?>>Andaman and Nicobar</option> 
                    <option <?php if($value['state'] == Andhra Pradesh){ $selected = "selected='selected'";}else{$selected = "";} echo $selected;?>>Andhra Pradesh</option> 
                    <option <?php if($value['state'] == Arunachal Pradesh){ $selected = "selected='selected'";}else{$selected = "";} echo $selected;?>>Arunachal Pradesh</option> 
        ---
                ---
                ---- similar as above
                     </select> 

                  </p>  

                  <p> 
               <label for="ccountry"><b>Country:</b></label>

 <em>*</em><select class="country" id="ccountry" name="country"> 

// here as well do as above with $value['country']

                    <option value=""   >Select One</option> 
                    <option value="af"   >Afghanistan</option> 
                    <option value="ax"   >Aland Islands</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 Herzegovina</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="vg"   >British Virgin Islands</option> 
                    <option value="bn"   >Brunei</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"   >Cocos (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="hr"   >Croatia</option> 
                    <option value="cu"   >Cuba</option> 
                    <option value="cy"   >Cyprus</option> 
                    <option value="cz"   >Czech Republic</option> 
                    <option value="cd"   >Democratic Republic of Congo</option> 
                    <option value="dk"   >Denmark</option> 
                    <option value="xx"   >Disputed Territory</option> 
                    <option value="dj"   >Djibouti</option> 
                    <option value="dm"   >Dominica</option> 
                    <option value="do"   >Dominican Republic</option> 
                    <option value="tl"   >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</option> 
                    <option value="fo"   >Faroe Islands</option> 
                    <option value="fm"   >Federated States of Micronesia</option> 
                    <option value="fj"   >Fiji</option> 
                    <option value="fi"   >Finland</option> 
                    <option value="fr"   >France</option> 
                    <option value="gf"   >French Guyana</option> 
                    <option value="pf"   >French Polynesia</option> 
                    <option value="tf"   >French Southern Territories</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="gp"   >Guadeloupe</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 Island and Mcdonald 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"   SELECTED  >India</option> 
                    <option value="id"   >Indonesia</option> 
                    <option value="ir"   >Iran</option> 
                    <option value="iq"   >Iraq</option> 
                    <option value="xe"   >Iraq-Saudi Arabia Neutral Zone</option> 
                    <option value="ie"   >Ireland</option> 
                    <option value="il"   >Israel</option> 
                    <option value="it"   >Italy</option> 
                    <option value="ci"   >Ivory Coast</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="kw"   >Kuwait</option> 
                    <option value="kg"   >Kyrgyzstan</option> 
                    <option value="la"   >Laos</option> 
                    <option value="lv"   >Latvia</option> 
                    <option value="lb"   >Lebanon</option> 
                    <option value="ls"   >Lesotho</option> 
                    <option value="lr"   >Liberia</option> 
                    <option value="ly"   >Libya</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</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="mq"   >Martinique</option> 
                    <option value="mr"   >Mauritania</option> 
                    <option value="mu"   >Mauritius</option> 
                    <option value="yt"   >Mayotte</option> 
                    <option value="mx"   >Mexico</option> 
                    <option value="md"   >Moldova</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="nc"   >New Caledonia</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="kp"   >North Korea</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="ps"   >Palestinian Occupied Territories</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 Islands</option> 
                    <option value="pl"   >Poland</option> 
                    <option value="pt"   >Portugal</option> 
                    <option value="pr"   >Puerto Rico</option> 
                    <option value="qa"   >Qatar</option> 
                    <option value="re"   >Reunion</option> 
                    <option value="ro"   >Romania</option> 
                    <option value="ru"   >Russia</option> 
                    <option value="rw"   >Rwanda</option> 
                    <option value="sh"   >Saint Helena and Dependencies</option> 
                    <option value="kn"   >Saint Kitts and Nevis</option> 
                    <option value="lc"   >Saint Lucia</option> 
                    <option value="pm"   >Saint Pierre and Miquelon</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</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 South Sandwich Islands</option> 
                    <option value="kr"   >South Korea</option> 
                    <option value="es"   >Spain</option> 
                    <option value="pi"   >Spratly Islands</option> 
                    <option value="lk"   >Sri Lanka</option> 
                    <option value="sd"   >Sudan</option> 
                    <option value="sr"   >Suriname</option> 
                    <option value="sj"   >Svalbard and Jan Mayen</option> 
                    <option value="sz"   >Swaziland</option> 
                    <option value="se"   >Sweden</option> 
                    <option value="ch"   >Switzerland</option> 
                    <option value="sy"   >Syria</option> 
                    <option value="tw"   >Taiwan</option> 
                    <option value="tj"   >Tajikistan</option> 
                    <option value="tz"   >Tanzania</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 Arab Emirates</option> 
                    <option value="uk"   >United Kingdom</option> 
                    <option value="xd"   >United Nations Neutral Zone</option> 
                    <option value="us"   >United States</option> 
                    <option value="um"   >United States Minor Outlying Islands</option> 
                    <option value="uy"   >Uruguay</option> 
                    <option value="vi"   >US Virgin Islands</option> 
                    <option value="uz"   >Uzbekistan</option> 
                    <option value="vu"   >Vanuatu</option> 
                    <option value="va"   >Vatican City</option> 
                    <option value="ve"   >Venezuela</option> 
                    <option value="vn"   >Vietnam</option> 
                    <option value="wf"   >Wallis and Futuna</option> 
                    <option value="eh"   >Western Sahara</option> 
                    <option value="ye"   >Yemen</option> 
                    <option value="zm"   >Zambia</option> 
                    <option value="zw"   >Zimbabwe</option> 
                    <option value="rs"   >Serbia</option> 
                    <option value="me"   >Montenegro</option> 
               </select> 

                  </p> 

                 <p> 
               <label for="cphone"><b>Phone:</b></label>
 <em>*</em><input id="cphone" name="phone" size="25" value="<?php echo $value['phone'];?>" class="required" digits="4" />

                </p> 

                   <p> 
               <label for="cmobile"><b>Mobile:</b></label>
 <em>*</em><input id="cmobile" name="mobile" value="<?php echo $value['mobile'];?>" size="25" class="required" digits="4" />
                 </p> 

          <P>
               <label for="num"><b>Fax:</b></label>
 <em>&nbsp; </em ><input id="cnum" name="fax" size="25" class="num"  value="<?php echo $value['fax'];?>" digits="10"  />
                  </p>

        <p> 
               <label for="cemail"><b>Email:</b></label>
            <em>*</em><input id="cemail" name="email" size="25" value="<?php echo $value['email'];?>" class="email" />
                  </p>


                  <p> 
               <label for="curl"><b>Website:</b></label>
            <em>&nbsp; </em><input id="curl" name="url" size="25" value="<?php echo $value['url'];?>" class="url" value="" />
                  </p>



                <p> 
        <label for="cnotes"><b>Notes:</b></label>
         <em>&nbsp; </em><textarea id="cnotes" name="notes" cols="22"  class="notes" /><?php echo $value['notes'];?></textarea>
         </p> 



    <input type ="submit" value="update" />
    </body>
    </html>


you're query should be atleast

$result = mysql_query("SELECT column FROM customers")

or

$result = mysql_query("SELECT * FROM customers")
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜