✓ Loaded connect.php from: /home/cuofbpmq/app2.e-azy-agro.com/config/connect.php

Farmer Database Debug

✓ Database connected successfully

Available Tables:

Table: farmer_activity_log

Columns:

FieldTypeNullKey
idintNOPRI
farmer_idintNOMUL
actionvarchar(100)NO
detailstextYES
created_atdatetimeYESMUL

Sample Data:

No records found in this table.

Table: farmer_business_profiles

Columns:

FieldTypeNullKey
profile_idintNOPRI
farmer_idintNOUNI
business_namevarchar(100)NO
business_slugvarchar(100)NOUNI
business_logovarchar(255)YES
business_bannervarchar(255)YES
business_descriptiontextYES
business_emailvarchar(100)YES
business_phonevarchar(20)YES
website_urlvarchar(255)YES
facebook_urlvarchar(255)YES
twitter_urlvarchar(255)YES
instagram_urlvarchar(255)YES
whatsapp_numbervarchar(20)YES
opening_hourstextYES
delivery_radius_kmintYES
minimum_order_amountdecimal(10,2)YES
rating_avgdecimal(3,2)YES
rating_countintYES
is_verifiedtinyintYESMUL
created_attimestampYES
updated_attimestampYES

Sample Data:

No records found in this table.

Table: farmer_feedback

Columns:

FieldTypeNullKey
idintNOPRI
order_idvarchar(100)NOMUL
farmer_idintNOMUL
buyer_idintNOMUL
buyer_typeenum('buyer','professional_buyer')NO
ratingintNO
feedback_texttextNO
communicationintYES
payment_timelinessintYES
created_atdatetimeNO
updated_atdatetimeYES

Sample Data:

idorder_idfarmer_idbuyer_idbuyer_typeratingfeedback_textcommunicationpayment_timelinesscreated_atupdated_at
1190114173buyer4it was good542026-06-26 13:14:082026-06-26 13:14:19

Table: farmer_notification_settings

Columns:

FieldTypeNullKey
idintNOPRI
farmer_idintNOUNI
email_notificationstinyint(1)YES
sms_notificationstinyint(1)YES
order_notificationstinyint(1)YES
product_notificationstinyint(1)YES
bid_notificationstinyint(1)YES
system_notificationstinyint(1)YES
marketing_emailstinyint(1)YES
created_attimestampYES
updated_attimestampYES

Sample Data:

No records found in this table.

Table: farmer_pending_users

Columns:

FieldTypeNullKey
idintNOPRI
fullnamevarchar(255)NO
phonevarchar(10)NOUNI
emailvarchar(100)YES
passwordvarchar(255)NO
dobdateYES
ageintYES
gendervarchar(256)YES
addresstextNO
countyvarchar(50)NO
constituencyvarchar(50)NO
wardvarchar(100)NO
nearest_placevarchar(100)NO
otp_codevarchar(10)NO
otp_expiresdatetimeNOMUL
attemptsintYES
created_attimestampYES

Sample Data:

idfullnamephoneemailpassworddobagegenderaddresscountyconstituencywardnearest_placeotp_codeotp_expiresattemptscreated_at
2Nyaboke Karagacha0722222222$2y$10$Ic6JQpw3UB.3xvxw6wzQNeg5oPYLuWyF5YGZHVVNjvc656WPPxdgu1991-01-0135MaleVillage Inn Kiambu RoadKisumuKisumu centralMarket milimaniCentral primary school2864922026-05-21 11:51:0802026-05-21 11:45:56
3Scola Karagacha0725438353$2y$10$a9Dr1EpRQd8j32nL0F1SUOuaUB79lnJX0a6QfKLdbOxI/TkjJO1Da1991-01-0135MaleVillage Inn Kiambu RoadEmbuManyattaGaturi southKyetheru catholic church grounds1494102026-05-21 11:54:1402026-05-21 11:49:14
6Methu Meshacxk0717314632sammymadilu@gmail.com$2y$10$3N9XzHavWRZr56RMtzr6MOu4kgaWB2zSA7iUeJjX1UBRgbhSfCu421996-11-1329Male004KilifiMalindiGandaPendukiani nursery school1488742026-05-22 07:26:0512026-05-22 07:21:05
9Sylvester Nyambango0756696358sylvesternyambango@gmail.com$2y$10$BRAbEMZc1AXfbsGT8E8JbeeQdTAli9uejtm9kbqqURaoWMU4.Rnt61981-05-0545MaleNyankoreMigoriKuria westIsibaniaIsibania boys high school3351422026-06-05 17:42:3102026-06-05 17:37:31
11Walter adolwa0713919854walteradolwa05@gmail.com$2y$10$lpBjIOs2ZqXcudnQ/DMR0uHBrEYe3Ypci9ytnthcOCz5k4mJY08Q22000-10-2525MaleMajengoVihigaVihigaSouth maragoliChandugunyi primary school2038042026-06-09 12:25:0602026-06-09 12:10:53

