📄 File: table.php

Path: //home2/outerorb/dev.outerorbittech.com/erp/table.php

Size: 730 B

Permissions: 0644

<?php 

// function to add connection page code 

include"connection.php";

$qe="

CREATE TABLE `client` (

  `aid` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,

  `invno` varchar(100) DEFAULT NULL,

  `type` varchar(150) DEFAULT NULL,

  `name` varchar(40) DEFAULT NULL,

  `street` varchar(100) DEFAULT NULL,

  `city` varchar(100) DEFAULT NULL,

  `state` varchar(100) DEFAULT NULL,

  `zip` varchar(50) DEFAULT NULL,

  `email` varchar(255) DEFAULT NULL,

  `altemail` varchar(255) DEFAULT NULL,

  `date` date DEFAULT NULL,

  `amount` varchar(255) DEFAULT NULL)";

$sqe=mysqli_query($cn,$qe);

if($sqe)

	{

		echo 'created';

	}

	else 

	{

		// function to show sql query error 

		echo'<br>'.mysqli_error($cn);

	}



?>

← Back to Directory Edit File 🔒 Chmod