Hello, i'm working on a "cms" for my website and its supposed to be individual dashboards. Its 3 ranks, admin, partner and trainee. This is for my youtube network and i'm trying to create a form so they can submit videos from there dashboards and then it sends it to my admin panel so I can check it out. I want to have a table display and I want just there submissions they've done displayed and I want it to display like all the fields they have entered and like a status section where i'll like be able to change the status through the admin dashboard. I have no idea how to do the table and have them see just there submissions and me be able to edit it through the admin panel. If any help on that, that would be great. Now i've been working on the form and getting it to submit, but for some reason it won't submit. If any of you can help me out with this it would be great. I'm pretty sure its the query, but not quiet positive. I'm new to php so any help is appreciated.

You need add to submitted_forms new row like show_now - enum('yes', 'no')

Now in the index.php or page where all guests can see the publication, add to WHERE in select query the new row like show_now = 'yes'

create new or edit page, where you will do the check (Edit Page), out all information for check with while.. and add to select WHERE show_now = 'no'

add simple html with 2 input type="radio" to change the value.

sorry for my english

fredrock
—
2014-02-14T14:01:31Z —
#4

Smolf3d said:

You need add to submitted_forms new row like show_now - enum('yes', 'no')

Now in the index.php or page where all guests can see the publication, add to WHERE in select query the new row like show_now = 'yes'

create new or edit page, where you will do the check (Edit Page), out all information for check with while.. and add to select WHERE show_now = 'no'

add simple html with 2 input type="radio" to change the value.

sorry for my english

Please explain more. Are you talking about the table thing? I don't want to display it to guests as you have to login to see the dashboard anyway. I want to show them in there own dashboard only there submissions in a table. I don't want anyone else to see there submissions except the person and admins is all.

fredrock
—
2014-02-14T14:07:55Z —
#5

Drummin said:

Check for possible spelling errors.

Can I assume you have session_start(); at the top of your page???

I made a slightly different copy you might try or compare to what you have.

Ok, i'm getting this error Fatal error: Call to a member function query() on a non-object. And this is the line its on. The one above is the line its on, but i'm just posting the line under it just to see what you think. I completely forgot about this error. I've had it for awhile, its when I submit it.

As I mentioned, if you post the whole code, we could spot errors.Where is $db defined?

This version fixes a number of spelling issues ($POST['vidodescription'], $usename or $username) and your condition line (removing duplicate $v_title and replacing "or" with ||) and escapes data before insert.

Like I said, you say you're using the code in OP but I've asked if you've fixed issues that have been pointed out to you.

As I mentioned, if you post the whole code, we could spot errors.Where is $db defined?

This version fixes a number of spelling issues ($POST['vidodescription'], $usename or $username) and your condition line (removing duplicate $v_title and replacing "or" with ||) and escapes data before insert.

Like I said, you say you're using the code in OP but I've asked if you've fixed issues that have been pointed out to you.

I did fix the issues and $db is defined in my config, which i'm including at the top. The error here is that fatal error which needs fixed. I never saw it before. I guess when it refreshed it was there so i think thats been the error all along. It was hidden because the page is black so I never saw it. Guess its not the query.

Drummin
—
2014-02-16T21:31:13Z —
#17

I did fix the issues and $db is defined in my config, which i'm including at the top. The error here is that fatal error which needs fixed. I never saw it before. I guess when it refreshed it was there so i think thats been the error all along. It was hidden because the page is black so I never saw it. Guess its not the query. Yet once again you haven't posted your latest code. Guess we can't help you.

fredrock
—
2014-02-16T22:58:51Z —
#18

Drummin said:

Yet once again you haven't posted your latest code. Guess we can't help you.