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

Your Answer:

Login to answer

Other forums

Not adding to db
Hi, I can't figure out why it won't add the record to the database. It's just a simple form to get

what does this mean? +=
is anyone able to explain what this code is saying?

i had it written for me awhile back and n

Login Functionality Working Different on IE
This is an odd one, I have a site which has an admin section. The admin pages unsurprisingly require

How a counter of users ? such as ---> (231 Viewing)
I want to count how many users are actually viewing the page, How is that possible?
Thank you guy

Calander Basic Spript help
hi, just starting out with PHP and have the following script:

<?php
//This gets t

login box shows up again after logging in 2nd login works
Hello,

I am having trouble on my site Lockerz.rack111.com where when you login the login box

Upload file and add HTML
Hey everyone,

I have a client has meeting agendas and minutes that should be posted online. I

Multipe Dynamic Controls & AutoPostback Issue
I currently have a need to create many dynamic controls (Example Textboxes) that need to do a PostBa

count only commas outside parenteses
I have a sql table containing
id - query - query name
the first page contains a drop down men

Fetching META TAGS through
Hello everybody
I want to fetch meta tags of a domain.
It will be done from following code of