Part 3: How to Build PHP and MySQL CMS Website Software

[PktMma]

I can get it to show 1 element from a database but not all.

[slevin741]

$myconnection wtf is that variable do ??

[Nabstylez]

@slevin741 It connects to your database.

[kizzel77]

Help me someone i get error

"Warning: mysqli_error() expects exactly 1 parameter, 0 given in D:\Hosting\5705737\html\Cpanal­\index.php on line 38"

what does this mean? here is the line of code

$sqlCommand = "SELECT id, linklabel FROM pages WHERE showing='1' ORDER BY id ASC";

$query = mysqli_query($myConnection, $sqlCommand) or die (mysqli_error()

i have team viewer someone please help :)

[Gr0tje]

@kizzel77

if you get this error check if your hosting account support mysqli.

and in most cases you will notice that this is not the case if you get this error.

[RedpandamCorporation]

Hi I watch your videos alot and I cant figure out how to fix this. Please can you help. Thank you for your time.

Warning: mysqli_error() expects exactly 1 parameter, 0 given in /home/intertel/public_html/ind­ex.php on line 13

[Whisperingonthewind]

Hi OB1 AKA Adam, I could not get part of the code to work, it needed isset, works a treat now woop at last. ;~)

if (!isset($_GET['pid'])){ $pageid='1';

Great Tutorials

[TheGODsOPINION]

Hi Flash!

I love your Videos! Keep it up with the good work!

Maybe u can help me also in this case:

I have an HTML PAGE with TEXTAREA, DROP-DOWN-LIST and SUBMIT BUTTON

and lets say User typed "TEXT" in the TEXTAREA and CATEGORIZED it with the DROP-DOWN-LIST OPTION

called "OPTION1". After he hit the SUBMIT Button, I would like that his "TEXT" is saved in the

MYSQL under FIELD "OPTION1".

Whats the PHP Code for that?

Thank you in advance!

[Whisperingonthewind]

Hi Adam Dreamweaver CS5 will not render some of your code.

This code will not render in DWCS5: -

$query = mysqli_query($myConnection, $sqlCommand) or die (mysqli_error());

This code will render in DWCS5: -

$query = mysqli_query($myConnection, $sqlCommand) or die("myConnection: " . mysqli_error());

[rEs0LuTe12]

you should try $pageid = mysql_real_escape_string($_GET­['pid']); to protect it from sql injection, anyways good job with the tutorial. :)

[dragon10y]

Can someone help me with this error ?

Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /public/sites/beta.dragondesig­nz.eu/cms/index.php on line 7

[samiwistler]

PHP gurus

[JJDR04]

Why is is so difficult to post a comment here? I keep geting an error message... something must be wrong with youtube here.

[acchu1986]

thank you so much for the help....

But the query is printing only the last record in the browser. I am trying to complete the videos but i am getting stuck at some point of time.

Thanks

[acchu1986]

Sir , Can you please tell me where is the $myConnection variable in the file .. I did not find it.. I just copied from ur site.

And also I am still getting the error..

Thanks.. Early response would be appreciated

[acchu1986]

Where is the $myConnection .. I am getting error

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home2/xxxxxx/public_html/inde­x.php on line 8

[JJDR04]

@acchu1986

Check the connect_to_mysql.php file inside the scripts folder. Remember that the $myConnection variable is is inside this file. make sure the path to the file is correct.

[JJDR04]

Hi Adam. Is there a way to highlight the generated menu links? In other words, highlight the current selected menu item. Any help will be greatly appreciated.

[JJDR04]

@flashbuilding

I am Still struggling with it.Any luck anybody with highlighting the menu items

please help... Thanks everyone!

[JJDR04]

Hi guys...On page load, I keep getting the message Undefined index: pid in F...

Even when I open the original files I download from Adam's website. I am getting this error in the main index page.

If I click on any of the link buttons, the error disappear. Again, I only get this error when I first open the page on the browser.

Any help will be appreciated... Thanks

[ztarrfect]

@flashbuilding I actually find your voice relaxing on this vid :)

[sackyhead]

