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

Content-Disposition: attachment; filename=... not working as i thought it should
taken the following code from the php.net site the script is not working.

what is not happeni

please hep to get values from a table row
can anyone tel me how I can select and get data from one row by pressing an Edit button in that row

Thread in PHP
Thread in PHP
Some basic use and basic code for thread in php
This is my question?

unexpected T_VARIABLE error
Hey all! I'm getting an unexpected T_VARIABLE with the following function:

function getHighes

DateObject and Nulls
Hi all,

I have an array mapped to a value object. One of the items in the array is a PHP Date

private constructor
Hello,

Can we create a constructor as private? If yes, what is the use of it? If no, why can'

Generating unique numbers using php
Hi,
I need help in generating unique number using php.I tired using rand() in php.But, by using r

Will this protect from mysql injection?
I do not want anything like DROP TABLE to work or any type of coding..

Heres my code.. is it

Get relative path from absolute path
How would one go about getting the relative path to a file from its absolute path?

GET vs SUBMIT Button to show sections on one index.php page?
Just curious if one of these ways is better (i.e. more efficient) than the other.

I have a