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

duplicate record notification
In my database, after insertion of records, I want to know if the record inserted is duplicate or no

PECL uploadprogress for php5.2
Hey, I just installed PHP5 via .htaccess on my 1and1 Shared Hosting Account.

How would I exac

Multi-user card game
I'm writing a batch of games and such. Lottery is finished, Poker,blackjack,etc are next. They will

'grab_files', multiple extension?
hey guys,

can anyone suggest a way to make to following line of code look for files with more

LOOPing Problem
Hello All!

The following code loops through the data and displays the data accordingly. My p

Error when call dll from oracle
Hi all, please help me!

I have dll write C language, I want call it from oracle procedur

Search in the PHP Files
have to search asterisk(*) in the php code of the php files .
In the html page one text box

Simple Variable Question
Hi everyone.... again,

I am really getting into php still. Learning more every day. I love it

Showing selected item at top of list
Hi,

I've got a list of names which i am fetching from database like this:
$qry = db_query

first few characters only
hi, does anyone know how to use PHP to take the first few words of a text and limit them? i have see