StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POCodeigniter: How to upload files path to database?
primarykey
Id
7863027
data
AcceptedAnswerId
7864537
AnswerCount
4
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-10-22T22:25:18.373
FavoriteCount
0
LastActivityDate
2014-09-30T12:10:38.583
LastEditDate
2011-10-23T06:20:22.773
LastEditorUserId
1009004
OwnerUserId
1009004
ParentId
0
PostTypeId
1
Score
4
ViewCount
11195
LastEditorDisplayName
text
Body
I am trying to put the file path to database, I already uploaded the file but I don't know how to get the path of the file to put it in the database? Here is the controller: <pre><code> <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); class dogo extends CI_Controller { function __construct() { parent::__construct(); $this->load->model('insert_article'); } public function index() { $this->load->view('dogo/dashboard.php'); } //add new post to database including uploading image public function new_post() { //used for the dropdown menu (category) $this->load->model('dogo_cat'); $data['categores_dropdown'] = $this->dogo_cat->get_categories(); //form validation $this->load->library('form_validation');//load the validation library $this->form_validation->set_rules('title', 'title of the post', 'required'); $this->form_validation->set_rules('text', 'text of the post', 'required'); //$this->form_validation->set_rules('image', 'image of the post', 'required'); $this->form_validation->set_rules('category', 'category of the post', 'required'); //the form validation condition if($this->form_validation->run() == FALSE){ //error //$this->view_data $this->load->view('dogo/new_post.php', $data); }else{ //no error in the form $title = $this->input->post('title'); $text = $this->input->post('text'); $category = $this->input->post('category'); $publish = $this->input->post('publish'); //$img_nw = $this->input->post('img_nw'); //$img_nw = $this->input->post('img_nw'); $image_file = $this->input->post('image_file'); //uploading $this->load->model('upload_new_post'); if($this->input->post('upload')){ $this->upload_new_post->do_upload(); //$this->insert_article->insert_new_post($title, $category, $img_nw, $text, $source, $publish); $data['images'] = $this->upload_new_post->get_images(); echo "title of the post: " . $title . " and the text of the post " . $text . " and category is: " . $category . " and publish is: " .$publish . " and image: <pre>" . $do_upload ."</pre>"; //echo $img_nw; $this->load->view('dogo/new_post.php', $data); } } } } </code></pre> And here is the model to upload it: <pre><code> <?php class upload_new_post extends CI_Model{ // retreive categories var $file_path; var $file_path_url; function __construct() { parent::__construct(); $this->file_path = realpath(APPPATH . '../post_data/images'); $this->file_path_url = base_url().'post_data/images/'; } function do_upload(){ $config=array( 'allowed_types' => 'jpg|jpeg|gif|png', 'upload_path' => $this->file_path, 'max_size' => 2000 ); $this->load->library('upload', $config); $this->upload->do_upload(); $image_data = $this->upload->data(); $config = array( 'source_image' => $image_data['full_path'], 'new_image' => $this->file_path . '/thumbs', 'maintain_ration' => true, 'width' => 150, 'height' => 150 ); $this->load->library('image_lib', $config); $this->image_lib->resize(); } function get_images(){ $files = scandir($this->file_path); $files = array_diff($files, array('.', '..', 'thumbs')); $images = array(); foreach ($files as $file){ $images [] = array( 'url' => $this->file_path_url . $file, 'thumb_url' => $this->file_path_url . 'thumbs/' .$file ); } return $images; } } </code></pre> And here the model to insert query: <pre><code> <?php class Insert_article extends CI_Model{ //insert new post function __construct() { parent::__construct(); } function insert_new_post($title, $category, $img_nw, $text, $source, $publish) { $query_insert = "INSERT INTO hs_news_nw (idcat_nw, idsc_nw, idusr_nw, title_nw, img_nw, text_nw, active_nw, totalview_nw, date_nw) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"; $this->db->query($query_insert, array($category, $source, 1, $title, $img_nw, $text, 1, 1000, '2011-10-12 02:01:24')); } } </code></pre>
Tags
<php><codeigniter>
Title
Codeigniter: How to upload files path to database?
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USahmedsaber111
UserOwnerUserId
1. USahmedsaber111
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
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POCodeigniter: How to upload files path to database?
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTApproveEditSuggestion
2. VO
 singulars
 PostPostId
 POCodeigniter: How to upload files path to database?
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 POCodeigniter: How to upload files path to database?
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

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.