Select and insert using php mysql?

Question

<?php
include "conection.php"; 

$checknumber=mysql_fetch_array(mysql_query("SELECT MAX( number ) FROM tqueue WHERE get_ticket >= CURDATE( ) GROUP BY services"));

 $one=$_GET['services'];
 $two=$_GET['services_abjact'];
 $three=1+(int)$checknumber;

 $query="INSERT INTO tqueue (services, services_abjact, number) values ('$one', '$two','$three')";
 $exe=mysql_query($query);

  echo"<a href='index.php'>Input again</a></br>";
?>

i want to input link like this http://localhost/pehape/input.php?services=1&services_abjact=A&submit=save

When I input that link I'll get sequential number of queue with using +1 in $three or number column but I'm still failing in result please help me

I want result in number column something like this table

-----------------------------------------------------------
 services   |   services abjact  | number   |  get_ticket
-----------------------------------------------------------
     1                   A            12           21:04:24
     1                   A            11           20:00:00
     1                   A            10           19:02:40
     1                   A            9            18:36:01
     1                   A            8            18:01:00
     1                   A            7            17:45:30
     1                   A            6            16:50:20
     1                   A            5            16:34:56
     1                   A            4            16:03:04
     1                   A            3            15:00:00
     1                   A            2            11:56:00
     1                   A            1            09:12:34

Every time you use the mysql_ database extension in new code a Kitten is strangled somewhere in the world it is deprecated and has been for years and is gone for ever in PHP7. If you are just learning PHP, spend your energies learning the PDO or mysqli database extensions. Start here — RiggsFolly
– RiggsFolly, Commented Jan 2, 2017 at 15:15
Your script is at risk of SQL Injection Attack Have a look at what happened to Little Bobby Tables Even if you are escaping inputs, its not safe! Use prepared parameterized statements — RiggsFolly
– RiggsFolly, Commented Jan 2, 2017 at 15:16
I really think PhP community should do something about the mysql_* pages and add a red alert div to prevent people from using this library. — Anwar
– Anwar, Commented Jan 2, 2017 at 15:23
no, i'm not, when the power of electricity down i'll be the same and had limit for queue — Heri
– Heri, Commented Jan 2, 2017 at 15:36

Mehedee · Accepted Answer · 2017-01-02 15:45:51Z

3

mysql_fetch_array() returns array not string. Here is reference http://php.net/manual/en/function.mysql-fetch-array.php

In your case: $three = 1 + (int)$checknumber[0]['number']; Or you can use while or foreach loop.

You could set auto incremental column in your database. Also you should use PDO or MYSQLi.

answered Jan 2, 2017 at 15:45

Mehedee

3362 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Select and insert using php mysql?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related