I am getting this error: Warning: mysqli_query() expects parameter 1 to be mysqli, null given in C:\xampp\htdocs\NEWCMS\index.p­hp on line 7

Warning: mysqli_error() expects exactly 1 parameter, 0 given in C:\xampp\htdocs\NEWCMS\index.p­hp on line 7

[lilabrowns]

hey adam, i wanna get the last id from the query as my homepage not number 1, like any update on my site should be my homepage for that day,because right now i have to go to my database and change it to number 1 for any new updates to be a homepage ,any help

[lilabrowns]

hey Mr ADAM ,i need some help i wanna make my home page , the last id from query

instedy of 1, like any update on my site that is my home page for that day, any help

[lilabrowns]

To FireFoxConn+ since adam help me very much with this code ,now i'm willing to help others, First i will advice you not to write your own code just go to part 9 of this series and on the info side just click developphp link then you will see search button just enter the title of this series then click -Part 3: How to Build PHP and MySQL Custom CMS Website Software on top you will see zip file for download start from there

[FireFoxConn]

I'm having trouble and I am completly dumbfounded by it. everything in my code looks just like yours. except when I go to load my page up it only shows 1 link not both. and it only shows the about link. I am using the latest firefox but I dont know if that has anything to do with it. please help me?

[112358again]

@FireFoxConn hallo, I believe you have to add a dot after before the equal sign like this:

$menuDisplay .=

Good luck !

[Marine50x]

Is he going to post the html file??

[cedomirovic]

tnx you are the best, i can't wait for part 5

[Evandon1]

I keep getting this error messages and I cant figure why. My code LOOKS identical to yours. Here is the message I get:

Warning: mysqli_error() expects exactly 1 parameter, 0 given in /home/content/e/v/a/.../html/v­smack/index.php on line 6

[Evandon1]

do u have any idea why this is?

[BlackdragonUA]

yea i get the same problem, your tuts are nice but when ppl run into problems like these following your tuts, can use a bit of help..I am not saying that you make bad tutorials i think they are the best but it could be better if in the description you could put solution to errors like that... if you know they are gonna happen

=(

[bezhoedeath]

change this:

$query = mysqli_query($myConnection, $sqlCommand) or die (mysqli_error());

to this one:

$query = mysqli_query($myConnection, $sqlCommand) or die (mysqli_error($myConnection));

i guess the line u must change is on line 6

[Evandon1]

:-)

[MonsterProjectsMedia]

okay, this is more that likely because your referring to a field that is not there. You might have the wrong name or it might not be in the database at all.

[djshaanky]

lol!

[djshaanky]

Man you surely don't sound well on this tuts man whats up? good tut though.

[MainTutorials]

Where is your source code on your website?Please help

[MainTutorials]

Adam where is part two??

[MainTutorials]

ITS UP!!!

[MVParamount]

Quick Question ... What is the difference between MySQLI and MySQL?

[flashbuilding]

I have a page in my MySQL course, right in the beginning section, that discusses it a bit and should explain it all.

[dragon10y]

@flashbuilding Do you know how I can fix this error ?

Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /public/sites/beta.dragondesig­­nz.eu/cms/index.php on line 7

[GrinningSandCat]

With MySQLi it's easy to call stored procedures. You can run multi queries.

[MVParamount]

I think the EXTERNAL CSS would be way better for being able to update the entire site styles in 1 sheet.

[flashbuilding]

In this case not really cuz this entire custom system runs off of 1 file for displaying everything. Saves time and workflow by putting the CSS right in the head tag like I am doing here for styling mostly. I put inline styles for example variety. But for a one page system like what I am building here, you would overcomplicate it by adding External CSS. External CSS is best when you have more than one page or file. Otherwise not needed at all.

[MVParamount]

Makes Sense, lol, I forgot it was all one page.

[lucas199400]

Adam, you should get a cup of coffee before making these tutorials! You sound a bit tired/dull lol

Lovely tutorial series mate!

[mine070]

Where The Hell Is Part 2?

[winfr34k]

where s part 2 :(?

[LevosPro]

Thank you man :)))