Insert MySQL

Bokos

8. 7. 2013 14:02:38

Prosím vie mi niekto minimalizovať tento SQL do jedného? Už neviem ako tieto 2 dať do 1.

$quer = $mysqli->query("SELECT ID FROM campaign WHERE client_id = '" . $mysqli->escape($client_id) . "'");

$row = $query->fetch_assoc();

$campaign_id = $row;

$quer = $mysqli->query("INSERT INTO keyword

(c_word, date, position, AvgCpc, impression, clicks, cost, quality, ctr, type, MaxCpc)

SELECT ID,

'" . date("Y-m-d") . "',

'" . $mysqli->escape($position) . "',

'" . $mysqli->escape($AvgCpc) . "',

'" . $mysqli->escape($impression) . "',

'" . $mysqli->escape($clicks) . "',

'" . $mysqli->escape($cost) . "',

'" . $mysqli->escape($quality) . "',

'" . $mysqli->escape($ctr) . "',

'" . $mysqli->escape($type) . "',

'" . $mysqli->escape($MaxCpc) . "'

FROM keywords

WHERE

keyword = '" . $mysqli->escape($db_word) . "'

AND campaign = " . $campaign_id . "

");

8. 7. 2013 14:02:38

https://webtrh.cz/diskuse/insert-mysql/#reply920511

Lukáš Jurygáček

(26 hodnocení)

8. 7. 2013 14:22:22

Pokud jsem správně pochopil:

$quer = $mysqli->query("INSERT INTO keyword                                            (c_word, date, position, AvgCpc, impression, clicks, cost, quality, ctr, type, MaxCpc)                                            SELECT      ID,                                                     '" . date("Y-m-d") . "',                                                     '" . $mysqli->escape($position) . "',                                                     '" . $mysqli->escape($AvgCpc) . "',                                                     '" . $mysqli->escape($impression) . "',                                                     '" . $mysqli->escape($clicks) . "',                                                     '" . $mysqli->escape($cost) . "',                                                     '" . $mysqli->escape($quality) . "',                                                     '" . $mysqli->escape($ctr) . "',                                                     '" . $mysqli->escape($type) . "',                                                     '" . $mysqli->escape($MaxCpc) . "'                                            FROM keywords                                            WHERE                                                 keyword = '" . $mysqli->escape($db_word) . "'                                                 AND campaign = (SELECT ID FROM campaign WHERE client_id = '" . $mysqli->escape($client_id) . "' LIMIT 1)                                    ");

8. 7. 2013 14:22:22