Veritabanı bağlantısı başarılı
Mevcut tablolar:
Array
(
[0] => bewerbungen
[1] => survey_responses
[2] => surveys
)
bewerbungen tablosu mevcut
Tablo yapısı:
Array
(
[0] => Array
(
[Field] => id
[Type] => int
[Null] => NO
[Key] => PRI
[Default] =>
[Extra] => auto_increment
)
[1] => Array
(
[Field] => job_title
[Type] => varchar(100)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[2] => Array
(
[Field] => job_location
[Type] => varchar(100)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[3] => Array
(
[Field] => job_department
[Type] => varchar(50)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[4] => Array
(
[Field] => job_type
[Type] => varchar(50)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[5] => Array
(
[Field] => job_reference
[Type] => varchar(50)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[6] => Array
(
[Field] => bewerbung_typ
[Type] => varchar(100)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[7] => Array
(
[Field] => position
[Type] => varchar(100)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[8] => Array
(
[Field] => standort
[Type] => varchar(100)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[9] => Array
(
[Field] => vorname
[Type] => varchar(50)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[10] => Array
(
[Field] => nachname
[Type] => varchar(50)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[11] => Array
(
[Field] => email
[Type] => varchar(100)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[12] => Array
(
[Field] => telefon
[Type] => varchar(20)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[13] => Array
(
[Field] => plz
[Type] => varchar(10)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[14] => Array
(
[Field] => ort
[Type] => varchar(50)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[15] => Array
(
[Field] => berufliche_situation
[Type] => text
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[16] => Array
(
[Field] => umfrage_antworten
[Type] => text
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[17] => Array
(
[Field] => lebenslauf_pfad
[Type] => varchar(255)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[18] => Array
(
[Field] => lebenslauf_name
[Type] => varchar(255)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[19] => Array
(
[Field] => lebenslauf_typ
[Type] => varchar(100)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[20] => Array
(
[Field] => bewerbung_datum
[Type] => datetime
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[21] => Array
(
[Field] => status
[Type] => varchar(20)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[22] => Array
(
[Field] => created_at
[Type] => timestamp
[Null] => YES
[Key] =>
[Default] => CURRENT_TIMESTAMP
[Extra] => DEFAULT_GENERATED
)
)
Toplam kayıt sayısı: 6
İlk kayıt:
Array
(
[id] => 1
[job_title] =>
[job_location] =>
[job_department] =>
[job_type] =>
[job_reference] =>
[bewerbung_typ] => KFZ-Techniker Bewerbung
[position] => KFZ-TECHNIKER/IN (m/w/d)
[standort] => 4063 Hörsching
[vorname] => Naim
[nachname] => Yıldırım
[email] => bynaim@gmail.com
[telefon] => 6606077107
[plz] => 4060
[ort] => Leonding
[berufliche_situation] => Form not alanı test
[umfrage_antworten] => {"wartung_reparatur":{"frage":"Interessierst Du Dich für Wartungs- & Reparaturarbeiten?","antwort":"erfahren","antwortText":"Ja, ich habe in diesem Bereich gearbeitet."},"ausbildung":{"frage":"Hast Du eine abgeschlossene Berufsausbildung?","antwort":"andere_ausbildung","antwortText":"Anderweitig positiv abgeschlossene Ausbildung"},"erfahrung":{"frage":"Wie viel Erfahrung hast du als Kfz-Techniker:in?","antwort":"erfahrung_1_2","antwortText":"1-2 Jahre"},"fuhrerschein":{"frage":"Hast du einen Führerschein B?","antwort":"fuehrerschein_ja","antwortText":"Ja, das habe ich"},"verfugbarkeit":{"frage":"Ab wann können Sie mit uns zusammenarbeiten?","antwort":"verfuegbar_1_2_monate","antwortText":"in 1-2 Monaten"},"eigenschaften":{"frage":"Was trifft auf dich zu?","antwort":"teamfaehig","antwortText":"Teamfähigkeit"}}
[lebenslauf_pfad] => /home/vudo2186/schatzdorfer/uploads/bewerbungen/2025/02/bewerbung_67b98576ec171_20250222.pdf
[lebenslauf_name] => CV.pdf
[lebenslauf_typ] => application/pdf
[bewerbung_datum] => 2025-02-22 08:06:14
[status] => neu
[created_at] => 2025-02-22 11:06:14
)