query("SHOW COLUMNS FROM users"); while($row = $check_cols->fetch_assoc()){ $cols[] = $row['Field']; } if(!in_array('type', $cols)) $conn->query("ALTER TABLE users ADD COLUMN type VARCHAR(50) DEFAULT 'individual' AFTER id"); if(!in_array('designation', $cols)) $conn->query("ALTER TABLE users ADD COLUMN designation VARCHAR(255) NULL AFTER name"); if(!in_array('address', $cols)) $conn->query("ALTER TABLE users ADD COLUMN address TEXT AFTER phone"); if(!in_array('photo', $cols)) $conn->query("ALTER TABLE users ADD COLUMN photo VARCHAR(255) NULL AFTER address"); if(!in_array('status', $cols)) $conn->query("ALTER TABLE users ADD COLUMN status VARCHAR(20) DEFAULT 'pending' AFTER password"); // Basic check $check = $conn->query("SELECT id FROM users WHERE email='$email'"); if($check->num_rows > 0) { $error = "Email already registered."; } else { $query = "INSERT INTO users (type, name, email, phone, address, password, status) VALUES ('$type', '$name', '$email', '$phone', '$address', '$hashed_password', 'pending')"; if($conn->query($query)) { $success = "Registration successful! Your account is pending admin approval. Login here"; } else { $error = "Registration failed. Please try again."; } } } } require_once 'includes/header.php'; ?>
Logo

BHARTIYA SEVA

Trust Registration & Support Portal

Official Recognition

Access verified government registration data and trust deeds.

Member ID-Cards

Download your official membership certificate instantly.

Signup

Already have an account? Login

I'm not a robot
recaptcha
reCAPTCHA
Privacy - Terms
Go Back to Home