Jump to content
xisto Community
kopythat

Need Help Need mysql php script

Recommended Posts

I am trying to create a page on a site and I cant seem to figure it outAll it is to do is be an ad page, with an admin. to show a picture/logo with a short description of services offered, with the business name linked. I wanted an admin page for my client, who knows less than me. Then to display all info from database. Only the admin can add, or maybe submit with admin approval.If anyone can help me out that would be greatly appreciated.......either with their own code or some code out there somewhere that i canr findKopy

Share this post


Link to post
Share on other sites

i will help you make a script. please elaborate the whole client area. what data willl be included and the like. i need to know so that i can make make you a script. the script will NOT include ANY html. i will make use of a template system. you are the one who will make the design of the client area.

Share this post


Link to post
Share on other sites

for mysql i'd suggest strongly that you go get a mysql class, try phpclasses.org and look for mysql classes, its quite easier dealing with objects than it is dealing with functions. infact nowadays everything i code is all oop .. you should give it a try go check out the site..

Share this post


Link to post
Share on other sites

i'll share my class. if ever it will be used, please do not remove the heading which shows that i made it.

here are the constants used.

define('BEGIN_TRANSACTION', 1);define('END_TRANSACTION', 2);

the mysql class itself

/*************************************************************************** *                                MySQL Class *                            -------------------                          *   Created              : Tuesday, Mar 11, 2003  *   Copyright            : (C) 2003 ENIGMA Designs - PHPBIT *   Email                : support@3nigma.com                            *                                                           *                                                          *                                                             *  ***************************************************************************/ class db {	var $db_connect_id;	var $query_result;	var $row = array();	var $rowset = array();	var $num_queries = 0;	var $in_transaction = 0;		function db ($server, $username, $password, $database, $persistence = false) {  $this->server = $server;  $this->username = $username;  $this->password = $password;  $this->database = $database;  $this->persistence = $persistence;    $this->db_connect_id = ($this->persistence) ? mysql_pconnect($server, $username, $password) : mysql_connect($server, $username, $password);    if ($this->db_connect_id) {  	if ($database != "") {    mysql_select_db($this->database);  	} else {    return false;  	}  	  	return $this->db_connect_id;  } else {  	return false;  }	}		function close () {  if ($this->db_connect_id) {  	if ($this->in_transaction) {    mysql_query("COMMIT", $this->db_connect_id);  	}  	  	return mysql_close($this->db_connect_id);  } else {  	return false;  }	}		function query ($query = "", $transaction = false) {  unset($this->query_result);    if ($query != "") {  	$this->num_queries++;  	  	if ($transaction == BEGIN_TRANSACTION && !$this->in_transaction) {        if (!mysql_query("BEGIN", $this->cb_connect_id)) {        	return false;    }        $this->in_transaction = true;  	}  	  	$this->query_result = mysql_query($query, $this->db_connect_id);  } else {  	if ($transaction == END_TRANSACTION && $this->in_transaction) {    $this->in_transaction = false;        if (!mysql_query("COMMIT", $this->db_connect_id)) {    	mysql_query("ROLLBACK", $this->db_connect_id);    	    	return false;    }  	}  }    if ($this->query_result) {  	unset($this->row[$this->query_result]);  	unset($this->rowset[$this->query_result]);  	  	if ($transaction == END_TRANSACTION && $this->in_transaction) {    $this->in_transaction = false;        if (!mysql_query("COMMIT", $this->db_connect_id)) {    	mysql_query("ROLLBACK", $this->db_connect_id);    	    	return false;    }  	}  	  	return $this->query_result;  } else {  	if ($this->in_transaction) {    mysql_query("ROLLBACK", $this->db_connect_id);        $this->in_transaction = false;  	}  	  	return false;  }	}		function numrows ($query_id = 0) {  if (!$query_id) {  	$query_id = $this->query_result;  }    return ($query_id) ? mysql_num_rows($query_id) : false;	}		function affectedrows () {  return ($this->db_connect_id) ? mysql_affected_rows($this->db_connect_id) : false;	}		function numfields ($query_id = 0) {  if (!$query_id) {  	$query_id = $this->query_result;  }    return ($query_id) ? mysql_num_fields($query_id) : false;	}		function fieldname ($query_id = 0, $offset) {  if (!$query_id) {  	$query_id = $this->query_result;  }    return ($query_id) ? mysql_field_name($query_id, $offset) : false;	}		function fieldtype ($query_id = 0, $offset) {  if (!$query_id) {  	$query_id = $this->query_result;  }    return ($query_id) ? mysql_field_type($query_id, $offset) : false;	}		function fetchrow ($query_id = 0) {  if (!$query_id) {  	$query_id = $this->query_result;  }    if ($query_id) {  	$this->row[$query_id] = mysql_fetch_array($query_id, MYSQL_ASSOC);  	  	return $this->row[$query_id];  } else {  	return false;  }	}		function fetchrowset ($query_id = 0) {  if (!$query_id) {  	$query_id = $this->query_result;  }    if ($query_id) {  	unset($this->rowset[$query_id]);  	unset($this->row[$query_id]);  	while($this->rowset[$query_id] = mysql_fetch_array($query_id, MYSQL_ASSOC)) {    $result[] = $this->rowset[$query_id];  	}  	return $result;  } else {  	return false;  }	}		function fetchfield ($query_id = 0, $rownum = -1, $field) {  if (!$query_id) {  	$query_id = $this->query_result;  }    if ($query_id) {  	if ($rownum > -1) {    $result = mysql_result($query_id, $rownum, $field);  	} else {    if (empty($this->row[$query_id]) && empty($this->rowset[$query_id])) {    	if ($this->fetchrow()) {      $result = $this->row[$query_id][$field];    	} else {      if ($this->rowset[$query_id]) {      	$result = $this->rowset[$query_id][$field];      } else if ($this->row[$query_id]) {      	$result = $this->row[$query_id][$field];      }    	}    }  	}  	  	return $result;  } else {  	return false;  }	}		function rowseek ($query_id = 0, $rownum) {  if (!$query_id) {  	$query_id = $this->query_result;  }    return ($query_id) ? mysql_data_seek($query_id, $rownum) : false;	}		function nextid () {  return ($this->db_connect_id) ? mysql_insert_id($this->db_connect_id) : false;	}		function freeresult ($query_id = 0) {  if (!$query_id) {  	$query_id = $this->query_result;  }    if ($query_id) {  	unset($this->row[$query_id]);  	unset($this->rowset[$query_id]);  	  	mysql_free_result($query_id);  	  	return true;  } else {  	return false;  }	}		function error () {  $result['message'] = mysql_error($this->db_connect_id);  $result['code'] = mysql_errno($this->db_connect_id);    return $result;	}}

