Reply to thread

Message

<blockquote data-quote="GarettM" data-source="post: 308988" data-attributes="member: 839">Here is what i did to make this work.Created a table called JayCustom.groups;[CODE]CREATE DATABASE JayCustom;CREATE TABLE JayCustom.groups(&nbsp; &nbsp; `id` INT NOT NULL AUTO_INCREMENT,&nbsp; &nbsp; `name` TINYTEXT DEFAULT NULL,&nbsp; &nbsp; `desc` MEDIUMTEXT DEFAULT NULL,&nbsp; &nbsp; `badge` TINYTEXT DEFAULT NULL,&nbsp; &nbsp; `ownerid` MEDIUMINT NOT NULL,&nbsp; &nbsp; `created` DATETIME DEFAULT CURRENT_TIMESTAMP,&nbsp; &nbsp; `roomid` INT DEFAULT NULL,&nbsp; &nbsp; `locked` ENUM('open', 'closed', 'locked') DEFAULT 'open',&nbsp; &nbsp; `privacy` ENUM('open', 'blocked') DEFAULT 'open',&nbsp; &nbsp; PRIMARY KEY (id)) Engine=InnoDB;[/CODE]used mysqli query and ran this query.[CODE]INSERT INTO groups (`name`, `desc`, `badge`, `ownerid`, `created`, `roomid`, `locked`, `privacy`) VALUES ('Staff', 'Official Staff Group!', 'staff', '1', '2014-10-20 07:09:29', '1', 'open', 'open');[/CODE]Here are the variables i used.[PHP]&nbsp;# Variables&nbsp;$name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =&nbsp; &nbsp; 'Staff';&nbsp;$description&nbsp; &nbsp; =&nbsp; &nbsp; 'Official Staff Group!';&nbsp;$badge&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =&nbsp; &nbsp; 'staff'; // sorry don't know the staff badge code.&nbsp;$owner&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =&nbsp; &nbsp; 1; // USER_ID&nbsp;// Date must be formated YYYY-MM-DD HH:MM:SS&nbsp;$created&nbsp; &nbsp; &nbsp; &nbsp; =&nbsp; &nbsp; date('Y-m-d h:i:s', time()); // should be 2014-10-20 10:59:23 - My local Time. Location: Gresham, OR, United States of America.&nbsp;$room&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =&nbsp; &nbsp; 1;&nbsp;$locked&nbsp; &nbsp; &nbsp; &nbsp; =&nbsp; &nbsp; 'open';&nbsp;$privacy&nbsp; &nbsp; &nbsp; &nbsp; =&nbsp; &nbsp; 'open';&nbsp;# Run Query&nbsp;$query = dbquery(&nbsp; &nbsp; sprintf(&nbsp; &nbsp; &nbsp; &nbsp; &quot;INSERT INTO `groups` (`name`, `desc`, `badge`, `ownerid`, `created`, `roomid`, `locked`, `privacy`) VALUES ('%s', '%s', '%s', '%d', '%s', '%d', '%s', '%s');&quot;,&nbsp; &nbsp; &nbsp; &nbsp; $name,&nbsp; &nbsp; &nbsp; &nbsp; $description,&nbsp; &nbsp; &nbsp; &nbsp; $badge,&nbsp; &nbsp; &nbsp; &nbsp; $owner,&nbsp; &nbsp; &nbsp; &nbsp; $created,&nbsp; &nbsp; &nbsp; &nbsp; $room,&nbsp; &nbsp; &nbsp; &nbsp; $locked,&nbsp; &nbsp; &nbsp; &nbsp; $privacy&nbsp; &nbsp; )&nbsp;);&nbsp;if($query == true) {&nbsp; &nbsp; echo 'The Group was created successfully &lt;br /&gt;';&nbsp;} else {&nbsp; &nbsp; echo 'The Group was not created successfully &lt;br /&gt;';&nbsp;}[/PHP]Here is the full script,[PHP]&lt;?php&nbsp;# Time zone&nbsp;date_default_timezone_set('UTC');&nbsp;# Simple Database Query&nbsp;$database = new mysqli('localhost', 'root', 'devbest', 'JayCustom'); // i don't care if my development servers password is on devbest&nbsp;if($database-&gt;connect_errno) {&nbsp; &nbsp; echo sprintf('Script Error: The database could not connect because &quot;%s&quot;', $database-connect_error);&nbsp; &nbsp; exit;&nbsp;}&nbsp;function dbquery($query) {&nbsp; &nbsp; global $database;&nbsp; &nbsp; if($result = $database-&gt;query($query)) {&nbsp; &nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; }&nbsp; &nbsp; return false;&nbsp;}&nbsp;# Variables&nbsp;$name = 'Staff';&nbsp;$description = 'Official Staff Group!';&nbsp;$badge&nbsp; = 'staff'; // sorry don't know the staff badge code.&nbsp;$owner = 1; // USER_ID&nbsp;// Date must be formated YYYY-MM-DD HH:MM:SS&nbsp;$created = date('Y-m-d h:i:s', time()); // should be 2014-10-20 10:59:23 - My local Time. Location: Gresham, OR, United States of America.&nbsp;$room&nbsp; = 1;&nbsp;$locked = 'open';&nbsp;$privacy =&nbsp; 'open';&nbsp;# Run Query&nbsp;$query = dbquery(&nbsp; &nbsp; sprintf(&nbsp; &nbsp; &nbsp; &nbsp; &quot;INSERT INTO `groups` (`name`, `desc`, `badge`, `ownerid`, `created`, `roomid`, `locked`, `privacy`) VALUES ('%s', '%s', '%s', '%d', '%s', '%d', '%s', '%s');&quot;,&nbsp; &nbsp; &nbsp; &nbsp; $name,&nbsp; &nbsp; &nbsp; &nbsp; $description,&nbsp; &nbsp; &nbsp; &nbsp; $badge,&nbsp; &nbsp; &nbsp; &nbsp; $owner,&nbsp; &nbsp; &nbsp; &nbsp; $created,&nbsp; &nbsp; &nbsp; &nbsp; $room,&nbsp; &nbsp; &nbsp; &nbsp; $locked,&nbsp; &nbsp; &nbsp; &nbsp; $privacy&nbsp; &nbsp; )&nbsp;);# Results&nbsp;if($query == true) {&nbsp; &nbsp; echo 'The Group was created successfully &lt;br /&gt;';&nbsp;} else {&nbsp; &nbsp; echo 'The Group was not created successfully &lt;br /&gt;';&nbsp;}[/PHP]IMPORTANT NOTE!!!Programmers don't recommend using $_POST, $_GET or $_SERVER variables directly[PHP]&lt;?php# standards don't recommend using $_POST, $_$SERVER or $_GET directly.&nbsp;$rid&nbsp; &nbsp; = (int) filter_input(INPUT_POST, 'room_id');&nbsp;$name&nbsp; &nbsp; = filter_input(INPUT_POST, 'name', FILTER_SANITIZE_SPECIAL_CHARS);&nbsp;$desc&nbsp; &nbsp; = filter_input(INPUT_POST, 'desc', FILTER_SANITIZE_SPECIAL_CHARS);&nbsp;$priv&nbsp; &nbsp; = filter_input(INPUT_POST, 'priv', FILTER_SANITIZE_SPECIAL_CHARS);&nbsp;$stat&nbsp; &nbsp; = filter_input(INPUT_POST, 'stat', FILTER_SANITIZE_SPECIAL_CHARS);&nbsp;$badge = filter_input(INPUT_POST, 'img',&nbsp; FILTER_SANITIZE_SPECIAL_CHARS);&nbsp;$date&nbsp; = date('Y-m-d h:i:s', time());[/PHP]</blockquote>

