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
Frustrated php Newbie
First off, I am pretty much a PHP nub. I can read and understand the language (most of the time) so
Registration
ok so i have a site where people can register and login which works now thanks to someone on here th
Using mysql_real_escape_string for displayed content
On my website users can input data into a textarea and it will store it in the mysql database. But,
Finding digits in variable containing text, and IDing them
$romanstock = "http://www.remoteprice.com/data.asp?storeid=123&itemcode=456&typ
Strange php code found on my website
I got hacked and the following code was placed within my files:
Code: [Select]<?
/*
losing variables between php brackets
Hi
have got this code:
Code: $id=mysql_result($result,0,"itemid");
$title=mys
An odd assignment statement. Can someone explain this assignment to me?
What purpose is served by the bit of code between the two equal signs in the $installurl set? Is th
split values
I have values that are returned to me in this format:
name=>test,age=>49
Relative path
I have a absolute path to an image - like so: C:/Program Files/Apache Software Foundation/Apache2.2/
Why do I get this error
Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/a5488351/public_html/b
