Loading ...
Sorry, an error occurred while loading the content.
 

Re: [phpResource] Re: php form ajax help

Expand Messages
  • Mohamed BADR
    no it s not the same this case is different Mohamed BADR Senior Web/Database developer PHP/MySql/ Oracle - ASP.NET/SQL - multimedia OMEGA SOFT 0102050009 ...
    Message 1 of 5 , Oct 11, 2006
      no it's not the same
      this case is different
       
      Mohamed BADR
      Senior Web/Database developer
      PHP/MySql/ Oracle  -  ASP.NET/SQL - multimedia
      OMEGA SOFT
      0102050009
      ----- Original Message -----
      Sent: Tuesday, October 10, 2006 10:44 AM
      Subject: [phpResource] Re: php form ajax help

      Hey,

      You might want to try your own example which is under Files section,
      Dynamic_List_ Populate_ php_oracle_ By_AJAX.zip.

      Thanks,

      Ehsan

      --- In phpresource@ yahoogroups. com, "Mohamed BADR" <badr@...> wrote:
      >
      > hi guys i have a form where the user have a list/menu that get the
      type of certificate from the database like that
      >
      >
      > <SELECT name="SEC_CERT_ CODE" id="SEC_CERT_ CODE" >
      >
      > <?php
      > $query = "SELECT SEC_CERT_NAME, SEC_CERT_CODE FROM ACD_SEC_CERT
      where MALE_FEMALE= '1'";
      >
      > $statement = oci_parse ($conn, $query);
      > oci_execute ($statement) ;
      >
      > while ($row = oci_fetch_array ($statement, OCI_NUM)) {
      > print("<option value=\"" . $PHP_SELF . "?SEC_CERT_CODE= " . $row[1]
      . "\"");
      > ?><option value="<? echo $row[1]; ?>">
      > <? echo $row[0] ?> </option>
      > <? }
      > ?></select>
      >
      > after the user select the certificate it should select the total
      points of that certificate from the same table and put it in a textbox
      >
      > <input name="SEC_CERT_ TOTAL" type="text" id="SEC_CERT_ TOTAL"
      size="10" />
      >
      > USING THIS QUERY
      >
      > select SEC_CERT_TOTAl from acd_sec_cert where
      sec_cert_code= $SEC_CERT_ CODE
      >
      > how can i do that without reloading the page, i need some help in
      this form please
      >
      > thnx
      >
      >
      >
      > Mohamed BADR
      >

    • zav_123
      hey, i think that u have a list box and a text box in ur form. u want to get the list box from database.after assigning list boxe s value when u select one
      Message 2 of 5 , Oct 11, 2006
        hey,

        i think that u have a list box and a text box in ur form.
        u want to get the list box from database.after assigning list boxe's
        value when u select one option then the corresponding value will
        assign in the text box,is it right?
        if u want that then use another page(php page) only for sending list
        boxe's value.in that page get the list boxe's value and retrieve
        data from the table and print the data.in the form page get the
        printed data and with DOM assign it in the text box.
        if u have already done this processs then try another way and if u
        haven't then follow this process.
        this is ajax related problem.

        take care.

        zav
        Software Engineer.
        Tokyo,Japan


        > --- In phpresource@yahoogroups.com, "Mohamed BADR" <badr@> wrote:
        > >
        > > hi guys i have a form where the user have a list/menu that get
        the
        > type of certificate from the database like that
        > >
        > >
        > > <SELECT name="SEC_CERT_CODE" id="SEC_CERT_CODE" >
        > >
        > > <?php
        > > $query = "SELECT SEC_CERT_NAME, SEC_CERT_CODE FROM ACD_SEC_CERT
        > where MALE_FEMALE= '1'";
        > >
        > > $statement = oci_parse ($conn, $query);
        > > oci_execute ($statement);
        > >
        > > while ($row = oci_fetch_array ($statement, OCI_NUM)) {
        > > print("<option value=\"" . $PHP_SELF . "?SEC_CERT_CODE=" . $row
        [1]
        > . "\"");
        > > ?><option value="<? echo $row[1]; ?>">
        > > <? echo $row[0] ?> </option>
        > > <? }
        > > ?></select>
        > >
        > > after the user select the certificate it should select the
        total
        > points of that certificate from the same table and put it in a
        textbox
        > >
        > > <input name="SEC_CERT_TOTAL" type="text" id="SEC_CERT_TOTAL"
        > size="10" />
        > >
        > > USING THIS QUERY
        > >
        > > select SEC_CERT_TOTAl from acd_sec_cert where
        > sec_cert_code=$SEC_CERT_CODE
        > >
        > > how can i do that without reloading the page, i need some help
        in
        > this form please
        > >
        > > thnx
        > >
        > >
        > >
        > > Mohamed BADR
        > >
        >
      • Mohamed BADR
        sending list boxe s value.in that page get the list boxe s value and retrieve data from the table and print the data.in the form page get the printed data
        Message 3 of 5 , Oct 12, 2006
          "sending list  boxe's value.in that page get the list boxe's value and retrieve
          data from the table and print the data.in the form page get the
          printed data and with DOM assign it in the text box."
           
          that's what i am asking about , how can i do that in the simplest way !!! is there some simple tutorials or sample code i can use ??
          thanks
           
           

          Mohamed BADR
          ----- Original Message -----
          From: zav_123
          Sent: Wednesday, October 11, 2006 6:33 PM
          Subject: [phpResource] Re: php form ajax help


          hey,

          i think that u have a list box and a text box in ur form.
          u want to get the list box from database.after assigning list boxe's
          value when u select one option then the corresponding value will
          assign in the text box,is it right?
          if u want that then use another page(php page) only for sending list
          boxe's value.in that page get the list boxe's value and retrieve
          data from the table and print the data.in the form page get the
          printed data and with DOM assign it in the text box.
          if u have already done this processs then try another way and if u
          haven't then follow this process.
          this is ajax related problem.

          take care.

          zav
          Software Engineer.
          Tokyo,Japan

          > --- In phpresource@ yahoogroups. com, "Mohamed BADR" <badr@> wrote:
          > >
          > > hi guys i have a form where the user have a list/menu that get
          the
          > type of certificate from the database like that
          > >
          > >
          > > <SELECT name="SEC_CERT_ CODE" id="SEC_CERT_ CODE" >
          > >
          > > <?php
          > > $query = "SELECT SEC_CERT_NAME, SEC_CERT_CODE FROM ACD_SEC_CERT
          > where MALE_FEMALE= '1'";
          > >
          > > $statement = oci_parse ($conn, $query);
          > > oci_execute ($statement) ;
          > >
          > > while ($row = oci_fetch_array ($statement, OCI_NUM)) {
          > > print("<option value=\"" . $PHP_SELF . "?SEC_CERT_CODE= " . $row
          [1]
          > . "\"");
          > > ?><option value="<? echo $row[1]; ?>">
          > > <? echo $row[0] ?> </option>
          > > <? }
          > > ?></select>
          > >
          > > after the user select the certificate it should select the
          total
          > points of that certificate from the same table and put it in a
          textbox
          > >
          > > <input name="SEC_CERT_ TOTAL" type="text" id="SEC_CERT_ TOTAL"
          > size="10" />
          > >
          > > USING THIS QUERY
          > >
          > > select SEC_CERT_TOTAl from acd_sec_cert where
          > sec_cert_code= $SEC_CERT_ CODE
          > >
          > > how can i do that without reloading the page, i need some help
          in
          > this form please
          > >
          > > thnx
          > >
          > >
          > >
          > > Mohamed BADR
          > >
          >

        Your message has been successfully submitted and would be delivered to recipients shortly.