php - If searched number exists in MySQL database, go to a certain link -


I have a company where we issue invoices to people, then with this "ticket number" and "date" Upload an invoice

I think logging is quite simple, but my brain wraps around MySQL and I can not find the tutorial for it

I have a form like this Which works like a search, where it takes "search ticket number" and it "goes ahead .php"

If the ticket Khya has been found in my database and the date of the ticket number submitted is less than 72 hours of the present time, the date and time I have submitted, Goto Link A, if more than 72 hours Goto Link B, If the search is not able to find anything in the Goto link,

I hope anyone write it for me if this is complicated but maybe I should give instructions for the tutorial that I want to I am Or tell me what I want to find in However, if you think that this script is enough for me then I can see what I should have done that would be very appreciated.

Now I have gone ahead. Php file: 

   
 My preferred method of creating questions is a prepared statement, this is the safest way. It is recommended that you look at another up-to-date approach to talking to SQL (Mysore's tenure these days Quite a favor in favor of In the minimum, you should "save" the strings given by your user:  $ user = "data1"; $ database = "data"; $ mysqli = new mysqli ( "Localhost", $ username, $ password, $ database); // If this is a string, do this // // ticket number = $ mysqli- & gt; real_cape_string ($ _ POST ['ticket number ']); // Because it should be an integer, we can do better: $ ticketNumber = intval ($ _POST [' ticket number ']); $ Rinam = $ mysqli- & gt; query ( "select plate WHERE ticket, number = $ ticket number"); if (! $ Result & gt; Num_rows) {header ("location: /scriptC.php"); Die (); } $ Ticket = $ Result-> Fetch_assoc (); $ Tickettime = strottetime ($ ticket ['date']); $ Requesttime = strotomat ($ _ POST ['date']); If (($ Request Time - $ Ticket Time) & lt; 72 * 60 * 60) {Header ("Location: / Scripte.F.P."); Die (); } Header ("Location: /scriptb.php"); Die (); $ Mysqli- & gt; near ();

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