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
CU&UC guide
Hi Gurus,
can anybody provide me the link for CU&UC upgrade guide
Thanks i
problem with sql querry in php script
Hello guys,
What I want to do is I want to read out a csv file and then but te conent ot the
Need Successful Return
Hello I am currently working a form here, and I have everything figured out except when I click the
Find only certain URLs from page ... regex (semi-complete script)
Hi guys,
What I need to do is take a page & extract all the URLs from the page &a
Good Programming and Web Design Books
Hi,
I recived a pm today from a fellow phpfreaker regarding php books, i replied with the fo
Grouping and sorting results
Please help with this query.
I have 2 tables in a database, countires and cities. states look
PHP header help!
Hi all I am trying to get this php page to refresh every 5 seconds on my phone which is an aastra 48
Displaying data from MySql a different way
Hi all,
I'm pretty new to php and MySql and have hit a problem.
I am able to display data
SMTP server...
I recently found a tutorial online on SMTP authentification for sending emails from webpages, here i
MySQL noob question
hi guys
I have a simple mysql table set up, along the lines of
Col 1 - Col 2 - Date_l