ошибка NotAllFilled #49

serdgserdg · 2022-04-05T09:27:53Z

Имеется необходимость добавить в телефонный справочник дополнительную функцию "Регистрация переговорной комнаты"
Добавил новую таблицу со столбцами "pb_ peregovorka"
добавил в header дополнительное меню.

создал файл для получения данных из базы .
файл - routes/pk.php

создал форму и заполнил ее.
файл - templates/tpl.pk.php

создал файл для редактирования и создания новых записей в таблицу.
файл - routes/pk_edit.php

основываясь на информации как в файлах user_save.php и contact_save.php
создал для своих столбцов таблицы файл routes/pk_save.php

добавил эти файлы в pb.php
$core->Router->add_route('pk', 'pk');
$core->Router->add_route('pk_edit', 'pk_edit', TRUE);
$core->Router->add_route('pk_save', 'pk_save', TRUE);
в файле pb.js дописал
unction on_saved(action, data)
{
if(action == 'permission_save')
{
//f_get_perms(data.pid);
window.location = window.location;
}
else if(action == 'user_save')
{
window.location = window.location;
}
else if(action == 'pk_save')
{
window.location = window.location;
}
***//

В итоге данные из таблицы отображаются, форма для создания новых записей и форма редактирования открывается.
Но при нажатии кнопки "OK" в форме отображается сообщение "NotAllFilled"
Пробовал отключать эту проверку в созданных файлах но ничего не помогло.

pfzim · 2022-04-05T09:46:10Z

Не видя код сложно подсказать. Сообщение говорит, что не все обязательные поля заполнены.

serdgserdg · 2022-04-05T10:14:56Z

Посмотри пожалуйста где я допустил ошибку.
файл - templates/tpl.pk.php

<?php
include(TEMPLATES_DIR.'tpl.header.php'); ?>

<div>
	<div class="content-box">
		<h3><?php L('UsersManagement') ?></h3>
		<span id="add_new_user" class="command" onclick="f_show_form('<?php ln('pk_edit/0') ?>');"><?php L('AddPk') ?></span>

		<table id="table" class="main-table" width="100%">
			<thead>
			<tr>
				<th width="5%">ID</th>
				<th width="20%"><?php L('PuserName') ?></th>
				<th width="20%"><?php L('Pdata') ?></th>
				<th width="20%"><?php L('PdataReg') ?></th>
				<th width="20%"><?php L('PdataBron') ?></th>
				<th width="20%"><?php L('Pip') ?></th>
				<th width="20%"><?php L('Pver') ?></th>
				<th width="20%"><?php L('Operations') ?></th>
			</tr>
			</thead>
			<tbody id="table-data">
			<?php $i = 0; if($pk) foreach($pk as &$row) { ?>
				<tr id="<?php eh("row".$row['id']); ?>" data-id=<?php eh($row['id']);?>>
					<td><?php eh($row['id']); ?></td>
					<td><?php eh($row['PuserName']); ?></td>
					<td><?php eh($row['Pdata']); ?></td>
					<td><?php eh($row['PdataReg']); ?></td>
					<td><?php eh($row['PdataBron']); ?></td>
					<td><?php eh($row['Pip']); ?></td>
					<td><?php eh($row['Pver']); ?></td>
					<td>
						<span class="command" onclick="f_show_form('<?php ln('pk_edit/'.$row['id']) ?>');"><?php L('Edit') ?></span>
					</td>
				</tr>
			<?php } ?>
			</tbody>
		</table>
	</div>
</div>
		<br />
		<br />
<?php include(TEMPLATES_DIR.'tpl.universal-form.php'); ?>
<?php include(TEMPLATES_DIR.'tpl.form-upload.php'); ?>
<?php include(TEMPLATES_DIR.'tpl.map-container.php'); ?>
<?php include(TEMPLATES_DIR.'tpl.menu-contact.php'); ?>
<?php include(TEMPLATES_DIR.'tpl.footer.php'); ?>

serdgserdg · 2022-04-05T10:21:23Z

файл - routes/pk.php

<?php

function pk(&$core, $params, $post_data)
{
	if(!$core->UserAuth->check_permission(0, PB_ACCESS_ADMIN))
	{
		$error_msg = LL('AccessDeniedToSection').' 0 '.LL('forUser').' '.$core->UserAuth->get_login().'!';
		include(TEMPLATES_DIR.'tpl.message.php');
		exit;
	}

	$core->db->select_assoc_ex($pk, rpv('
		SELECT
			u.`id`,
			u.`PuserName`,
			u.`Pdata`,
			u.`PdataReg`,
			u.`PdataBron`,
			u.`Pip`,
			u.`Pver`
			FROM @peregovorka AS u
		WHERE u.`Pver` > 0
		ORDER BY u.`id`
	'));

	include(TEMPLATES_DIR.'tpl.pk.php');
}

serdgserdg · 2022-04-05T10:22:06Z

файл - routes/pk_edit.php

<?php

function pk_edit(&$core, $params)
{
	$pk_id = intval(@$params[1]);

	assert_permission_ajax(0, PB_ACCESS_ADMIN);	// level 0 having Write access mean admin
	$result_json = array(
		'code' => 0,
		'message' => '',
		'errors' => array()
	);

	if($pk_id)
	{
		if(!$core->db->select_assoc_ex($pk, rpv('

		SELECT	u.`PuserName`, u.`Pdata`, u.`PdataReg`, u.`PdataBron`, u.`Pip`, u.`Pver` FROM @peregovorka AS u WHERE u.`id` = # LIMIT 1', $pk_id)))

		{
			echo '{"code": 1, "message": "Failed get permissions"}';
		}
		
		$pk = &$pk[0];
	}
	else
	{
		$pk = array(
			'PuserName' => '',
			'Pdata' => '',
			'PdataReg' => '',
			'PdataBron' => '',
			'Pip' => '',
			'Pver' => ''
		);
	}

	$result_json = array(
		'code' => 0,
		'message' => '',
		'title' => LL('AddPk'),
		'action' => 'contact_save',
		'fields' => array(
			array(
				'type' => 'hidden',
				'name' => 'id',
				'value' => $pk_id
			),
			array(
				'type' => 'string',
				'name' => 'PuserName',
				'title' => LL('PuserName'),
				'value' => $pk['PuserName']
			),
			array(
				'type' => 'string',
				'name' => 'Pdata',
				'title' => LL('Pdata'),
				'value' => $pk['Pdata']
			),
			array(
				'type' => 'string',
				'name' => 'PdataReg',
				'title' => LL('PdataReg'),
				'value' => $pk['PdataReg']
			),
			array(
				'type' => 'string',
				'name' => 'PdataBron',
				'title' => LL('PdataBron'),
				'value' => $pk['PdataBron']
			),
			array(
				'type' => 'string',
				'name' => 'Pip',
				'title' => LL('Pip'),
				'value' => $pk['Pip']
			),
			array(
				'type' => 'string',
				'name' => 'Pver',
				'title' => LL('Pver'),
				'value' => $pk['Pver']
			)
		)
	);

	echo json_encode($result_json);


}

serdgserdg · 2022-04-05T10:22:26Z

файл - routes/pk_save.php

<?php

function pk_save(&$core, $params, $post_data)
{
	$result_json = array(
		'code' => 0,
		'message' => '',
		'errors' => array()
	);

	assert_permission_ajax(0, PB_ACCESS_ADMIN);
	

	$pk_id = intval(@$post_data['id']);
	$PuserName = @$post_data['PuserName'];
	$Pdata = @$post_data['Pdata'];
   $PdataReg = @$post_data['PdataReg'];
   $PdataBron = @$post_data['PdataBron'];
   $Pip = @$post_data['Pip'];
   $Pver = @$post_data['Pver'];

	if(empty($PuserName))
	{
		$result_json['code'] = 1;
		$result_json['errors'][] = array('name' => 'PuserName', 'msg' => LL('ThisFieldRequired'));
	}

	if(empty($Pdata))
	{
		$result_json['code'] = 1;
		$result_json['errors'][] = array('name' => 'Pdata', 'msg' => LL('ThisFieldRequired'));
	}

	if($result_json['code'])
	{
		$result_json['message'] = LL('Not_All_Filled');
	}
	elseif($core->pkAuth->set_pk_info_ex($pk_id, $PuserName, $Pdata))
	{
		log_db('Updated pk', '{id='.$pk_id.',PuserName="'.$PuserName.'"}', 0);
		$result_json['message'] = LL('SuccessfulUpdated');
	}
	else
	{
		$result_json['code'] = 1;
		$result_json['message'] = LL('Error').': '.$core->get_last_error();
	}

	//log_file('Password changed: '.json_encode($result_json, JSON_UNESCAPED_UNICODE));
	echo json_encode($result_json, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE);
}

serdgserdg · 2022-04-05T10:27:00Z

в таблице все столбцы TEXT

pfzim · 2022-04-05T11:19:14Z

Файл routes/pk_edit.php
'action' => 'contact_save',
должно быть
'action' => 'pk_save',

serdgserdg · 2022-04-05T11:33:56Z

исправил
теперь выдает ошибку в var/pb/pb.log

2022-04-05T14:28:35+03:00 Exception: File: /var/www/pb/modules/Core.php[107]: Core: ERROR: Module /var/www/pb/modules/pkAuth.php not found! Trace: #0 /var/www/pb/modules/Core.php(100): Core->error_ex()
#1 /var/www/pb/modules/Core.php(56): Core->error()
#2 /var/www/pb/modules/Core.php(74): Core->load_ex()
#3 /var/www/pb/routes/pk_save.php(38): Core->__get()
#4 /var/www/pb/modules/Router.php(103): pk_save()
#5 /var/www/pb/pb.php(320): Router->process()
#6 {main}

pfzim · 2022-04-05T11:53:29Z

Вот здесь что-то непонятное:

	elseif($core->pkAuth->set_pk_info_ex($pk_id, $PuserName, $Pdata))

Видимо здесь надо запись в БД делать, как тут:

ldap-phonebook/routes/contact_save.php

Lines 65 to 163 in ca5591d

    
           	if(!$v_id) 
        
           	{ 
        
           		$core->db->put(rpv(' 
        
           				INSERT INTO `@contacts` ( 
        
           					`adid`, 
        
           					`samaccountname`, 
        
           					`last_name`, 
        
           					`first_name`, 
        
           					`middle_name`, 
        
           					`department`, 
        
           					`organization`, 
        
           					`position`, 
        
           					`phone_internal`, 
        
           					`phone_external`, 
        
           					`phone_mobile`, 
        
           					`mail`, 
        
           					`birthday`, 
        
           					`reserved1`, 
        
           					`reserved2`, 
        
           					`reserved3`, 
        
           					`reserved4`, 
        
           					`reserved5`, 
        
           					`type`, 
        
           					`flags` 
        
           				) VALUES (\'\', \'\', {s0}, {s1}, {s2}, {s3}, {s4}, {s5}, {s6}, {s7}, {s8}, {s9}, {r10}, {s11}, {s12}, {s13}, {s14}, {s15}, {d16}, {d17}) 
        
           			', 
        
           			$v_last_name, 
        
           			$v_first_name, 
        
           			$v_middle_name, 
        
           			$v_department, 
        
           			$v_organization, 
        
           			$v_position, 
        
           			$v_phone_internal, 
        
           			$v_phone_external, 
        
           			$v_phone_mobile, 
        
           			$v_mail, 
        
           			$v_birthday, 
        
           			$v_reserved1, 
        
           			$v_reserved2, 
        
           			$v_reserved3, 
        
           			$v_reserved4, 
        
           			$v_reserved5, 
        
           			$v_type, 
        
           			PB_CONTACT_VISIBLE 
        
           		)); 
        
           		$v_id = $core->db->last_id(); 
        
           		echo '{"code": 0, "id": '.$v_id.', "message": "Added (ID '.$v_id.')"}'; 
        
           	} 
        
           	else 
        
           	{ 
        
           		$core->db->put(rpv(' 
        
           				UPDATE `@contacts` SET 
        
           					`samaccountname` = \'\', 
        
           					`last_name` = {s0}, 
        
           					`first_name` = {s1}, 
        
           					`middle_name` = {s2}, 
        
           					`department` = {s3}, 
        
           					`organization` = {s4}, 
        
           					`position` = {s5}, 
        
           					`phone_internal` = {s6}, 
        
           					`phone_external` = {s7}, 
        
           					`phone_mobile` = {s8}, 
        
           					`mail` = {s9}, 
        
           					`birthday` = {r10}, 
        
           					`reserved1` = {s11}, 
        
           					`reserved2` = {s12}, 
        
           					`reserved3` = {s13}, 
        
           					`reserved4` = {s14}, 
        
           					`reserved5` = {s15}, 
        
           					`type` = {d16} 
        
           				WHERE 
        
           					`id` = {d17} 
        
           					AND `adid` = \'\' 
        
           				LIMIT 1 
        
           			', 
        
           			$v_last_name, 
        
           			$v_first_name, 
        
           			$v_middle_name, 
        
           			$v_department, 
        
           			$v_organization, 
        
           			$v_position, 
        
           			$v_phone_internal, 
        
           			$v_phone_external, 
        
           			$v_phone_mobile, 
        
           			$v_mail, 
        
           			$v_birthday, 
        
           			$v_reserved1, 
        
           			$v_reserved2, 
        
           			$v_reserved3, 
        
           			$v_reserved4, 
        
           			$v_reserved5, 
        
           			$v_type, 
        
           			$v_id 
        
           		)); 
        
           		echo '{"code": 0, "id": '.$v_id.',"message": "Updated (ID '.$v_id.')"}'; 
        
           	}

serdgserdg · 2022-04-05T12:05:31Z

elseif($core->pkAuth->set_pk_info_ex($pk_id, $PuserName, $Pdata))
заменил на
elseif(empty($user_id))

serdgserdg · 2022-04-05T13:54:04Z

файл - routes/pk_save.php
поправил но выдает ошибку
2022-04-05T16:50:00+03:00 Exception: File: /var/www/pb/routes/pk_save.php[78]: syntax error, unexpected variable "$pk_id", expecting ")" Trace: #0 /var/www/pb/pb.php(320): Router->process()
#1 {main}

<?php

function pk_save(&$core, $params, $post_data)
{
	assert_permission_ajax(0, PB_ACCESS_ADMIN);
	$result_json = array(
		'code' => 0,
		'message' => '',
		'errors' => array()
	);

        	$pk_id = intval(@$post_data['id']);
			$PuserName = trim(@$post_data['PuserName']);
			$Pdata = trim(@$post_data['Pdata']);
        	$PdataReg = trim(@$post_data['PdataReg']);
        	$PdataBron = trim(@$post_data['PdataBron']);
        	$Pip = trim(@$post_data['Pip']);
        	$Pver = trim(@$post_data['Pver']);

	if(empty($PuserName))
	{
		$result_json['code'] = 1;
		$result_json['errors'][] = array('name' => 'PuserName', 'msg' => LL('ThisFieldRequired'));
	}

	if(empty($Pdata))
	{
		$result_json['code'] = 1;
		$result_json['errors'][] = array('name' => 'Pdata', 'msg' => LL('ThisFieldRequired'));
	}

	if($result_json['code'])
	{
		$result_json['message'] = LL('NotAllFilled');
		echo json_encode($result_json);
		exit;
	}
   if(!$pk_id)
	{
		$core->db->put(rpv('
						INSERT INTO `@peregovorka`(
						`PuserName`, 
						`Pdata`, 
						`PdataReg`, 
						`PdataBron`, 
						`Pip`, 
						`Pver`
					) VALUES ({s0}, {s1}, {s2}, {s3}, {s4}, {s5}, {d6})
			',
			$PuserName,
			$Pdata,
        	$PdataReg,
        	$PdataBron,
        	$Pip,
        	$Pver
        	));
        	echo '{"code": 0, "id": '.$pk_id.', "message": "Added (ID '.$pk_id.')"}';
    }
	else
	{
		$core->db->put(rpv('
		    			UPDATE `@peregovorka` SET 
		    			`PuserName` = {s0}, 
						`Pdata` = {s1}, 
						`PdataReg = {s2}`, 
						`PdataBron` = {s3}, 
						`Pip` = {s4}, 
						`Pver` = {s5} 
						WHERE
					`id` = {d6} LIMIT 1
			',
			$PuserName,
			$Pdata,
        	$PdataReg,
        	$PdataBron,
        	$Pip,
        	$Pver
        	$pk_id
));
echo '{"code": 0, "id": '.$pk_id.',"message": "Updated (ID '.$pk_id.')"}'; 
}
}

serdgserdg · 2022-04-05T14:56:59Z

Если в PHPMyAdmin сделать команду добавления то она добавляет строки
INSERT INTO pb_peregovorka(PuserName, Pdata, PdataReg, PdataBron, Pip, Pver) VALUES ('nasonov', '01.04.2022', '01.04.2022', '01.04.2022', '192.168.140.102', '1');

serdgserdg · 2022-04-05T15:26:38Z

создал код который на добавление работает а на редактирование нет

if(!$pk_id)
	{
		$core->db->put(rpv("INSERT INTO `@peregovorka` (
						`PuserName`, 
						`Pdata`, 
						`PdataReg`, 
						`PdataBron`, 
						`Pip`, 
						`Pver`) 
						VALUES ('{$PuserName}', '{$Pdata}', '{$PdataReg}', '{$PdataBron}', '{$Pip}', '{$Pver}');")
		
        	);
        	echo '{"code": 0, "id": '.$pk_id.', "message": "Added (ID '.$pk_id.')"}';
    }
	else
	{
		$core->db->put(rpv("UPDATE `@peregovorka` SET (
						`PuserName`, 
						`Pdata`, 
						`PdataReg`, 
						`PdataBron`, 
						`Pip`, 
						`Pver`) 
						VALUES ('{$PuserName}', '{$Pdata}', '{$PdataReg}', '{$PdataBron}', '{$Pip}', '{$Pver}') WHERE `id` = '{$pk_id}';")
						);

serdgserdg · 2022-04-05T16:38:00Z

Похоже на то что он не берет из открывшейся формы данные или не видет $pk_id.
Может при редактировании нужно брать данные из массива который использует в pk_edit.php $row['id'], тот ко которому заполняется форма для редактировании?

serdgserdg · 2022-04-06T10:12:55Z

Вот так работает но форма не закрывается после нажатии кнопки "ОК"
не подскажете как сделать чтоб форма закрывалась?

if(!$pk_id)
	{
		$core->db->put(rpv("INSERT INTO `@peregovorka` (
						`PuserName`, 
						`Pdata`, 
						`PdataReg`, 
						`PdataBron`, 
						`Pip`, 
						`Pver`) 
						VALUES ('{$PuserName}', '{$Pdata}', '{$PdataReg}', '{$PdataBron}', '{$Pip}', '{$Pver}');")
		        	);
		   $pk_id = $core->db->last_id();
        	echo '{"code": 0, "id": '.$pk_id.', "message": "Added (ID '.$pk_id.')"}';
        	    }
	else
	{
		$core->db->put(rpv("UPDATE `@peregovorka` SET
						`PuserName` = '{$PuserName}', 
						`Pdata` = '{$Pdata}', 
						`PdataReg` = '{$PdataReg}', 
						`PdataBron` = '{$PdataBron}', 
						`Pip` = '{$Pip}', 
						`Pver` = '{$Pver}' 
						WHERE `id` = '$pk_id';")
						);
echo '{"code": 0, "id": '.$pk_id.',"message": "Updated (ID '.$pk_id.')"}'; 
}

serdgserdg · 2022-04-06T10:20:34Z

строка редактирования почему-то не работает, не вносит изменение в базу

else
	{
		$core->db->put(rpv('UPDATE `@peregovorka` SET `PuserName` = #, `Pdata` = #, `PdataReg` = #, `PdataBron` = #, `Pip` = #, `Pver` = #
		WHERE `id` = # LIMIT 1', $PuserName, $Pdata, $PdataReg, $PdataBron, $Pip, $Pver));

pfzim · 2022-04-06T11:54:20Z

#49 (comment)
Вот этот вариант более правильный, просто запятой не хватает между:

        	$Pver
        	$pk_id

serdgserdg · 2022-04-06T12:22:10Z

работает.
но после нажатия OK не закрывается окно и нужно обновлять старицу чтоб данные для отображения обновились

<?php

function pk_save(&$core, $params, $post_data)
{
	assert_permission_ajax(0, PB_ACCESS_ADMIN);
	$result_json = array(
		'code' => 0,
		'message' => '',
		'errors' => array()
	);

        	$pk_id = intval(@$post_data['id']);
			$PuserName = trim(@$post_data['PuserName']);
			$Pdata = trim(@$post_data['Pdata']);
        	$PdataReg = trim(@$post_data['PdataReg']);
        	$PdataBron = trim(@$post_data['PdataBron']);
        	$Pip = trim(@$post_data['Pip']);
        	$Pver = trim(@$post_data['Pver']);
		
	if(empty($PuserName))
	{
		$result_json['code'] = 1;
		$result_json['errors'][] = array('name' => 'PuserName', 'msg' => LL('ThisFieldRequired'));
	}

	if(empty($Pdata))
	{
		$result_json['code'] = 1;
		$result_json['errors'][] = array('name' => 'Pdata', 'msg' => LL('ThisFieldRequired'));
	}

	if($result_json['code'])
	{
		$result_json['message'] = LL('NotAllFilled');
		echo json_encode($result_json);
		exit;
	}
   if(!$pk_id)
	{
		$core->db->put(rpv('
				INSERT INTO `@peregovorka` (
						`PuserName`, 
						`Pdata`, 
						`PdataReg`, 
						`PdataBron`, 
						`Pip`, 
						`Pver`) 
						VALUES ({s0}, {s1}, {s2}, {s3}, {s4}, {s5})
						',
						$PuserName,
						$Pdata,
						$PdataReg,
						$PdataBron,
						$Pip,
						$Pver
						));
		   $pk_id = $core->db->last_id();
     	
        	echo '{"code": 0, "id": '.$pk_id.', "message": "Added (ID '.$pk_id.')"}';
echo $pk_id;
echo $PuserName;
echo $Pdata;
echo $PdataReg;
echo $PdataBron;
echo $Pip;
echo $Pver;
	}
	else
	{
		$core->db->put(rpv('
		UPDATE `@peregovorka` SET 
		`PuserName` = {s0}, 
		`Pdata` = {s1}, 
		`PdataReg` = {s2}, 
		`PdataBron` = {s3}, 
		`Pip` = {s4}, 
		`Pver` = {s5}
		WHERE `id` = '.$pk_id.' LIMIT 1
		',
		$PuserName,
		$Pdata,
		$PdataReg,
		$PdataBron,
		$Pip,
		$Pver
		));
		
echo $pk_id;
echo $PuserName;
echo $Pdata;
echo $PdataReg;
echo $PdataBron;
echo $Pip;
echo $Pver;
echo '{"code": 0, "id": '.$pk_id.',"message": "Updated (ID '.$pk_id.')"}'; 
}
}

pfzim · 2022-04-06T13:11:34Z

Из-за лишних echo неправильный ответ возвращался.

<?php

function pk_save(&$core, $params, $post_data)
{
	assert_permission_ajax(0, PB_ACCESS_ADMIN);
	$result_json = array(
		'code' => 0,
		'message' => '',
		'errors' => array()
	);

        	$pk_id = intval(@$post_data['id']);
			$PuserName = trim(@$post_data['PuserName']);
			$Pdata = trim(@$post_data['Pdata']);
        	$PdataReg = trim(@$post_data['PdataReg']);
        	$PdataBron = trim(@$post_data['PdataBron']);
        	$Pip = trim(@$post_data['Pip']);
        	$Pver = trim(@$post_data['Pver']);
		
	if(empty($PuserName))
	{
		$result_json['code'] = 1;
		$result_json['errors'][] = array('name' => 'PuserName', 'msg' => LL('ThisFieldRequired'));
	}

	if(empty($Pdata))
	{
		$result_json['code'] = 1;
		$result_json['errors'][] = array('name' => 'Pdata', 'msg' => LL('ThisFieldRequired'));
	}

	if($result_json['code'])
	{
		$result_json['message'] = LL('NotAllFilled');
		echo json_encode($result_json);
		exit;
	}
   if(!$pk_id)
	{
		$core->db->put(rpv('
				INSERT INTO `@peregovorka` (
						`PuserName`, 
						`Pdata`, 
						`PdataReg`, 
						`PdataBron`, 
						`Pip`, 
						`Pver`) 
						VALUES ({s0}, {s1}, {s2}, {s3}, {s4}, {s5})
						',
						$PuserName,
						$Pdata,
						$PdataReg,
						$PdataBron,
						$Pip,
						$Pver
						));
		   $pk_id = $core->db->last_id();
     	
        	echo '{"code": 0, "id": '.$pk_id.', "message": "Added (ID '.$pk_id.')"}';
	}
	else
	{
		$core->db->put(rpv('
		UPDATE `@peregovorka` SET 
		`PuserName` = {s0}, 
		`Pdata` = {s1}, 
		`PdataReg` = {s2}, 
		`PdataBron` = {s3}, 
		`Pip` = {s4}, 
		`Pver` = {s5}
		WHERE `id` = {d6} LIMIT 1
		',
		$PuserName,
		$Pdata,
		$PdataReg,
		$PdataBron,
		$Pip,
		$Pver,
		$pk_id
		));
		
		echo '{"code": 0, "id": '.$pk_id.',"message": "Updated (ID '.$pk_id.')"}'; 
	}
}

serdgserdg · 2022-04-08T11:02:06Z

Осталось теперь сделать функции: удаления строк, скрывания, поиска и фильтрации

serdgserdg · 2022-05-24T14:26:39Z

С функцией создания строк разобрался, а вот фильтр не поддается не в какую.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

ошибка NotAllFilled #49

ошибка NotAllFilled #49

serdgserdg commented Apr 5, 2022

pfzim commented Apr 5, 2022

serdgserdg commented Apr 5, 2022 •

edited by pfzim

Loading

serdgserdg commented Apr 5, 2022 •

edited by pfzim

Loading

serdgserdg commented Apr 5, 2022 •

edited by pfzim

Loading

serdgserdg commented Apr 5, 2022 •

edited by pfzim

Loading

serdgserdg commented Apr 5, 2022

pfzim commented Apr 5, 2022

serdgserdg commented Apr 5, 2022

pfzim commented Apr 5, 2022

serdgserdg commented Apr 5, 2022

serdgserdg commented Apr 5, 2022 •

edited by pfzim

Loading

serdgserdg commented Apr 5, 2022

serdgserdg commented Apr 5, 2022 •

edited by pfzim

Loading

serdgserdg commented Apr 5, 2022 •

edited

Loading

serdgserdg commented Apr 6, 2022 •

edited by pfzim

Loading

serdgserdg commented Apr 6, 2022 •

edited by pfzim

Loading

pfzim commented Apr 6, 2022

serdgserdg commented Apr 6, 2022 •

edited by pfzim

Loading

pfzim commented Apr 6, 2022 •

edited

Loading

serdgserdg commented Apr 8, 2022

serdgserdg commented May 24, 2022

ошибка NotAllFilled #49

ошибка NotAllFilled #49

Comments

serdgserdg commented Apr 5, 2022

pfzim commented Apr 5, 2022

serdgserdg commented Apr 5, 2022 • edited by pfzim Loading

serdgserdg commented Apr 5, 2022 • edited by pfzim Loading

serdgserdg commented Apr 5, 2022 • edited by pfzim Loading

serdgserdg commented Apr 5, 2022 • edited by pfzim Loading

serdgserdg commented Apr 5, 2022

pfzim commented Apr 5, 2022

serdgserdg commented Apr 5, 2022

pfzim commented Apr 5, 2022

serdgserdg commented Apr 5, 2022

serdgserdg commented Apr 5, 2022 • edited by pfzim Loading

serdgserdg commented Apr 5, 2022

serdgserdg commented Apr 5, 2022 • edited by pfzim Loading

serdgserdg commented Apr 5, 2022 • edited Loading

serdgserdg commented Apr 6, 2022 • edited by pfzim Loading

serdgserdg commented Apr 6, 2022 • edited by pfzim Loading

pfzim commented Apr 6, 2022

serdgserdg commented Apr 6, 2022 • edited by pfzim Loading

pfzim commented Apr 6, 2022 • edited Loading

serdgserdg commented Apr 8, 2022

serdgserdg commented May 24, 2022

serdgserdg commented Apr 5, 2022 •

edited by pfzim

Loading

serdgserdg commented Apr 5, 2022 •

edited by pfzim

Loading

serdgserdg commented Apr 5, 2022 •

edited by pfzim

Loading

serdgserdg commented Apr 5, 2022 •

edited by pfzim

Loading

serdgserdg commented Apr 5, 2022 •

edited by pfzim

Loading

serdgserdg commented Apr 5, 2022 •

edited by pfzim

Loading

serdgserdg commented Apr 5, 2022 •

edited

Loading

serdgserdg commented Apr 6, 2022 •

edited by pfzim

Loading

serdgserdg commented Apr 6, 2022 •

edited by pfzim

Loading

serdgserdg commented Apr 6, 2022 •

edited by pfzim

Loading

pfzim commented Apr 6, 2022 •

edited

Loading