Table: farmer_pro

Columns:

FieldTypeNullKey
idintNOPRI
namevarchar(100)NO
emailvarchar(100)YESUNI
phonevarchar(20)NOUNI
passwordvarchar(255)NO
farm_namevarchar(100)YES
farm_sizevarchar(50)YES
id_numbervarchar(50)YES
kra_pinvarchar(50)YES
created_atdatetimeYES

Sample Data:


Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104
idnameemailphonepasswordfarm_namefarm_sizeid_numberkra_pincreated_at
1Test Professional Farmerfarmerpro@example.com0768757776$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igiTest Farm 2026-05-07 02:40:17

Table: farmer_ratings

Columns:

FieldTypeNullKey
rating_idintNOPRI
farmer_idintNOMUL
buyer_idintNO
order_idintNOMUL
ratingintNO
reviewtextYES
created_atdatetimeYES

Sample Data:

No records found in this table.

Table: farmerregistration

Columns:

FieldTypeNullKey
idintNOPRI
namevarchar(255)NO
phonevarchar(10)NOUNI
addresstextNO
countyvarchar(50)NO
constituencyvarchar(50)NO
wardvarchar(100)NO
Nearest_placevarchar(100)NO
emailvarchar(100)NO
passwordvarchar(100)NO
rolevarchar(255)NO
ageintYES
dobdateYES
gendervarchar(256)NO
created_attimestampNO
verification_statusenum('pending','verified','rejected')YES
is_professional_farmertinyint(1)NO
farm_sizedecimal(10,2)NOMUL
facebook_urlvarchar(255)YES
twitter_urlvarchar(255)YES
instagram_urlvarchar(255)YES
is_professionaltinyint(1)YES
business_namevarchar(255)YES
license_numbervarchar(100)YES
years_experienceintYES
profile_imagevarchar(255)YES
business_descriptiontextYES
business_hourstextYES
certificationstextYES
logovarchar(255)YES
reset_codevarchar(6)YES
reset_expiresdatetimeYES
statusvarchar(20)YES
last_logindatetimeYES
total_salesdecimal(10,2)YES
total_ordersintYES
acceptance_ratedecimal(5,2)YES
avg_response_timeintYES
last_activedatetimeYES
retention_ratedecimal(5,2)YES
total_revenuedecimal(10,2)YES
avg_price_per_productdecimal(10,2)YES
crops_growntextYES
business_typevarchar(50)YES
verified_atdatetimeYES
verified_byvarchar(100)YES
auto_verifiedtinyint(1)YES
deleted_atdatetimeYES

