Database Verification After Import ================================== 1. Business Types Created:
SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) (Connection: mysql, SQL: select `id`, `name` from `business_types`)
Illuminate\Database\Connection->runQueryCallback(string, array, object(Closure))Illuminate\Database\Connection->tryAgainIfCausedByLostConnection(object(Illuminate\Database\QueryException), string, array, object(Closure))Illuminate\Database\Connection->handleQueryException(object(Illuminate\Database\QueryException), string, array, object(Closure))Illuminate\Database\Connection->run(string, array, object(Closure))Illuminate\Database\Connection->select(string, array, boolean)Illuminate\Database\Query\Builder->runSelect()Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()Illuminate\Database\Query\Builder->onceWithColumns(array, object(Closure))Illuminate\Database\Query\Builder->get(array)Illuminate\Database\Eloquent\Builder->getModels(array)Illuminate\Database\Eloquent\Builder->get(array)Illuminate\Database\Eloquent\Model::all(array)verify_import.php11echo "Database Verification After Import\n";
12echo "==================================\n\n";
13
14// Check business types
15echo "1. Business Types Created:\n";
16$businessTypes = BusinessType::all(['id', 'name']);
17foreach ($businessTypes as $bt) {
18 echo " ID {$bt->id}: {$bt->name}\n";
19}
20
21echo "\n2. Recent Leads with Business Types:\n";
22$leads = Lead::with('businessType')
23 ->orderBy('created_at', 'desc')
24 ->limit(15)
25 ->get(['id', 'name', 'email', 'business_type_id', 'lead_source', 'created_at']);
26
27foreach ($leads as $lead) {
28