mysql - Edit database row from php page -

-

i have 2 php pages. - first 1 has form insert data in database. - second diplays data of database.

how i, conceptually, adding each row button "update", allow me change of value of row (in exemple value of 2 dropdownlist) , update info in database well.

this code able looking in internet , have 2 problems: first, working second update button (so second row updated). second, changes not reflected dropdowlist. (means if change second row value database updated not dropdownlist).

note implemented 2 columns 

<td>" . $row['status'] . "</td> <td>" . $row['priority'] . "</td>

only check value in database changes.

    <form method="post" action="job-status.php">            <?php      include("../includes/connection.php");          if($link->connect_errno > 0){             die('unable connect database [' . $link->connect_error . ']');         }          if(isset($_post['update'])) {            $results = $link->query("update job set status='$_post[status]',          priority='$_post[priority]' id='$_post[hidden]'");          }                $sql = "select * job";         if(!$result = $link->query($sql)){             die('there error running query [' . $link->error . ']');         }         echo "     <table class='table'>         <thead>             <tr>";         /* field information columns */         while ($finfo = $result->fetch_field()) {             echo "             <th>" . $finfo->name . "</th>";         }         echo "             </tr>         </thead>         <tbody>";         while($row = $result->fetch_assoc()){        echo "<tr class='info'>                      <td>" . $row['id'] . "</td>                      <td>" . $row['device'] . "</td>                     <td>" . $row['model'] . "</td>                      <td>" . $row['problem'] . "</td>                     <td><select class='form-control col-sm-10' id='status' name='status'>                          <option value='new'>new</option>                          <option value='progress'>progress</option>                          <option  value='wait'>wait</option>                          <option value='done'>done</option>                          <option value='close'>close</option>                    </select></td>                      <td><select class='form-control col-sm-10' id='priority' name='priority'>                      <option value='high'>high</option>                          <option value='medium'>medium</option>                      <option  value='low'>low</option>                      </select></td>                         <td>" . $row['status'] . "</td>                        <td>" . $row['priority'] . "</td>                     <input type=hidden name=hidden value=" . $row['id'] . ">  <td><button type='submit' class='btn btn-primary btn-sm' name='update'>update</button></td>  <td> <a class='btn btn-primary btn-sm'  data-toggle='modal' data-target='#mymodal'>info</a></td>                 </tr>";          }          echo "         </tbody>   </table>";  ?>    </form>

enter image description here

you can use td each row of table:

"<td>" . $row['name'] . '</td><td><a href="link">edit</a>' . "</td>"

the link link controller, in case sing mvc pattern, , can pass id of que row want delete. mean somethig like:

"<td>" . $row['name'] . "</td><td><a href='clientes/editar?id=" . $row['id'] . "'>edit</a> . "</td>"

this way can edit row clicking "edit" link. remember implement in controller logic updating row specific id. purpose can use orm wich can database access.


Comments

Post a Comment

Popular posts from this blog

github - Git errors while pushing -

-
Image
i input "git add -a" , gives me error: "fatal: unknown index entry format 65540000". i looked every other sources , not figure out means. then, tried pushing using sourcetree , got error below: all added codes , few imagefiles. not sure causing problem. last commit did month ago, btw. first commit after upgraded xcode 7.0 version. thanks this first commit after upgraded xcode 7.0 version then try clone again repo xcode7, , add change in new local repo. should work better in clone entirely managed new xcode.
Read more

php - Using grpc in Laravel, "Class 'Grpc\ChannelCredentials' not found." -

-
i trying use grpc in laravel project. this part of composer.json file: "require": { ... "datto/protobuf-php": "dev-master", "google/auth": "^0.7.0", "grpc/grpc": "dev-release-0_13", ... } i have generated php file proto file. placed in app/services/ , included in composer.json autoload.files section. have run composer install without issues. i have created route testing. has following code: $client = new vat_service\vatserviceclient('localhost:50051', [ 'credentials' => grpc\channelcredentials::createinsecure() ]); but receive response class 'grpc\channelcredentials' not found. when visit route. the laravel app running in homestead vagrant box. i don't know how proceed. missing dependency? did miss install something? i have solved problem, not sure of below steps solution. things tried: i installed grpc-beta in homestead box (...
Read more

c++ - How can I delete a QSharedPointer -

-
i have written wrapper around qtextedit use qiodevice. want able use multiple wrapper same qtextedit, may use different text color each wrapper. to make wrapper thread-safe added qmutex protect usage of qtextedit. thinking must use 1 mutex protect 1 qtextedit. i end following implementation, using qsharedpointer protect qtextedit. texteditiodevice.h class texteditiodevice : public qiodevice { q_object public: texteditiodevice(qtextedit * qtextedit, qcolor color, qobject * parent); virtual ~texteditiodevice(); protected: qint64 readdata(char *data, qint64 maxlen); qint64 writedata(const char *data, qint64 len); private: /** * @brief pointer qtextedit */ qpointer<qtextedit> textedit; /** * @brief text color */ qcolor color; /** * @brief shared pointer qtextedit associated mutex */ qsharedpointer<qmutex> mutex; /** * @brief storage qtextedit associated mutexes */ sta...
Read more