Sample Data:


Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104
idnamephoneaddresscountyconstituencywardNearest_placeemailpasswordroleagedobgendercreated_atverification_statusis_professional_farmerfarm_sizefacebook_urltwitter_urlinstagram_urlis_professionalbusiness_namelicense_numberyears_experienceprofile_imagebusiness_descriptionbusiness_hourscertificationslogoreset_codereset_expiresstatuslast_logintotal_salestotal_ordersacceptance_rateavg_response_timelast_activeretention_ratetotal_revenueavg_price_per_productcrops_grownbusiness_typeverified_atverified_byauto_verifieddeleted_at
97James Rinaldi0711115502MANDERA MANDERA SOUTHManderaMandera southKutuloElkurokipkogeir@gmail.comqMPE5+YM41EyJg==Vendor 2025-07-30 09:37:04verified00.00 0 pending 0.0000.000 0.000.000.00 farmer2026-05-23 14:48:02Gloria0
103Kipkogei Rotich0711509343P.O. Box 39P.O. BOX 364-20103 Baringo Eldama ravine Lembus kwen Sigoro primary school kipkogeir@gmail.comy5CBur0=Vendor 2025-07-30 09:37:04verified00.00 0 pending 0.0000.000 0.000.000.00 farmer2026-05-23 14:47:58Gloria0
104Ben rutto0733588548P.O. Box 39 P.O. BOX 364-20103MombasaChangamwePort reitzBomu primary schoolalembertrots@gmail.comy5CBur0=Vendor 2025-07-30 09:37:04verified00.00 0 pending 0.0000.000 0.000.000.00 farmer2026-05-23 14:47:54Gloria0
106Faith Maina0742702452091-011 RuiruKiambu Juja Murera Murera primary school mainafaith420@gmail.comyZSEvblc51E=Vendor 2025-07-30 09:37:04verified00.00 0 pending 0.0000.000 0.000.000.00 farmer2026-05-23 14:47:50Gloria0
107Dee dd071234567867 kisumu KisumuKisumu eastKajuluRae kajulu primary schooldee@gmail.comypuKub5c5VIyIw==Vendor 2025-07-30 09:37:04verified00.00 0 pending 0.0000.000 0.000.000.00 farmer2026-05-23 14:47:45Gloria0

Table: profarmer_product_bids

Columns:

FieldTypeNullKey
bid_idintNOPRI
product_idintNOMUL
bidder_idintYESMUL
bidder_phonevarchar(20)YES
bidder_namevarchar(100)YES
bidder_typeenum('buyer','trader','professional_buyer','system')YES
bid_amountdecimal(10,2)NO
bid_timedatetimeNO
bid_statusenum('active','outbid','won','starting','cancelled')YESMUL
created_attimestampYES

Sample Data:

No records found in this table.

Table: profarmer_products

Columns:

FieldTypeNullKey
idintNOPRI
professional_farmer_idintNOMUL
product_idintNOMUL
product_namevarchar(255)NO
pricedecimal(10,2)YES
stockintYES
stock_quantityintYES
unitvarchar(50)YES
imagevarchar(255)YES
imagestextYES
videovarchar(255)YES
product_imagevarchar(255)YES
main_imagevarchar(255)YES
categoryvarchar(100)YES
subcategoryvarchar(100)YES
gradevarchar(10)YES
keywordstextYES
price_typevarchar(50)YES
delivery_optionvarchar(100)YES
product_categoryvarchar(100)YES
descriptiontextYES
product_descriptiontextYES
statusvarchar(20)YES
created_attimestampYES
date_addedtimestampYES
bidding_end_timedatetimeYES
bid_incrementdecimal(10,2)YES
is_biddingtinyintYES
farmer_idintNO
quantityintNO
is_featuredtinyint(1)YES
price_with_commissiondecimal(10,2)YES

Sample Data:

No records found in this table.

Table: professional_farmer_documents

Columns:

FieldTypeNullKey
idintNOPRI
professional_farmer_idintNOMUL
document_typeenum('registration_certificate','tax_compliance','identity_document','bank_statement','other')NOMUL
document_namevarchar(255)YES
document_pathvarchar(500)NO
file_sizeintYES
mime_typevarchar(100)YES
upload_datetimestampYES
verifiedtinyint(1)YESMUL
verified_datedatetimeYES
verified_byintYES

Sample Data:

No records found in this table.

Table: professional_farmer_notification_settings

Columns:

FieldTypeNullKey
idintNOPRI
professional_farmer_idintNOUNI
email_notificationstinyint(1)YES
sms_notificationstinyint(1)YES
order_updatestinyint(1)YES
promotional_emailstinyint(1)YES
new_bidstinyint(1)YES
auction_endstinyint(1)YES
created_attimestampYES
updated_attimestampYES