Share this post


Link to post
Share on other sites

basically this is the layoutto have a picture or logo <BR> Business name (linked to website or mailto) <BR> Brief description about services offered. <BR><HR> then the list goes on.......if it could be creatde so there is a "page of liinks" so on my template i can <? include ("filename.php") ?> As for the admin, just a simple form (no templating required) that he can enter in the data of the new link Business name: " "http/mailto " "Description " "Upload "Browse"then all the info will be extracted onto this "filename.php" page and will be called when included in my template "links.php"ThanksKopythat

Share this post


Link to post
Share on other sites

Hmm..

 

I could probably do one but mine would include HTML...

 

 

SQL

 

CREATE TABLE `businesses` (

`id` int(10) NOT NULL auto_increment,

`business` varchar(255) NOT NULL default '',

`description` text NOT NULL default '',

`emailaddress` varchar(255) NOT NULL default '',

PRIMARY KEY(`id`)

) TYPE=MyISAM;

 

 

 

PHP/HTML

 

<html>

<head>

<title>Businesses</title>

</head>

<body>

<center>

<table border=".01" align="center">

<tr bgcolor="#D0D0D0">

<td><b>ID</b></td>

<td><b>Business</b></td>

</tr>

<?php

 

$query=mysql_query("SELECT id,business FROM businesses ORDER BY id ASC");

 

while($row=mysql_fetch_row($query)) echo '<tr bgcolor="#E0E0E0"><td><a href="http://forums.xisto.com/no_longer_exists/[0].'">'.$row[0].'</a></td><td>'.$row[1].'</td></tr></table>';

 

 

?>

</body>

</html>

 

--SAVE AS businesses.php--

 

 

 

PHP/HTML FOR show_business.php

 

<?php

 

$business = $_GET['business'];

 

?>

<html>

<head>

<title>Show Business</title>

</head>

<body>

<table border=".01">

<tr bgcolor="#D0D0D0">

<td><B>Business</b></td>

<td><b>Description</b></td>

