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
Spaghetti Code
So.I've pretty much reached the point where I have so many isset s on one page that I can't tell what the page is supposed to do. In other words: spaghetti code. I just read a few tutorials on OOP,
Motivational Posters
Hello,I wonder how can i do them in php. Are there any sample codes that you can show me?thanks in advance
PHP Session Issue
I'm having an issue with one section on my website dealing with sessions. Now I know that myself and two other individuals can get it to work without any issues on IE, FF, or other browsers, however,
TemplatePower & AJAX
Hi all,I'm currently implementing some AJAX features in my PHP-framework (which is based on TemplatePower) and I have encountered a problem:I have a block which holds a message-div. This block is
Aris, Netweaver BPM, Visual composer and X'app
Dear Experts,
True way to see if action was successful?
If this is a good way to see if action was successful to continue:Code: function changeGameState($GameId) { mysql_query("UPDATE challenges SET status=status+1 WHERE id='$GameId'");
PHP Display Telephone Number On Referrer
I have used the php below to show a different telephone number in the header of the site depending upon where the visitor comes from. The code below works but looses the original referrer information
Javascript form submit and radio buttons?
When this form is submitted, it is automatically resubmitted using JS.All my fields are carried over in the $_post except for total, and state which are radio buttons and a drop down.Code:
Code error with Index.php
Error: Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/runevid/public_html/index.php on line 25<html><head><title>CrazyQuest -
Ignore html and bbcode?
I've created a function to limit the amount of text according to the amount of words.However it ruins html and bbcode tags.. . I only want it to have affect on everything else within $text but not