Sample Data:

No records found in this table.

Table: professional_farmer_pending_users

Columns:

FieldTypeNullKey
idintNOPRI
business_namevarchar(200)NO
registration_numbervarchar(100)YES
tax_pinvarchar(100)YES
phonevarchar(20)NOUNI
alternative_phonevarchar(20)YES
emailvarchar(100)NO
farm_descriptiontextYES
countyvarchar(100)NO
constituencyvarchar(100)NO
wardvarchar(100)NO
nearest_placevarchar(100)NO
subscription_planvarchar(50)YES
logovarchar(255)YES
passwordvarchar(255)NO
otp_codevarchar(10)NO
otp_expiresdatetimeNOMUL
attemptsintYES
created_attimestampYES

Sample Data:


Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104
idbusiness_nameregistration_numbertax_pinphonealternative_phoneemailfarm_descriptioncountyconstituencywardnearest_placesubscription_planlogopasswordotp_codeotp_expiresattemptscreated_at
4golden harvest45678899123407999341870702034032salomekionge.avariogroup@gmail.comGolden harvest is a farm that deals with fruits and vegetables fresh from the farm it offers goods in bulk and goods in good qualityKiambuKiambaaKaruriKaruri pri schBasic $2y$10$g1/MlsxVwxbnbNaVaQ/c2uJUcclNRz5F0ur26jJ6DTG74u.0c56Ze2624552026-06-26 05:27:4802026-06-26 05:16:33

Table: professional_farmer_ratings

Columns:

FieldTypeNullKey
idintNOPRI
professional_farmer_idintNOMUL
buyer_idintNOMUL
ratingintNOMUL
reviewtextYES
created_attimestampYES

Sample Data:

No records found in this table.

Table: professional_farmer_store_settings

Columns:

FieldTypeNullKey
idintNOPRI
professional_farmer_idintNOUNI
store_namevarchar(255)YES
store_descriptiontextYES
store_bannervarchar(255)YES
opening_hourstextYES
delivery_radius_kmintYES
delivery_feedecimal(10,2)YES
minimum_order_amountdecimal(10,2)YES
store_activetinyint(1)YESMUL
facebook_urlvarchar(255)YES
twitter_urlvarchar(255)YES
instagram_urlvarchar(255)YES
website_urlvarchar(255)YES
created_attimestampYES
updated_attimestampYES

Sample Data:

No records found in this table.

Table: professional_farmer_withdrawals

Columns:

FieldTypeNullKey
idintNOPRI
professional_farmer_idintNOMUL
amountdecimal(10,2)NO
mpesa_numbervarchar(20)NO
statusenum('pending','processing','completed','failed')YESMUL
transaction_idvarchar(100)YES
processed_byintYES
processed_atdatetimeYES
notestextYES
created_attimestampYES

Sample Data:

No records found in this table.

Table: professional_farmers

Columns:

FieldTypeNullKey
idintNOPRI
business_namevarchar(255)NO
registration_numbervarchar(100)YES
business_reg_numbervarchar(100)YES
business_registration_numbervarchar(100)NO
tax_pinvarchar(100)NO
owner_namevarchar(255)NO
phonevarchar(15)NOUNI
emailvarchar(255)NOUNI
addresstextYES
countyvarchar(100)YES
constituencyvarchar(100)YES
wardvarchar(100)YES
locationvarchar(255)YES
biotextYES
nearest_placevarchar(100)YES
passwordvarchar(255)NO
rolevarchar(50)YES
subscription_plan_idintYESMUL
subscription_planvarchar(50)YES
subscription_statusenum('active','expired','pending','cancelled')YESMUL
subscription_start_datedatetimeYES
subscription_end_datedatetimeYES
verification_statusenum('pending','verified','rejected')YESMUL
verification_documentstextYES
verification_datedatetimeYES
verified_byintYES
store_ratingdecimal(3,2)YES
total_store_reviewsintYES
is_activetinyint(1)YES
last_logindatetimeYES
created_attimestampYES
updated_attimestampYES
reset_tokenvarchar(255)YES
reset_token_expirydatetimeYES
remember_tokenvarchar(255)YES
business_logovarchar(255)YES
year_establishedyearNO
logovarchar(255)YES
reset_codevarchar(6)YES
reset_expiresdatetimeYES
verified_atdatetimeYES
deleted_atdatetimeYES

