Welcome! Log In Create A New Profile

Walkthrough 3 - Code for the forum

Announcements		Last Post
	SoC Curricula	09/30/2017 01:08PM
	Demarcation or scoping of examinations and assessment	02/13/2017 07:59AM
	School of Computing Short Learning Programmes	11/24/2014 08:37AM
	Unisa contact information	07/28/2011 01:28PM

Forums Messages New

kreason_77840070

Walkthrough 3 - Code for the forum
March 14, 2013 12:37PM

Registered: 11 years ago
Posts: 36
Rating: 0

Did anyone else get errors with forumTest.php ?
Mine shows:
Notice: Undefined offset: 3 in D:\EasyPHP-5.3.3\www\forum\forumTest.php on line 123
Notice: Undefined offset: 3 in D:\EasyPHP-5.3.3\www\forum\forumTest.php on line 124

Language: PHP
122                          print $tdStart . $secIDs[$i] . $tdEnd;
123				print $tdStart . $numPosts[$i] . $tdEnd;
124				print $tdStart . $numReply[$i] . $tdEnd;

any ideas?

http://capetown-airport.co.za/

Reply Quote

kreason_77840070

Re: Walkthrough 3 - Code for the forum
March 14, 2013 03:04PM

Registered: 11 years ago
Posts: 36
Rating: 0

More info

Theres some problem here

