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
Create a form of 2 numbers input and find the greatest.
Hi, everybody.I have a homework in my training of php, which ask you to make a form that asks you to input 2 numbers and so tell you which number is greater than the other.I need to know how to make
bit of help needed
Im about to sort out my registration page for my website by customising a "registration" script I came across. It has about all that I need, apart from the changes that i need to make to it
Passing variables with pagination - iterating through unique id per link
Hi everyone,I have seen a few topics like this one. Still cant find the specific thing, so I am asking - does anyone know this?I am trying to combine a mysql query with this code I found at
help with php
It's not displaying or pulling anything out of the database. Code: <html><head><title>Hale's Music World: Inventory Search
ECC6 - Single sign-on
We are in the process of upgrading to ECC 6 which will support single sign on with user passwords aligned by our active directory to the same as those used to access the Network. My query is that we
PHP FTP connect doesn't work with correct login
Hi!i am working on this test code:Quote<?php $ftp_server = "ftp.*******.it";$ftp_user = "weburl@*******.it";$ftp_pass = "CENSORED";// set up a
Email to a friend script problems
I have this send-to-a-friend script with 2 issues:1) When you open the form popup on a particular page, it includes the correct URL for that page (viewable on the popup form). But if you close it, go
Mass activity scheduling
Hi experts,
How do I give a developer access to a specific directory and nothing else?
I want to give a develop access to a specific directory and nothing elseI can give them an FTP account with access to a sub directory, but this doesn't exactly solve the problem!1. They can write PHP
Email logic not working
I would like to send an email using the php email() function then if it does execute i.e sends i would like to update a particular field in my db.however no matter how hard i try to the code seem to