Checkbox, PHP & SQL -


I have a checkbox in my code that tells the user that the record < Strong> has been or not done . When the user searches a record in the database, the recorded record appears with the current record status ( complete or not ).

If the checkbox is not checked then it means that the record is not not , so I am trying to install a checkbox on one side of the record state so that the user After checking the checked checkbox checked on the check box, the value is sent to DB that the new status of the record is done

How can I do this when the following example code: (W Ryokta are shown after a search using a form) 

  & lt ;? Php if (! Isset ($ _ POST ['search'])) {? & Gt; & Lt ;? Php} other {$ to = trim ($ _ POST ['old']); $ = = Trim ($ _ POST ['NEW']); $ Position = release ($ _ POST ['status'])? "And condition = 'full':" and condition = 'no' ''; $ Connection = mysql_pconnect ("HOST", "USER", "PASS") or die ("Connection failure.". Myslq_error ()); Mysql_select_db ("DBNAME") or die ("Unable to choose db." Mysql_error ()); $ Query = "SELECT *" from the dates where date & gt; = '$ s' and date & lt; = '$ by' ". $ Position "ASC from order date"; $ Result = mysql_query ($ query) or die (mysql_error ()); Echo "& lt; table class = 'table' id = 'searchResult' cell area = '0' cellpadding = '0' & gt;"; Echo "& lt; tr class = 'rowa'">  "; Echo "& lt; td class = 'col0 cell' & gt; id & lt; / td & gt;"; Echo "& lt; td class = 'col1 cell' & gt; name & lt; / td & gt;"; Echo "& lt; td class = 'col2 cell' & gt; last name & lt; / td & gt;"; Echo "& lt; td class = 'col3 cell' & gt; Place & lt; / td & gt;"; Echo "& lt; td class = 'col4 cell' & gt; station & lt; / td & gt;"; Echo "& lt; td class = 'col5 cell' & gt; phone & lt; / td & gt;"; Echo "& lt; td class = 'col6 cell' & gt; Record date & lt; / td & gt;"; Echo "& lt; td class = 'col7 cell' & gt; status & lt; / td & gt;"; Echo "& lt; / tr & gt;"; Echo "& lt; / table & gt;"; While ($ record = mysql_fetch_object ($ result)) {resonant "table table = 'table' id = 'searchResult' cell field = '0' cellpadding = '0'>; Echo "& lt; tr class = 'rowb' & gt;"; Echo "& lt; td class = 'col0 cell' & gt; $ Record-> Id. "& Lt; / td>"; Echo "& lt; td class = 'col1 cell' & gt; $ Record-> Name. "& Lt; / td>"; Echo "& lt; td class = 'col2 cell' & gt; $ Record-> last name. "& Lt; / td>"; Echo "& lt; td class = 'col3 cell' & gt; $ Record-> Place. "& Lt; / td>"; Echo "& lt; td class = 'col4 cell' & gt; $ Record-> station. "& Lt; / td>"; Echo "& lt; td class = 'col5 cell' & gt; $ Record-> Phone "& Lt; / td>"; $ Year_part_of_date = Explosion ('-', $ record-> Date); Echo "& lt; td class = 'col6 cell' & gt; $ Record-> Date "& Lt; / td>"; Echo "& lt; td class = 'col7 cell' & gt; $ Record-> Event. "& Lt; / td>"; Echo "& lt; / tr & gt;"; Echo "& lt; / table & gt;"; }}? & Gt;   
 
  
 Thanks for showing me all the way: D  
 
 
 You mean, this way?  
  echo "& lt; td class = 'col7 cell' & gt; & lt; input type = 'checkbox' name = 'status'". ($ Record-> position == 'complete'? 'Check': ''). "/> Gt; ";

Comments

Post a Comment

Popular posts from this blog

Python SQLAlchemy：AttributeError: Neither 'Column' object nor 'Comparator' object has an attribute 'schema' -

I tried to create a new database in my project, but when I run the script, I get this error, I have another project, this type of definition worked before, but now it gets a single error. I am using Python 2.7.8 and the version of SQLAlchemy module is 0.9.8. By the way, using a project flask- SQLAlchemy, it works well, I'm confused. Traceback information is as follows: Traceback (most recent call final): File "D: / Projects / IOM / db_create.py", line 4, & lt; Module & gt; From the models the base file "D: \ Projects \ OO-IM \ models.py", in line 15, in the & lt; Module & gt; Column ( 'followed_id', int (), ForeignKey ( 'user.id')) file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ schema.py", line 369, __new__ schema = metadata. Schema file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ elements.py", line 662, AttributeError in __getattr__ key): Neither 'column' object nor ...
Read more

java - How not to audit a join table and related entities using Hibernate Envers? -

I use Eners to be hibernate to audit my institutions. I have an audit entity, Foo , which includes a list & lt; Bars & gt; However, I do not want to audit the bar institutions, in the form of properties, I have written that: @inti @edicated public class Foo {@JoinTable (name = "T_FOO_BAR", joinColumns = @JoinColumn (name = "FOO_ID"), inverseJoinColumns = @JoinColumn (Name = "BAR_ID")) @ManyToMany (Cascade = Persist) @ Indited (targetAuditMode = RelationTargetAuditMode.NOT_AUDITED ) Public listing & lt; Bars & gt; GetBars () {Return bars; }} Now, I want to retrieve an amendment of foo : AuditReader reader = AuditReaderFactory.get (GetEntityManager ()); FU modification = (FU) reader.CreativeTeA () .entensEtrevision (Foo Class, 42) .getSingleResult (); Unfortunately, when I want to retrieve all the data (i.e. when it loads lazy times ), error me ORA-00942: table or view is not present , because Tried to query this: Sel...
Read more

mongodb - CakePHP paginator ignoring order, but only for certain values -

While pagging my user model in kppp, I can sort with some values, but not others. For example, I can order results from created or email , for example, but username or reputation seems to come back order by arbitrary command for example with a list of users: $ this-> paginate = array ('condition' => array ( 'User.is_active' = & gt; true), 'border' => 24, 'order' => array ('User.created' => DESC)); Works as expected, but $ this - & gt; Paged = array ('conditions' = & gt; array (' user.isIactive '= & gt; true),' border '= & gt; 24,' command '= & gt; array (' user repeats' = ' & Gt; DESC ')); No, no. I first thought that this could be a database issue, but when I search the database directly, sorted as expected. Note: I am using Mangodebi with the Mongo DB plugin of Ichikawa for the KPPHP; Pagnetizing users are used to work properl...
Read more