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

PHP & MS Access - Line Break
Hey Guys!

I'm pulling records from an MS Access database and listing them using PHP and I'm r

Open/Close Links in Php
Hello, Hoping someone can inform me how I can get PHP to automatically open a set of links in a new

Remove values in array2 from array1
I have two arrays.

Array 1 is where the array key holds various different numbers. For exampl

Help: calling function
Hi,
Is it possible to call a php function on page close?
If yes, could you explain how and whe

value not going in data base
hello friends....
i am having a working javascript....when i am selecting any

Question handling xml data
Hello,

I have sucessfull followed this tutorial
http://www.phpfreaks.com/tutorial/handlin

Inserting the current date/time while submitting the forum
What do I need to add below to update the current date/time? I have a field in the database called d

that old Malformed Headers problem again!!!!! HELP!!!!!!
I've read the http://www.phpfreaks.com/forums/index.php/topic,37442.0.html

I don't think my c

values not being entered into table
hi. I;ve created a form, so that when a user enters data into it, it gets added to a table in a data

Product categories for registration
Dear all,

We are going live with the Supplier registered next week. At standard, the 'sel