<?php /** * Created by PhpStorm. * User: jesus * Date: 1/28/2015 * Time: 5:12 PM */ require_once "../Database/Invited.php"; require_once "../Database/Database.php"; $database = new Database(); $invited = new \Invitation\Invited(); $database->connect(); $invited->_setInvitedTotals($database); echo "delete duplicate in db"; echo "delete = " . $invited->deleteDuplicateDb(); echo "<h1> delete duplicate by name </h1>"; $response = $database->selectV1('fs_invited', "count(*) as total , max(invited_id), invited_id, invited_fn, invited_email", " invited_status > 0 GROUP BY invited_fn"); echo "<pre>"; for ($i = 0; $i < count($response); $i++) { if ($response[$i]['total'] > 1) { print_r($response[$i]); $name = $response[$i]['invited_fn']; $id = $response[$i]['invited_id']; $email = $response[$i]['invited_email']; if ($database->delete('fs_invited', "invited_id <> {$id} and invited_fn =\n '{$name}'")) { echo " deleted \n"; } else { echo "failed deleted \n"; } }