[QUOTE="GarettM, post: 308988, member: 839"] Here is what i did to make this work. Created a table called JayCustom.groups; [CODE] CREATE DATABASE JayCustom; CREATE TABLE JayCustom.groups ( `id` INT NOT NULL AUTO_INCREMENT, `name` TINYTEXT DEFAULT NULL, `desc` MEDIUMTEXT DEFAULT NULL, `badge` TINYTEXT DEFAULT NULL, `ownerid` MEDIUMINT NOT NULL, `created` DATETIME DEFAULT CURRENT_TIMESTAMP, `roomid` INT DEFAULT NULL, `locked` ENUM('open', 'closed', 'locked') DEFAULT 'open', `privacy` ENUM('open', 'blocked') DEFAULT 'open', PRIMARY KEY (id) ) Engine=InnoDB; [/CODE] used mysqli query and ran this query. [CODE]INSERT INTO groups (`name`, `desc`, `badge`, `ownerid`, `created`, `roomid`, `locked`, `privacy`) VALUES ('Staff', 'Official Staff Group!', 'staff', '1', '2014-10-20 07:09:29', '1', 'open', 'open');[/CODE] Here are the variables i used. [PHP] # Variables $name = 'Staff'; $description = 'Official Staff Group!'; $badge = 'staff'; // sorry don't know the staff badge code. $owner = 1; // USER_ID // Date must be formated YYYY-MM-DD HH:MM:SS $created = date('Y-m-d h:i:s', time()); // should be 2014-10-20 10:59:23 - My local Time. Location: Gresham, OR, United States of America. $room = 1; $locked = 'open'; $privacy = 'open'; # Run Query $query = dbquery( sprintf( "INSERT INTO `groups` (`name`, `desc`, `badge`, `ownerid`, `created`, `roomid`, `locked`, `privacy`) VALUES ('%s', '%s', '%s', '%d', '%s', '%d', '%s', '%s');", $name, $description, $badge, $owner, $created, $room, $locked, $privacy ) ); if($query == true) { echo 'The Group was created successfully '; } else { echo 'The Group was not created successfully '; } [/PHP] Here is the full script, [PHP] <?php # Time zone date_default_timezone_set('UTC'); # Simple Database Query $database = new mysqli('localhost', 'root', 'devbest', 'JayCustom'); // i don't care if my development servers password is on devbest if($database->connect_errno) { echo sprintf('Script Error: The database could not connect because "%s"', $database-connect_error); exit; } function dbquery($query) { global $database; if($result = $database->query($query)) { return true; } return false; } # Variables $name = 'Staff'; $description = 'Official Staff Group!'; $badge = 'staff'; // sorry don't know the staff badge code. $owner = 1; // USER_ID // Date must be formated YYYY-MM-DD HH:MM:SS $created = date('Y-m-d h:i:s', time()); // should be 2014-10-20 10:59:23 - My local Time. Location: Gresham, OR, United States of America. $room = 1; $locked = 'open'; $privacy = 'open'; # Run Query $query = dbquery( sprintf( "INSERT INTO `groups` (`name`, `desc`, `badge`, `ownerid`, `created`, `roomid`, `locked`, `privacy`) VALUES ('%s', '%s', '%s', '%d', '%s', '%d', '%s', '%s');", $name, $description, $badge, $owner, $created, $room, $locked, $privacy ) ); # Results if($query == true) { echo 'The Group was created successfully '; } else { echo 'The Group was not created successfully '; } [/PHP] IMPORTANT NOTE!!! Programmers don't recommend using $_POST, $_GET or $_SERVER variables directly [PHP] <?php # standards don't recommend using $_POST, $_$SERVER or $_GET directly. $rid = (int) filter_input(INPUT_POST, 'room_id'); $name = filter_input(INPUT_POST, 'name', FILTER_SANITIZE_SPECIAL_CHARS); $desc = filter_input(INPUT_POST, 'desc', FILTER_SANITIZE_SPECIAL_CHARS); $priv = filter_input(INPUT_POST, 'priv', FILTER_SANITIZE_SPECIAL_CHARS); $stat = filter_input(INPUT_POST, 'stat', FILTER_SANITIZE_SPECIAL_CHARS); $badge = filter_input(INPUT_POST, 'img', FILTER_SANITIZE_SPECIAL_CHARS); $date = date('Y-m-d h:i:s', time()); [/PHP] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members