так-с, вот у меня есть боольшущая форма. Пишу обработчик для нее. что-то типа: PHP: <?php $sql = sprintf("INSERT INTO pr_university (city_id, title, title_ukr, type, address, phone, site, accreditation, education_form, qualification, options, access_course VALUES (%d, %s, %s, %d, %s, %s, %s, %s, %s, %s, %s, %s)", clean($_POST['city_id']), cleanQ(nl2sc($_POST['title'])), cleanQ(nl2sc($_POST['title_ukr'])), clean($_POST['type']), cleanQ($_POST['address']), cleanQ($_POST['phone']), cleanQ($_POST['site']), cleanQ(implode(',', $_POST['accreditation'])), cleanQ(implode(',', $_POST['education_form']), cleanQ(implode(',', $_POST['qualification'])), cleanQ(implode(',', $_POST['options'])), cleanQ($_POST['access_course'])); $db->query($sql); ?> Красиво и легкочитаемо? :lol: ну сделал вот так: PHP: <?php $sql = "INSERT INTO pr_university (city_id, title, title_ukr, type, address, phone, site, accreditation, education_form, qualification, options, access_course)"; $sql .=" VALUES (%d, %s, %s, %d, %s, %s, %s, %s, %s, %s, %s, %s)"; $sql = sprintf($sql, clean($_POST['city_id']), cleanQ(nl2sc($_POST['title'])), cleanQ(nl2sc($_POST['title_ukr'])), clean($_POST['type']), cleanQ($_POST['address']), cleanQ($_POST['phone']), cleanQ($_POST['site']), cleanQ(implode(',', $_POST['accreditation'])), cleanQ(implode(',', $_POST['education_form']), cleanQ(implode(',', $_POST['qualification'])), cleanQ(implode(',', $_POST['options'])), cleanQ($_POST['access_course'])); $db->query($sql); ?> Все равно что-то не то. Как бы это сделали вы?
PHP: <?php $query = ' INSERT INTO photo_albums (album_id, user_id, album_title, album_descr, album_date) VALUES (NULL, ?, ?, ?, NOW()) '; $this->db->query($query, array( $user_id, $form_data['album_title'], $form_data['album_descr'] ));
PHP: <?php $values=array( "user_id"=>$user_id, "album_title"=>$form_data["album_title"], "album_descr"=>$form_data["album_descr"], "album_date"=>time()); $database->addLine("photo_albums",$values);