Your browser does not seem to support CSS. If images appear below, please disregard them.
toggle
July
S M T W T F S
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31
Sponsored Links
Latest Postings
· Blackbeard.....
by Gremelin on 07/04/16 08:31 PM
Topic Options
Rate This Topic
#19303 - 01/14/04 12:16 AM Help: Simple (yeh, right) application script...
Joined: Feb 2002
Posts: 7,195
Gremelin Offline
Community Owner
Gremelin Offline

Community Owner

Joined: Feb 2002
Posts: 7,195
Portland, OR; USA
Well, after scouring the internet for a whole of 30 minutes, I decided that nothing out there was exactly what i needed. So I snagged a few tut's and began working...

I fixed up the db i need through phpmyadmin (god bless the gui on that bitch)... See code below:
Code:
CREATE TABLE `ugn_applications` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '',
  `nick` varchar(20) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `yob` varchar(4) NOT NULL default '',
  `telephone` varchar(20) NOT NULL default '',
  `address` varchar(100) NOT NULL default '',
  `sections` varchar(100) NOT NULL default '',
  `aim` varchar(20) NOT NULL default '',
  `irc` varchar(20) NOT NULL default '',
  `bbs` varchar(20) NOT NULL default '',
  `moderate` varchar(10) NOT NULL default '',
  `admin` varchar(10) NOT NULL default '',
  `news` varchar(10) NOT NULL default '',
  `other` varchar(10) NOT NULL default '',
  `username` varchar(20) NOT NULL default '',
  `password` varchar(20) NOT NULL default '',
  `comments` varchar(255) NOT NULL default '',
  `country` varchar(20) NOT NULL default '',
  `ip` varchar(15) NOT NULL default '',
  `status` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
Upon creating the forum to list data (I made a result first) all i get is "Error on line 20"... Anyone care to take a look?:

Code:
<?php
// Change below to your MySQL Host.
$host = "127.0.0.1";

// change below is your assigned mySQL username
$user = "[username]";

// change to the pw below is your assigned mySQL password
$pw = "[password]";

// change to the database you have permission to connect to
$db = "[databasename]";

$mysql_access = mysql_connect("$host", $user, $pw);
?>

