StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POCodeigniter Noob problems
primarykey
Id
8203115
data
AcceptedAnswerId
8203262
AnswerCount
1
ClosedDate
CommentCount
6
CommunityOwnedDate
CreationDate
2011-11-20T17:04:31.597
FavoriteCount
0
LastActivityDate
2018-04-22T09:03:13.910
LastEditDate
2018-04-22T09:03:13.910
LastEditorUserId
727208
OwnerUserId
939421
ParentId
0
PostTypeId
1
Score
2
ViewCount
427
LastEditorDisplayName
text
Body
<p>I am noob in CI and I can't insert a data in database, here is all I have done, it doesn't show me an error but i don't get a result,</p> <p>admin.php (controller)</p> <pre><code>public function postnews(){ $ip = $_SERVER['REMOTE_ADDR']; if ($ip == "my ip address"){ session_start(); if (!isset($_SESSION['admin'])){ $this->load->view('admin-login'); die(0); } if ($_SESSION['admin'] != 'loged'){ $this->load->view('admin-login'); die(0); } if ($_SESSION['admin'] == 'loged'){ if (isset($_POST['title'])and isset($_POST['main-poster']) and isset($_POST['type']) and isset($_POST['year']) and isset($_POST['language'])and isset($_POST['platform'])and isset($_POST['publisher'])and isset($_POST['size'])and isset($_POST['graphics'])and isset($_POST['little-info'])and isset($_POST['full-info'])and isset($_POST['posters'])and isset($_POST['screenshots'])and isset($_POST['trailers'])and isset($_POST['gameplays'])and isset($_POST['author'])){ $title = $_POST['title']; $main_poster = $_POST['main-poster']; $type = $_POST['type']; $year = $_POST['year']; $language = $_POST['language']; $platform = $_POST['platform']; $publisher = $_POST['publisher']; $size = $_POST['size']; $graphics = $_POST['graphics']; $little_info = $_POST['little-info']; $full_info = $_POST['full-info']; $posters = $_POST['posters']; $screenshots = $_POST['screenshots']; $trailers = $_POST['trailers']; $gameplays = $_POST['gameplays']; $autor = $_POST['author']; $date = date("d.m.Y"); $this->load->model('Gamesmodel'); echo $this->Gamesmodel->PostArticle($title, $main_poster, $type, $year, $language, $platform, $publisher, $size, $graphics, $little_info, $full_info, $posters, $screenshots, $trailers, $gameplays, $autor, $date); }else{ $this->load->view('postnews'); } } } else { $this->load->view('404.htm'); die(0); } } </code></pre> <p>gamemodel.php model</p> <pre><code><?php class Gamesmodel extends CI_Model { function __construct() { // Call the Model constructor parent::__construct(); } function PostArticle($title, $main_poster, $type, $year, $language, $platform, $publisher, $size, $graphics, $little_info, $full_info, $posters, $screenshots, $trailers, $gameplays, $autor, $date) { $sql = "INSERT INTO game-articles (id, title, type, year, language, platform, publisher, size, graphics, little-info, full-info, posters, screenshots, trailers, gameplays, date, author) VALUES ('' ,".$this->db->escape($title).",".$this->db->escape($main_poster).",".$this->db->escape($type).",".$this->db->escape($year).",".$this->db->escape($language).",".$this->db->escape($platform).",".$this->db->escape($publisher).",".$this->db->escape($size).",".$this->db->escape($graphics).",".$this->db->escape($little_info).",".$this->db->escape($full_info).",".$this->db->escape($posters).",".$this->db->escape($screenshots).",".$this->db->escape($trailers).",".$this->db->escape($gameplays).",".$this->db->escape($date).",".$this->db->escape($author).")"; $this->db->query($sql); return $this->db->affected_rows(); } } </code></pre> <p>postnews.php view</p> <pre><code><!DOCTYPE HTML> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Post News</title> </head> <body style="background-color:black;"> <div style="margin:auto auto auto auto; width:800px; background-color:white; padding-top:20px; padding-bottom:20px; text-align:center;"> <form action="http://www.gameslib.net/admin/postnews" method="post"><br /> <input type="text" placeholder="title" name="title" style="width:300px;" /><br /> <input type="text" placeholder="main poster" name="main-poster" style="width:300px;" /><br /> <input type="text" placeholder="type" name="type" style="width:300px;" /><br /> <input type="text" placeholder="year" name="year"/><br /> <input type="text" placeholder="language" name="language" style="width:300px;" /><br /> <input type="text" placeholder="platform" name="platform" style="width:300px;" /><br /> <input type="text" placeholder="publisher" name="publisher" style="width:300px;" /><br /> <input type="text" placeholder="size" name="size"/><br /> <input type="text" placeholder="graphics" name="graphics" style="width:300px;" /><br /> <textarea name="little-info" placeholder="little-info" style="width:600px; height:100px;" ></textarea><br /> <textarea name="full-info" placeholder="full-info" style="width:600px; height:200px;" ></textarea><br /> <textarea name="posters" placeholder="posters" style="width:600px; height:50px;" ></textarea><br /> <textarea name="screenshots" placeholder="screenshots" style="width:600px; height:50px;" ></textarea><br /> <textarea name="trailes" placeholder="trailes" style="width:600px; height:50px;" ></textarea><br /> <textarea name="gameplays" placeholder="gameplays" style="width:600px; height:50px;" ></textarea><br /> <input type="text" placeholder="author" name="author" /><br /> <input type="submit" value="P O S T"/><br /> <input type="reset" value="reset"/><br /> </form> </div> </body> </html> </code></pre> <p>please help me, I copied allmost everything to be shure I am not ignoring something,</p>
Tags
<php><codeigniter>
Title
Codeigniter Noob problems
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. UStereško
UserOwnerUserId
1. USIrakli
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POCodeigniter Noob problems
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.