The second INSERT INTO is not processed

Question

What is the point, in the assembly of denver, everything is running smoothly, but LAMPP (on Ubuntu 16.04 LTE) does not process the second request, php has set 5.6.

$result2 = mysql_query ("INSERT INTO users (login,password) 
VALUES('$login','$password')");
$result2 = mysql_query ("INSERT INTO tasters SET id=LAST_INSERT_ID()");

In the users table there is an id field with A_I, and the same field in tasters, but without A_I, both designated as INDEX. Tables are created in advance in this way:

CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` varchar(18) NOT NULL,
`password` varchar(18) NOT NULL,
`status` int(11) NOT NULL DEFAULT '3',
PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

And:

CREATE TABLE IF NOT EXISTS `tasters` (
`id` int(11) NOT NULL,
`name` varchar(32) NOT NULL,
`surname` varchar(32) NOT NULL,
`patronymic` varchar(32) NOT NULL,
`sex` int(11) NOT NULL,
`birth` date NOT NULL,
`salary` int(11) NOT NULL,
`marital_status` int(11) NOT NULL,
`children` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Answer 1

Firstly, the tasters table has all fields marked as not null and has no default. You are trying to insert a row by only setting the id field, leaving the other with a null value. I would not expect the second insert to work because they are declared as not null. So your statement tries to insert an invalid record. Set default values for all fields or set them all in an insert statement.

Use

CREATE TABLE IF NOT EXISTS `tasters` (
  `id` int(11) NOT NULL,
  `name` varchar(32) NOT NULL DEFAULT '',
  `surname` varchar(32) NOT NULL DEFAULT '',
  `patronymic` varchar(32) NOT NULL DEFAULT '',
  `sex` int(11) NOT NULL DEFAULT '0',
  `birth` date NOT NULL DEFAULT '1970-01-01',
  `salary` int(11) NOT NULL DEFAULT '0',
  `marital_status` int(11) NOT NULL DEFAULT '0',
  `children` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

or

INSERT INTO tasters SET id=LAST_INSERT_ID(), name = '', surname = '', patronymic = '', sex = 0, birth = '1970-01-01', salary = '0', marital_status = 0, children = 0;

Secondly, do not store plain passwords in the table users. You have a password function in MySQL. Use that for storing passwords:

INSERT INTO users (login,password) VALUES('$login',password('$password'));

When you check for passwords use encrypted passwords:

select * from users where login = $entered_login and password = password($entered_password));

In that way, you do not operate with plain passwords and this increases the security of your system: Also, varchar(18) is too small: use varchar(64) or more instead.