Language: PHP
	if ($db_found) {
 
		for ($i = 1; $i < 6; $i++) {
 
			//==================================================
			//	GET THE NUMBER OF POSTS IN EACH FORUM SECTION
			//==================================================
 
			$SQL = "SELECT * FROM " . $tblPosts[$i];
 
			$result = mysql_query($SQL);
 
			if ($result) {
 
				$num_rows = mysql_num_rows($result);
 
				//==================================================
				//	PUT THE NUMBER OF POSTS INTO AN ARRAY
				//==================================================
				$numPosts[$i] = $num_rows;
 
			}
			else {
				print "error table posts"."<BR>";

http://capetown-airport.co.za/

Reply Quote

Mac

Re: Walkthrough 3 - Code for the forum
March 14, 2013 04:28PM

Admin
Registered: 18 years ago
Posts: 10,001
Rating: 353

Sorry... running around. Will answer tomorrow.

Reply Quote

77998847

Re: Walkthrough 3 - Code for the forum
March 21, 2013 10:51AM

Registered: 11 years ago
Posts: 34
Rating: 0

Not i never experienced any problems, i am using xamp and not easy php
my code is

Language: PHP
if ($db_found) {
 
		for ($i = 1; $i < 6; $i++) {
 
			//==================================================
			//	GET THE NUMBER OF POSTS IN EACH FORUM SECTION	
			//==================================================
 
			$SQL = "SELECT * FROM " . $tblPosts[$i];
 
			$result = mysql_query($SQL);
 
			if ($result) {
 
				$num_rows = mysql_num_rows($result);
 
				//==================================================		
				//	PUT THE NUMBER OF POSTS INTO AN ARRAY
				//==================================================
				$numPosts[$i] = $num_rows;
 
			}
			else {
				print "error";
 
			}
		}
 
			//=========================================================
			//	GET THE NUMBER OF REPLIES IN EACH FORUM SECTION
			//========================================================
 
			for ($i = 1; $i < 6; $i++) {
				$SQL = "SELECT * FROM " . $tblReply[$i];
				$result = mysql_query($SQL);
 
				if ($result) {
 
					$num_rows = mysql_num_rows($result);

I am still trying to find out what could happening to urs, otherwise my application ran ok

..&ru..

Reply Quote

kreason_77840070

Re: Walkthrough 3 - Code for the forum
March 21, 2013 12:48PM

Registered: 11 years ago
Posts: 36
Rating: 0

I'm not getting the "Notice: Undefined offset: 3 " in xamp but its printing error even though the code seems to be executing fine. strange

http://capetown-airport.co.za/

Reply Quote

Shado77968239

Re: Walkthrough 3 - Code for the forum
March 21, 2013 11:47PM

Registered: 11 years ago
Posts: 131
Rating: 0

I did not experience the error but I typed the example out so I might have typed something different.

____________________________________________Nazi Coder____________________________________________

I'm not antisocial, I'm just not user friendly

"It's not a bug; it's an undocumented feature!" ~ some unknown Microsoft developer

Reply Quote

Mac

Re: Walkthrough 3 - Code for the forum
March 22, 2013 08:25AM

Admin
Registered: 18 years ago
Posts: 10,001
Rating: 353

That code is for explanation purposes as such - they know there are 5 posts so they use 6 in the loop

Language: PHP
for ($i = 1; $i < 6; $i++) {

However, if there is not 5 posts but less, it means it will iterate once to many, leading to the offset error.

So one should get the number of rows and use that

Language: PHP
for ($i = 1; $i < $num_rows; $i++) {

I am just picking this up, have not run the code myself again. but in general terms that is why such an error is generated

Reply Quote

77929284

Re: Walkthrough 3 - Code for the forum
April 12, 2013 07:01AM

Registered: 11 years ago
Posts: 38
Rating: 0

Hi all, took a while, but eventually managed to finish this walkthrough's Final Project last week. My biggest challenge was to get the SQL statement right with all the correct ' needed, phew. Maybe I spent too much time on this, but thought it may help me with portfolio.
Cheers

Reply Quote

Mac

Re: Walkthrough 3 - Code for the forum
April 12, 2013 10:21AM

Admin
Registered: 18 years ago
Posts: 10,001
Rating: 353

There is a difference between a back tick and a single quote you use in a SQL query.

a back tick as in `column_name` are used when you use a reserved word as a the column_name - Google for MYSQL reserved words. If you do not back tick it, then your query will never work. Else you do not even have to use backticks.

Reply Quote

afojonny

Re: Walkthrough 3 - Code for the forum
April 22, 2013 06:28PM

Registered: 11 years ago
Posts: 68
Rating: 0

Hi guys,

I see everyone's on the project...nice work guys!

I'm just running through Work-through 3 and i see that most of the links on homeandlearn are not leading to the right places, rather they take me back to the same page. Did anyone encounter this challenge?

Cheers.

78026962 afojonny

Reply Quote

Mac

Re: Walkthrough 3 - Code for the forum
April 23, 2013 09:03AM

Admin
Registered: 18 years ago
Posts: 10,001
Rating: 353

Did you download the fixed HTML zip file from the course website?

Reply Quote

afojonny

Re: Walkthrough 3 - Code for the forum
April 23, 2013 09:25AM

Registered: 11 years ago
Posts: 68
Rating: 0

Hi Mac,

No, i didnt. I am using the one from the sent CD.

78026962 afojonny

Reply Quote

Mac

Re: Walkthrough 3 - Code for the forum
April 23, 2013 11:24AM

Admin
Registered: 18 years ago
Posts: 10,001
Rating: 353

The CD one is incorrect - fixed in Zip file.

Reply Quote

afojonny

Re: Walkthrough 3 - Code for the forum
April 23, 2013 11:38AM

Registered: 11 years ago
Posts: 68
Rating: 0

Thanks Mac, i'd sort that out.

Here's one more question for today (i hope...lol):

How can one change a db table from read only to editable mode? I have been battling the exercise on the 'forum table' page of homeandlearn but not winning.

Thanks in anticipation.

78026962 afojonny

Reply Quote

Mac

Re: Walkthrough 3 - Code for the forum
April 23, 2013 04:43PM

Admin
Registered: 18 years ago
Posts: 10,001
Rating: 353

In phpMyAdmin? Then the table is corrupt. Mark and repair - the function is there.

Reply Quote

M.Sabah

Re: Walkthrough 3 - Code for the forum
May 15, 2013 08:50AM

Registered: 17 years ago
Posts: 60
Rating: 0

Dear Mac

im using files from the CD, and you mentioned about zip file should be download it from website? can you give me a link or how to get to that file please?
Thank you

Mohammed

Reply Quote

Mac

Re: Walkthrough 3 - Code for the forum
May 15, 2013 09:32AM

Admin
Registered: 18 years ago
Posts: 10,001
Rating: 353

Where you downloaded the tut letter... it is there.

Reply Quote

Newer Topic Older Topic

Print View RSS

Sorry, only registered users may post in this forum.

Click here to login