Questions tagged as 'sql'

Tagged questions
1
answer

Security of a form that sends to a controller the name of the table of the database that he has to use

I have a form that sends the following information to the controller: <form method="GET" action="index.php"> <input type="hidden" name="nombreTabla" value="Colegios"> <input type="text" name="alumnoID"> <input...
asked by 18.04.2018 / 19:19
0
answers

Notice: Undefined variable: userid in

I'm running a code but it marks these errors:    Notice: Undefined variable: userid in   C: \ xampp \ htdocs \ Edu \ profile.php on line 69       Notice: Undefined variable: followerid in   C: \ xampp \ htdocs \ Edu \ profile.php on line 69...
asked by 06.04.2018 / 07:16
1
answer

Add the value of each period and put 0 in the periods that do not exist in SQL Query table

I have two Income and Periods tables, within the Periods table are the months from January to February and in Income I have a value_port column in which there are records for what has been contributed in each month. ex. Ingresos Periodo Valor_...
asked by 06.04.2018 / 23:02
2
answers

My page does not connect to my database

I try to connect to my database in the following way: mysql_connect($server, $user, $pass); mysql_select_db($db); I know that mysql is obsolete but how I use an old version xampp should work. However, my page never ends up loading and is al...
asked by 01.05.2018 / 13:55
1
answer

C # insert data null

You could support me I'm new, I'm migrating data from Oracle to SQL server but the problem is that I'm trying to insert data and everything was fine, until I came up with the following: When inserting the data there are null fields and I do not...
asked by 15.04.2018 / 09:46
0
answers

Checking PHP users by name and by id

I am creating a web application in which I need to be able to register a specific type of users in which the name can be repeated but the id they have assigned does not. The table in which they are stored has the following structure: user_id int...
asked by 31.03.2018 / 21:13
2
answers

How can I rename a database on android?

What happens is that at the beginning The database name without the extension ".db" and when reviewing data does not appear but if I create a new one with the extension ".db" if it appears, this is uncomfortable because I can not see what is hap...
asked by 27.03.2018 / 16:03
0
answers

Enter data in a table, from another table

I am creating a PHP logeo system, and so far the registration table works perfectly. Registry has attributes such as the auto-incremented id, the user, the password and the email. I need to create another table called levels, since the purpos...
asked by 17.03.2018 / 02:45
0
answers

Why does it fail to add row in Mysql?

I have an android application connected by webservice to a database in Mysql, when I add rows to an already created table I get to number 12 and from there it does not let me add more, since when I open the application to see that data , they do...
asked by 16.03.2018 / 22:08
1
answer

Unwanted format in Datetime parameter (Stored procedure)

I built a procedimiento almacenado that has two parameters type date . The problem is that these dates come to me with the format    NameMes Day Year Time: Minute AM for example if I send you the date '2017-02-05' comes to...
asked by 15.03.2018 / 16:15