update post issues
Posted on
16th Feb 2014 07:03 pm by
admin
I am trying to create an update to a post function, while the update does occur, the page routing and selecting of posts to be updated is whats getting screwed up. I have so many files involved in this whole mess that I didnt know where to start with what. So I went to the trouble of creating a reference page summing up each file, variable, and included file to trace where elements are going.
My website link is:
http://royalvillicus.com/post_ads/controller_posts.php/
I have error reporting on as you will notice.
things to pay attention to:
the url - when clicking on the edit post it will try to access a post id that does not exist
saving changes - url will add a "update" to the end of it. This is meant to be a temp page thanking user for updating page then redirect to list of all posts created which is not happening. This occurs in post_update.php
The link I sent - it is suppose to hold a list of the posts created. Currently there are two in my database. Only the first one is showing.
Here is my reference page:
Quotevariables:
$connection -
model_posts.php
$id -
model_posts.php
$_GET -
index.php
$matches -
index.php
$msg -
controller.php
$_POST -
index.php
$params -
controller_posts.php
create.php
index.php
model_posts.php
post_create.php
post_update.php
$post -
_form.php
_post.php
controller_posts.php
view_post.php
$posts -
controller_posts.php
view_post.php
$query -
model_posts.php
$result -
model_posts.php
$route -
index.php
$routes -
index.php
$route_match -
index.php
$_SESSION -
layout.php
application.php
controller_posts.php
controller.php
$url -
index.php
$urls -
index.php
includes:
application.php -
include_once(VIEW_PATH.'view_posts.php');
config.php -
include_once('controller.php');
controller_posts.php -
include_once ('config.php');
include_once('model_posts.php');
edit.php -
include_once('_form.php');
index.php -
include_once('config.php');
include_once(CONTROL_PATH.$route['control'].'.php');
layout.php -
include_once(VIEW_PATH.'view_posts.php');
model_posts.php -
include_once('config.php');
new.php -
include_once('_form.php');
post_create.php -
include_once('model_posts.php');
post_update.php -
include_once('model_posts.php');
view_posts.php -
include_once('_post.php');
files:
_form.php -
no included files
<fieldset>
no <form>
$post
two text fields - title and body
_post.php -
href="<?php echo APP_ROOT; ?>controller_posts.php/<?php echo $post['id']; ?>"
$post: four parameters - title, body, name, email
no text fields
application.php -
<?php echo $_SESSION['flash']['notice']; ?>
<?php include_once(VIEW_PATH.'view_posts.php'); ?>
<h1>application layout</h1>
no text fields
html output for posts
config.php -
url array routes
defined constants
include_once('controller.php');
controller.php -
function redirect_to($address) {}
flash_warning($msg) {}
flash_notice($msg) {}
$_SESSION['flash']['notice']
$address
$msg
controller_posts.php -
error reporting
include_once ('config.php');
include_once('model_posts.php');
switch ($route['view']) {}
$post = find_post($params['id']);
$posts = find_posts();
create_post ($params['post']
$params['post']['id'] = $params['id'];
update_post ($params['post']
create.php -
<?php print_r($params);?>
edit.php -
<form action="<?php echo APP_ROOT.$route['control']?>.php/<?php echo $post['id']; ?>/update"
include_once('_form.php');
index.php -
include_once('config.php');
function dispatcher($routes) {}
$url = $_SERVER['REQUEST_URI'];
$params = parse_params();
$route_match
$routes
$route
$urls
$matches
include_once(CONTROL_PATH.$route['control'].'.php');
dispatcher($routes);
function parse_params() {
$params = array_merge($params, $_POST);
$_POST
$_GET }
layout.php -
$_SESSION['flash']['notice']
include_once(VIEW_PATH.'view_posts.php');
model_posts.php -
include_once('config.php');
function db_connect () {
$connection
!mysql_select_db(DATABASE, $connection) }
function create_post ($params) {
$query = sprintf();
mysql_real_escape_string($params['title']),
$result = mysql_query($query); }
function update_post ($params) {
$query = sprintf();
mysql_real_escape_string($params['title']),
$result = mysql_query($query); }
function delete_post ($id) {
$query = sprintf();
mysql_real_escape_string($id)
$result = mysql_query($query); }
function find_posts() {
$query =
$result = mysql_query($query);
$number_of_posts = @mysql_num_rows($result);
$result = result_to_array($result) or die("SQL failure: "}
function find_post($id) {
$query = sprintf()
$result = mysql_query($query);
$number_of_posts = @mysql_num_rows($result);
$row = mysql_fetch_array($result);}
function result_to_array($result) {
$result_array = array();
for ($i=0; $row = @mysql_fetch_array($result); $i++) {
$result_array[$i] = $row;}}
new.php -
action="<?php echo APP_ROOT.$route['control']?>.php/creation"
include_once('_form.php');
post_create.php -
include_once('model_posts.php');
create_post ($params['post']);
<meta http-equiv="refresh" content="5;url=/post_ads/controller_posts.php/">
post_update.php -
include_once('model_posts.php');
update_post ($params['post']);
<meta http-equiv="refresh" content="5;url=/post_ads/controller_posts.php/">
view_posts.php -
$posts
$post
foreach($posts as $post) {
include_once('_post.php');}
[<a href="<?php echo APP_ROOT; ?>controller_posts.php/<?php echo $post['id']; ?>/edit">edit post</a>]
This may seem like a lot, atleast it does for me, hopefully this summary I created will prove helpful in what to do next.
I appreciate the help in the matter
No comments posted yet
Your Answer:
Login to answer
205
11
Other forums
remove trailing slash from array
I have the following array which contains trailing slashes I need to remove. What is the best way to
Help with search.php
Hello All
I need the search engine on a site I am building at the moment to display the searc
Multiple forms on the same page (safari)
Hello everyone,
I have 3 forms on the same page, that opens in a new window and submits to a
Mail form doesn't send Russian/Cyrillic characters correctly?
When someone enters foreign characters (like Cyrillic text, and Japanese/Chinese probably gives the
Displaying data from database into a 2 dimensional table
Good day!
I'm a beginner in PHP and I'm not expecting a full coding for this qestion. I'm jus
Array disappearing in foreach loop
Okay, I have this problem where an array will become undefined in a foreach loop.
Here is the
Get word number x from string?
How can I use a function to loop through a string, and "have a look at" every word in the
Date Format
Hi there,
I have a date format like this right now:
Sat, 17 Oct 2009 17:04:00
I ne
Best PHP Documentation generator
Hello guys!
I would like to hear from you what is the best PHP documentation generator. Perso
understanding functions and classes
Code: [Select]
class person {
var $name = "Jimmy Goe";
function get_nam