Sample Data:


Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 104
idbusiness_nameregistration_numberbusiness_reg_numberbusiness_registration_numbertax_pinowner_namephoneemailaddresscountyconstituencywardlocationbionearest_placepasswordrolesubscription_plan_idsubscription_plansubscription_statussubscription_start_datesubscription_end_dateverification_statusverification_documentsverification_dateverified_bystore_ratingtotal_store_reviewsis_activelast_logincreated_atupdated_atreset_tokenreset_token_expiryremember_tokenbusiness_logoyear_establishedlogoreset_codereset_expiresverified_atdeleted_at
7flores xoticas 0768757776jamesdono126@gmail.com BungomaKabuchaiBwake/luuyaKhatiri primary school$2y$10$HcSZF7iY.X.gpUGIcn9wTu5g2XjfMCwDRhkYKZLmOwUI39jj2V96Oprofessional_farmer Premiumactive verified 00.0001 2026-04-19 22:23:352026-06-16 20:37:02 2024farmer_7_1781642212.jpg8496972026-04-29 16:40:442026-05-23 14:36:35
8Nyaboke's lil Farm Ltd 0725438354nyabokeslilfarm@gmail.com KiambuLimuruNgecha tigoni Tigoni primary school$2y$10$Qv4BpWxTVRB9RZG9Wk3C6eZJ4pQahSe/IvyoEEirqceBCju1wvNwuprofessional_farmer Basicpending verified 00.0001 2026-05-02 17:46:322026-05-23 14:36:29 20241777743992_69f6387859022.jpg 2026-05-23 14:36:29
10zico 0706418012nyandozeck@gmail.com KisumuKisumu centralMigosi Hekima, mauwa ground - lolwe$2y$10$oEgZYB473Q4cWExRtRD59.vKouAY.M0303u9xYYyaNxG9VcgWkAcGprofessional_farmer Basicpending verified 00.0001 2026-05-10 19:26:142026-05-23 14:36:24 07a1c65f064449d15b72be2dc7d6fe2e6c12051989524b91aa50447abf8eea88 20241778441174_6a00dbd65e720.webp 2026-05-23 14:36:24
11Bondoni farms 0704414688ericmusyoka135@gmail.com MachakosMasingaMasinga central Masinga dam resort camp site$2y$10$Z.mJel63egVJBwwBgo06QegG/mADsYJ6.JzFpuA8U1GL4qe/P59w2professional_farmer Basicpending verified 00.0001 2026-05-11 06:24:552026-05-23 14:36:18 8afadf575e1f6142ca8c241737c52ca265583520f6caab871c52fd5bb840bcbf 2024 2026-05-23 14:36:18
12Mwavishi Farmer 0793539270cykhabetsa@gmail.com KiambuKiambuTownship Kiambu inst & tech$2y$10$xWQTYqAMltpYR4uUeElcruEBMcQPwdocECXO5EtpMi2AsqEy7/Lx6professional_farmer Basicpending verified 00.0001 2026-05-11 12:17:572026-05-23 14:36:12 2024 2026-05-23 14:36:12

Table: trader_farmer_products

Columns:

FieldTypeNullKey
idintNOPRI
trader_idintNOMUL
farmer_idintNOMUL
farmer_product_idintNO
trader_product_idintNO
farmer_pricedecimal(10,2)NO
trader_pricedecimal(10,2)NO
quantityintYES
purchase_datetimestampYES

Sample Data:

No records found in this table.

Table: vw_professional_farmer_details


Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1356 View 'cuofbpmq_easyagro.vw_professional_farmer_details' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php:73 Stack trace: #0 /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php(73): PDO->query('DESCRIBE vw_pro...') #1 {main} thrown in /home/cuofbpmq/app2.e-azy-agro.com/check_farmer.php on line 73