<?php
$query = "SELECT * FROM ugn_applications";
$result = mysql_query($query, $mysql_access);
if(mysql_num_rows($result)) {
    // it is true, so let's print the results to the browser
   while($row = mysql_fetch_row($result))
  {
      print("$row[0]
");
  }
} else {
   // false, no results
}
?>

<?
mysql_close($mysql_access);
?>
The section that seems to be giving me the error is:
Code:
if(mysql_num_rows($result)) {
    // it is true, so let's print the results to the browser
   while($row = mysql_fetch_row($result))
  {
      print("$row[0]
");
  }
} else {
   // false, no results
}
Do we finally have any knowlegable php/mysql guys here, or do I need to just go shoot myself in the foot?


Donate to UGN Security here.
UGN Security, Back of the Web, and VNC Web Services Owner
Top
Sponsored Links
#19304 - 01/14/04 12:51 AM Re: Help: Simple (yeh, right) application script...
Joined: Aug 2002
Posts: 68
Scalli0n Offline
Junior Member
Scalli0n Offline
Junior Member

Joined: Aug 2002
Posts: 68
Code:
<?php
// Change below to your MySQL Host.
$host = "127.0.0.1";

// change below is your assigned mySQL username
$user = "[username]";

// change to the pw below is your assigned mySQL password
$pw = "[password]";

// change to the database you have permission to connect to
$db = "[databasename]";

$mysql_access = mysql_connect($host, $user, $pw) or die(mysql_error());
mysql_select_db($db) or die(mysql_error()); // make sure you add this ;)
?>

<?php
$query = "SELECT * FROM ugn_applications";
$result = mysql_query($query, $mysql_access) or die(mysql_error());
if(mysql_num_rows($result)>0) { // if we have results
	while($result2 = mysql_fetch_array($result)) { 
		echo $row[0]."
\n";
		// or you can do echo "{$row[0]}
\n";
		// tag the \n on for readable html ;)
	}
}
?>
<!-- I presume you have html code here -->
<?
	mysql_close($mysql_access);
	// I usually don't mysql_close, at the end of PHP processing the script all mysql
	// connections are killed unless they're persistant
?>
// notice that I added "or die(mysql_error()); " to all the main SQL functions? 
// this can pinpoint the problem &  will print out an error straight from mysql
// don't put these in final versions though, make your own error msg else you'll
// be giving away free information about your query structure & db structure 
// to hackers trying SQL inject attacks.

Top
#19305 - 01/14/04 12:56 AM Re: Help: Simple (yeh, right) application script...
Joined: Aug 2002
Posts: 68
Scalli0n Offline
Junior Member
Scalli0n Offline
Junior Member

Joined: Aug 2002
Posts: 68
change $rows to $result2

Top
#19306 - 01/14/04 10:15 AM Re: Help: Simple (yeh, right) application script...
Joined: Dec 2002
Posts: 3,255
§intå× Offline
§intå× Offline



Joined: Dec 2002
Posts: 3,255
Maryland
A few changes I would make.

Code:
<?php

$host = "localhost";

$user = "[username]";

$pw = "[password]";

// change to the database you have permission to connect to
$db = "[databasename]";
	
$db = "bflfrq8";

//Why use variables, save on some lines of code.  You can add a auth scriptlet to this later to make sure they are supposed to be here.

mysql_connect($host, $user, $pw)or die(mysql_error());

mysql_select_db($db) or die(mysql_error()); 
$result = mysql_query("SELECT * FROM ugn_applications") or die(mysql_error());
if(mysql_num_rows($result)>0) { // if we have results
	while($result2 = mysql_fetch_array($result)) { 
		echo $result2[0]."
\n";
		// or you can do echo "".$result2[0]."
\n";
		// tag the \n on for readable html ;)
	}
}
?>
<!-- I presume you have html code here -->
<?
	mysql_close($mysql_access);
	// I usually don't mysql_close, at the end of PHP processing the script all mysql
	// connections are killed unless they're persistant
?>
// notice that I added "or die(mysql_error()); " to all the main SQL functions? 
// this can pinpoint the problem &  will print out an error straight from mysql
// don't put these in final versions though, make your own error msg else you'll
// be giving away free information about your query structure & db structure 
// to hackers trying SQL inject attacks.


My New site OpenEyes
Top
#19307 - 01/14/04 03:22 PM Re: Help: Simple (yeh, right) application script...
Joined: Feb 2002
Posts: 7,195
Gremelin Offline
Community Owner
Gremelin Offline

Community Owner

Joined: Feb 2002
Posts: 7,195
Portland, OR; USA
Need to work on an input script, anyone wanna help? I don't know this shit! lol`


Donate to UGN Security here.
UGN Security, Back of the Web, and VNC Web Services Owner
Top
#19308 - 01/15/04 03:34 AM Re: Help: Simple (yeh, right) application script...
Joined: Aug 2002
Posts: 68
Scalli0n Offline
Junior Member
Scalli0n Offline
Junior Member

Joined: Aug 2002
Posts: 68
If you pay me I'll do it. You know my sn.

Top
#19309 - 01/15/04 06:58 AM Re: Help: Simple (yeh, right) application script...
Joined: Dec 2003
Posts: 17
AnthonyVSD Offline
Junior Member
AnthonyVSD Offline
Junior Member

Joined: Dec 2003
Posts: 17
BC, Canada
As will I, but cheaper


Anthony Gorecki
"Freedom through knowledge."
Top
#19310 - 01/17/04 09:02 PM Re: Help: Simple (yeh, right) application script...
Joined: Dec 2002
Posts: 3,255
§intå× Offline
§intå× Offline



Joined: Dec 2002
Posts: 3,255
Maryland
Ahh fuck guys, gizzy is having trouble as is with the money on this place.

email me the specs gizmo...


My New site OpenEyes
Top
#19311 - 01/18/04 12:55 AM Re: Help: Simple (yeh, right) application script...
Joined: Feb 2002
Posts: 7,195
Gremelin Offline
Community Owner
Gremelin Offline

Community Owner

Joined: Feb 2002
Posts: 7,195
Portland, OR; USA
Lol, money, that's funny... :watches months fly out of wallet:


Donate to UGN Security here.
UGN Security, Back of the Web, and VNC Web Services Owner
Top
#19312 - 01/21/04 04:58 PM Re: Help: Simple (yeh, right) application script...
Joined: Dec 2002
Posts: 3,255
§intå× Offline
§intå× Offline



Joined: Dec 2002
Posts: 3,255
Maryland
Check your P/M's the frame work is done.


My New site OpenEyes
Top
#19313 - 01/22/04 03:38 AM Re: Help: Simple (yeh, right) application script...
Joined: Feb 2002
Posts: 7,195
Gremelin Offline
Community Owner
Gremelin Offline

Community Owner

Joined: Feb 2002
Posts: 7,195
Portland, OR; USA
Guess I should have said when Neo, Scallion and I hammered out the front end... lol... I have some code for you to look at later though, I'll email it to you heh...


Donate to UGN Security here.
UGN Security, Back of the Web, and VNC Web Services Owner
Top
#19314 - 01/22/04 02:48 PM Re: Help: Simple (yeh, right) application script...
Joined: Sep 2002
Posts: 390
Shinobi Offline
UGN Member
Shinobi Offline
UGN Member

Joined: Sep 2002
Posts: 390
Asheville, NC
I would help! But I AM A NINJA!!!!!!!


"The secret to creativity is knowing how to hide your sources."
-Albert Einstein

Tech Ninja Security
Top
#19315 - 01/24/04 02:47 PM Re: Help: Simple (yeh, right) application script...
Joined: Dec 2002
Posts: 3,255
§intå× Offline
§intå× Offline



Joined: Dec 2002
Posts: 3,255
Maryland
Still waiting on that email Gizzy...


My New site OpenEyes
Top
#19316 - 01/25/04 03:31 AM Re: Help: Simple (yeh, right) application script...
Joined: Feb 2002
Posts: 7,195
Gremelin Offline
Community Owner
Gremelin Offline

Community Owner

Joined: Feb 2002
Posts: 7,195
Portland, OR; USA
check your pm's, i'll get it off to you in a sec..


Donate to UGN Security here.
UGN Security, Back of the Web, and VNC Web Services Owner
Top

Member Spotlight
Gremelin

Gremelin
Portland, OR; USA
Posts: 7,195
Joined: February 2002
Show All Member Profiles 
Forum Statistics
Forums46
Topics46,229
Posts81,399
Members2,157
Most Online1,567
Apr 25th, 2010
Top Posters(All Time)
UGN Security 39,393
Gremelin 7,195
§intå× 3,255
SilentRage 1,273
Ice 1,146
pergesu 1,136
Infinite 1,041
jonconley 955
Girlie 908
unreal 860
Newest Members
Herbert_Sherbert, codemauve, Lillysdragon1984, Brewwit, boa
2157 Registered Users
Who's Online Now
0 registered members (), 4 guests and 1 spider.
Latest News