CREATE TABLE `B0101`(
`B01010010` CHAR(20) NOT NULL,
`B01010020` VARCHAR(255) NOT NULL,
`B01010030` CHAR(2) NOT NULL,
`B01010040` VARCHAR(255) NOT NULL,
`B01010050` VARCHAR(255) NOT NULL,
`B01010060` DATE NOT NULL
);
ALTER TABLE
`B0101` ADD UNIQUE `b0101_b01010010_unique`(`B01010010`);
CREATE TABLE `B0102`(
`B01020010` CHAR(20) NOT NULL,
`B01020020` VARCHAR(255) NOT NULL,
`B01020030` CHAR(2) NOT NULL,
`B01020040` VARCHAR(255) NOT NULL,
`B01020050` VARCHAR(255) NOT NULL,
`B01020060` CHAR(20) NULL,
`B01020070` DATE NOT NULL,
`B01020080` DATE NOT NULL,
`B01020090` DATE NOT NULL,
`B01020100` CHAR(3) NULL,
`B01020110` INT NULL
);
ALTER TABLE
`B0102` ADD UNIQUE `b0102_b01020010_unique`(`B01020010`);
CREATE TABLE `B0103`(
`B01030010` VARCHAR(255) NOT NULL,
`B01030020` CHAR(20) NOT NULL,
`B01030030` VARCHAR(255) NOT NULL,
`B01030040` CHAR(2) NOT NULL
);
ALTER TABLE
`B0103` ADD UNIQUE `b0103_b01030010_unique`(`B01030010`);
ALTER TABLE
`B0103` ADD UNIQUE `b0103_b01030020_unique`(`B01030020`);
CREATE TABLE `B0201`(
`B02010010` VARCHAR(255) NOT NULL,
`B02010020` VARCHAR(255) NOT NULL,
`B02010030` VARCHAR(255) NULL,
`B02010040` INT NOT NULL,
`B02010050` CHAR(3) NOT NULL
);
ALTER TABLE
`B0201` ADD UNIQUE `b0201_b02010010_unique`(`B02010010`);
CREATE TABLE `B0202`(
`B02020010` VARCHAR(255) NOT NULL,
`B02020020` CHAR(20) NOT NULL,
`B02020030` VARCHAR(255) NOT NULL,
`B02020040` VARCHAR(255) NULL,
`B02020050` VARCHAR(5) NOT NULL,
`B02020060` VARCHAR(50) NOT NULL,
`B02020070` DATE NOT NULL,
`B02020080` DATE NOT NULL,
`B02020090` VARCHAR(255) NULL,
`B02020100` INT NULL,
`B02020110` INT NULL,
`B02020120` CHAR(2) NULL,
`B02020130` CHAR(2) NOT NULL,
`B02020140` BOOLEAN NOT NULL,
`B02020150` CHAR(2) NOT NULL,
`B02020160` CHAR(2) NOT NULL,
`B02020170` VARCHAR(20) NULL,
`B02020180` VARCHAR(20) NULL
);
ALTER TABLE
`B0202` ADD UNIQUE `b0202_b02020010_unique`(`B02020010`);
ALTER TABLE
`B0202` ADD UNIQUE `b0202_b02020020_unique`(`B02020020`);
ALTER TABLE
`B0202` ADD UNIQUE `b0202_b02020030_unique`(`B02020030`);
ALTER TABLE
`B0202` ADD UNIQUE `b0202_b02020050_unique`(`B02020050`);
ALTER TABLE
`B0202` ADD UNIQUE `b0202_b02020060_unique`(`B02020060`);
ALTER TABLE
`B0202` ADD UNIQUE `b0202_b02020130_unique`(`B02020130`);
ALTER TABLE
`B0202` ADD UNIQUE `b0202_b02020150_unique`(`B02020150`);
ALTER TABLE
`B0202` ADD UNIQUE `b0202_b02020160_unique`(`B02020160`);
CREATE TABLE `B0203`(
`B02030010` VARCHAR(255) NOT NULL,
`B02030020` VARCHAR(255) NOT NULL
);
ALTER TABLE
`B0203` ADD UNIQUE `b0203_b02030010_unique`(`B02030010`);
ALTER TABLE
`B0203` ADD UNIQUE `b0203_b02030020_unique`(`B02030020`);
CREATE TABLE `B0301`(
`B03010010` VARCHAR(255) NOT NULL,
`B03010020` CHAR(20) NOT NULL
);
ALTER TABLE
`B0301` ADD UNIQUE `b0301_b03010010_unique`(`B03010010`);
ALTER TABLE
`B0301` ADD UNIQUE `b0301_b03010020_unique`(`B03010020`);
CREATE TABLE `B0302`(
`B03020010` VARCHAR(255) NOT NULL,
`B03020020` VARCHAR(255) NOT NULL,
`B03020030` VARCHAR(255) NULL
);
ALTER TABLE
`B0302` ADD UNIQUE `b0302_b03020010_unique`(`B03020010`);
ALTER TABLE
`B0302` ADD UNIQUE `b0302_b03020020_unique`(`B03020020`);
CREATE TABLE `B0303`(
`B03030010` VARCHAR(255) NOT NULL,
`B03030020` CHAR(20) NOT NULL
);
ALTER TABLE
`B0303` ADD UNIQUE `b0303_b03030010_unique`(`B03030010`);
ALTER TABLE
`B0303` ADD UNIQUE `b0303_b03030020_unique`(`B03030020`);
CREATE TABLE `B0401`(
`B04010010` VARCHAR(255) NOT NULL,
`B04010020` CHAR(20) NOT NULL,
`B04010030` BOOLEAN NOT NULL,
`B04010040` VARCHAR(255) NOT NULL
);
ALTER TABLE
`B0401` ADD UNIQUE `b0401_b04010010_unique`(`B04010010`);
ALTER TABLE
`B0401` ADD UNIQUE `b0401_b04010020_unique`(`B04010020`);
CREATE TABLE `B0501`(
`B05010010` VARCHAR(255) NOT NULL,
`B05010020` VARCHAR(255) NOT NULL,
`B05010030` INT NULL,
`B05010040` VARCHAR(255) NULL,
`B05010050` VARCHAR(255) NOT NULL,
`B05010060` VARCHAR(255) NULL,
`B05010070` VARCHAR(50) NOT NULL,
`B05010080` CHAR(2) NOT NULL,
`B05010090` CHAR(30) NULL,
`B05010100` INT NULL,
`B05010110` VARCHAR(255) NOT NULL,
`B05010120` VARCHAR(255) NULL
);
ALTER TABLE
`B0501` ADD UNIQUE `b0501_b05010010_unique`(`B05010010`);
CREATE TABLE `B0502`(
`B05020010` VARCHAR(255) NOT NULL,
`B05020020` VARCHAR(50) NOT NULL,
`B05020030` VARCHAR(255) NOT NULL,
`B05020040` VARCHAR(255) NULL,
`B05020050` INT NOT NULL,
`B05020060` VARCHAR(255) NOT NULL,
`B05020070` VARCHAR(255) NULL
);
ALTER TABLE
`B0502` ADD UNIQUE `b0502_b05020010_unique`(`B05020010`);
ALTER TABLE
`B0502` ADD UNIQUE `b0502_b05020020_unique`(`B05020020`);
ALTER TABLE
`B0502` ADD UNIQUE `b0502_b05020030_unique`(`B05020030`);
ALTER TABLE
`B0502` ADD UNIQUE `b0502_b05020050_unique`(`B05020050`);
ALTER TABLE
`B0502` ADD UNIQUE `b0502_b05020060_unique`(`B05020060`);
CREATE TABLE `B0601`(
`B06010010` VARCHAR(5) NOT NULL,
`B06010020` VARCHAR(255) NOT NULL,
`B06010030` VARCHAR(255) NOT NULL,
`B06010040` CHAR(20) NOT NULL,
`B06010050` VARCHAR(255) NOT NULL,
`B06010060` VARCHAR(255) NOT NULL,
`B06010070` DATE NOT NULL,
`B06010080` INT NOT NULL,
`B06010090` INT NOT NULL,
`B06010100` VARCHAR(20) NOT NULL
);
ALTER TABLE
`B0601` ADD UNIQUE `b0601_b06010010_unique`(`B06010010`);
ALTER TABLE
`B0601` ADD UNIQUE `b0601_b06010040_unique`(`B06010040`);
CREATE TABLE `B0701`(
`B07010010` VARCHAR(255) NOT NULL,
`B07010020` VARCHAR(255) NOT NULL,
`B07010030` VARCHAR(255) NULL,
`B07010040` VARCHAR(255) NOT NULL,
`B07010050` VARCHAR(255) NOT NULL,
`B07010060` VARCHAR(255) NULL,
`B07010070` DATE NOT NULL,
`B07010080` BOOLEAN NOT NULL,
`B07010090` VARCHAR(255) NOT NULL,
`B07010100` VARCHAR(255) NOT NULL,
`B07010110` VARCHAR(255) NOT NULL,
`B07010120` VARCHAR(255) NULL
);
ALTER TABLE
`B0701` ADD UNIQUE `b0701_b07010010_unique`(`B07010010`);
ALTER TABLE
`B0701` ADD UNIQUE `b0701_b07010020_unique`(`B07010020`);
ALTER TABLE
`B0701` ADD UNIQUE `b0701_b07010040_unique`(`B07010040`);
CREATE TABLE `Type of ICT Services`(
`Type of ICT services identifier` VARCHAR(50) NOT NULL,
`Type of ICT services name` VARCHAR(50) NOT NULL,
`Type of ICT services description` VARCHAR(255) NOT NULL
);
ALTER TABLE
`Type of ICT Services` ADD UNIQUE `type of ict services_type of ict services identifier_unique`(
`Type of ICT services identifier`
);
SELECT * FROM B0101;
<?php
// Prepare an insert statement for the B0101 table
$q = $mysqli->prepare(
"INSERT INTO `B0101` (`B01010010`, `B01010020`, `B01010030`, `B01010040`, `B01010050`, `B01010060`)
VALUES (?, ?, ?, ?, ?, ?)"
);
// Check if the prepare failed
if ($q === false) {
die("Prepare failed: " . $mysqli->error);
}
// Sample data to insert (replace these with actual values)
$user_id = 'some_id'; // Replace with actual user ID
$user_name = 'some_name'; // Replace with actual name
$user_type = '01'; // Assuming this is a 2-character field
$user_email = 'some_email@example.com'; // Replace with actual email
$user_phone = '1234567890'; // Replace with actual phone
$join_date = date('Y-m-d'); // Current date
// Bind parameters to the statement
if (!$q->bind_param("ssssss", $user_id, $user_name, $user_type, $user_email, $user_phone, $join_date)) {
die("Bind failed: " . $q->error);
}
// Execute the insert statement
if (!$q->execute()) {
die("Insertion failed: " . $q->error);
} else {
echo "Record inserted successfully.<br>";
echo "Affected rows: " . $mysqli->affected_rows . "<br>";
}
// Close the prepared statement
$q->close();
// Now we will try to select all records from B0101
$result = mysqli_query($mysqli, "SELECT * FROM B0102");
// Check for query execution errors
if (!$result) {
die("Query failed: " . mysqli_error($mysqli));
} else {
// Check if there are any rows returned and output them
if (mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_assoc($result)) {
print_r($row); // Prints each row as an associative array
}
} else {
echo "No records found.";
}
}
// Close the connection
$mysqli->close();