<td><b>E-Mail Address</b></td>

</tr>

<?php

 

$query=mysql_query("SELECT business,description,emailaddress FROM businesses WHERE id='$business'");

 

while($row=mysql_fetch_row($query)) echo '<tr bgcolor="#E0E0E0"><td>'.$row[0].'</td><td>'.$row[1].'</td><td><a href="mailto:'.$row[2].'">'.$row[2].'</a></td></tr></table>';

 

?>

</body>

</html>

 

 

 

--SAVE AS show_business.php--

 

 

 

 

 

--PHP FOR new_business.php--

 

<html>

<head>

<title>New Business</title>

</head>

<body>

<form action="<?=$_SERVER['PHP_SELF']?>" method="POST">

<table border=".01" align="center">

<tr>

<td><B>Business Name:</b></td>

<td><input type="text" name="business_name" /></td>

</tr>

<tr>

<td><b>Business Description:</b></td>

<td><textarea name="business_desc" rows="15" cols="20"></textarea></td>

</tr>

<tr>

<td><b>E-Mail Address:</b></td>

<td><input type="text" name="business_email" /></td>

</tr>

<tr>

<td><input type="submit" name="add" value="Add!" /></td>

<td><input type="reset" value="Reset" /></td>

</tr>

</table>

</form>

<?php

 

if(isset($_POST['add'])) {

 

mysql_query("INSERT INTO businesses SET business='{$_POST['business_name']}',description='{$_POST['business_desc']}',emailaddress='{$_POST['business_email']}'") or die(mysql_error());

 

echo '<tr bgcolor="red"><td><b>Business added.</b></td></tr>';

 

} else {

 

echo '';

 

}

 

?>

</body>

</html>

 

 

--SAVE AS new_business.php--

Share this post


Link to post
Share on other sites

Thanks for the code Mike.....it works well
I have made a few changes as per formating, it does everything that i want it to do
Now I need to add a picture or logo upload (mysql and php portion) but the image must be less than 400 pixels wide and 200 pixels in hieght and added to the new_business.php form........If you could help me out with that it would be greatly appreciated.



Here are the modifications I have made to the code

MYSQL

CREATE TABLE `businesses` (
`id` int(10) NOT NULL auto_increment,
`business` varchar(255) NOT NULL default '',
`description` text NOT NULL default '',
`emailaddress` varchar(255) NOT NULL default '',
`website` varchar(255) NOT NULL default '',
PRIMARY KEY(`id`)
) TYPE=MyISAM;

new_business.php (added website)

<form action="<?=$_SERVER['PHP_SELF']?>" method="POST">
<table border=".01" align="center">
<tr>
<td><B>Business Name:</b></td>
<td><input type="text" name="business_name" /></td>
</tr>
<tr>
<td><b>Business Description:</b></td>
<td><textarea name="business_desc" rows="15" cols="20"></textarea></td>
</tr>
<tr>
<td><b>E-Mail Address:</b></td>
<td><input type="text" name="business_email" /></td>
</tr>
<tr>
<td><B>Website:</b></td>
<td><input name="business_website" type="text" /></td>
</tr>
<tr>
<td><input type="submit" name="add" value="Add!" /></td>
<td><input type="reset" value="Reset" /></td>
</tr>
</table>
</form>
<?php

if(isset($_POST['add'])) {

mysql_query("INSERT INTO businesses SET business='{$_POST['business_name']}',description='{$_POST['business_desc']}',emailaddress='{$_POST['business_email']}',website='{$_POST['business_website']}'") or die(mysql_error());

echo '<tr bgcolor="red"><td><b>Business added.</b></td></tr>';

} else {

echo '';

}

?>
</body>
</html>




show_business.php (changed table and text formating and showed all businesses on same page)

<?php

$query=mysql_query("SELECT business,description,emailaddress, website FROM businesses ");

while($row=mysql_fetch_row($query)) echo '<table width="495"><tr><TD><div align="center"><strong>'.$row[0].'</strong></div><BR></td></TR><TR><td><div align="center">'.$row[1].'</div></td></TR><TR><td><div align="center"><a href="mailto:'.$row[2].'">'.$row[2].'</a><BR></div></td></TR><TR><TD><div align="center"><a href="'.$row[3].'">'.$row[3].'</div></td></tr></table><HR width="400">';

?>

business.php (no changes)

Didnt need



Thanks again in advance

Kopythat



Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.