Forum PHP.pl

Witam.
Mam przykładowo bazę danych 123, w niej tabele admins. Mam w niej komorki auth, password, access, flags i days.
Czy jest możliwość stworzenia skryptu PHP, który pozwalałby na dodawanie, usuwanie i edycję rekordów wpisanych do tej tabeli?

Nie nie istnieje taka możliwość. Tutaj możesz użyć c++.

Ten post edytował wookieb 29.06.2010, 14:36:15

Jeśli to jest niemożliwe, to czemu pewne skrypty PHP mają to? np. AMXBans ma możliwość dodawania rekordów, edycji bądź usuwania ich. A przeglądając kod źródłowy jest tam tylko PHP.

[PHP] pobierz, plaintext 
<?php
 
/*
 *
 *  AMXBans, managing bans for Half-Life modifications
 *  Copyright ˆ 2009, www.amxbans.de
 *
 *	web		: http://www.amxbans.de
 *	mail		: setoy@my-horizon.de
 *	ICQ		: 226696015
 *   
 *	This file is part of AMXBans.
 *
 *  AMXBans is free software; you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation; either version 2 of the License, or
 *  (at your option) any later version.
 *
 *  AMXBans is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *
 *  You should have received a copy of the GNU General Public License
 *  along with AMXBans; if not, write to the Free Software
 *  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 *
 */
 
// Start session
session_start();
 
// Require basic site files
 
require("../include/config.inc.php");
 
if ($config->error_handler == "enabled") {
	include("$config->error_handler_path");
}
include("$config->path_root/include/functions.lang.php");
include("$config->path_root/include/accesscontrol.inc.php");
//include("$config->path_root/include/class_hlsi.php");
 
if(($_SESSION['amxadmins_edit'] != "yes") || ($config->admin_management != "enabled")) {
	echo lang("_NOACCESS");
	exit();
}
 
//display_post_get();
 
if ((isset($_POST['action'])) && ($_POST['action'] == "apply")) {
 
	foreach($_POST as $key => $value) {
		if (is_numeric($key)) {
 
			// check if admin was active on this server...
			$resource = mysql_query("SELECT COUNT(admin_id) AS get_adm FROM $config->admins_servers WHERE admin_id = '$key' AND server_id = '".$_POST['server_id']."'") or die (mysql_error());
			$result = mysql_fetch_object($resource);
 
			if ($result->get_adm == 0) {
				if($value == "on") {
					$resource = mysql_query("INSERT INTO $config->admins_servers VALUES('$key', '".$_POST['server_id']."')") or die (mysql_error());
 
					$now = date("U");
					$add_log	= mysql_query("INSERT INTO $config->logs (timestamp, ip, username, action, remarks) VALUES ('$now', '".$_SERVER['REMOTE_ADDR']."', '".$_SESSION['uid']."', 'serveradmins', 'Assigned AdminID $key to ServerID ".$_POST['server_id']."')") or die (mysql_error());
				}
			}	else if ($result->get_adm == 1) {
				if($value == "off") {
					$resource = mysql_query("DELETE FROM $config->admins_servers WHERE admin_id = '$key' AND server_id = '".$_POST['server_id']."'") or die (mysql_error());
 
					$now = date("U");
					$add_log	= mysql_query("INSERT INTO $config->logs (timestamp, ip, username, action, remarks) VALUES ('$now', '".$_SERVER['REMOTE_ADDR']."', '".$_SESSION['uid']."', 'serveradmins', 'Removed AdminID $key from ServerID ".$_POST['server_id']."')") or die (mysql_error());
				}
			} else {
				echo "Duplicate entry found?";
			}
		}
	}
}
 
// get a list of servers...
$resource = mysql_query("SELECT id, hostname, amxban_version FROM $config->servers ORDER BY hostname ASC") or die (mysql_error());
 
while($result = mysql_fetch_object($resource)) {
 
	$checkplug	= explode ("_", $result->amxban_version);
	$amx_version	= $checkplug['0'];
 
	//echo "<h2>$amx_version</h2>";
 
	// Asign variables to the array used in the template
	$server_info = array(
		"id"		=> $result->id,
		"hostname"	=> $result->hostname,
		"amxversion"	=> $amx_version
		);
 
	$server_array[] = $server_info;
}
 
if ( isset($_POST['server_id']) && $_POST['server_id'] != "xxx")
{
	$serverid = $_POST['server_id'];
 
	// get a list of admins for this server
	$resource2 = mysql_query("SELECT admin_id FROM $config->admins_servers WHERE server_id = '$serverid'") or die (mysql_error());
	$these_admins = array();
 
	while($result2 = mysql_fetch_object($resource2)) {
 
		//get their user- and nicknames too
		$resource2a	= mysql_query("SELECT username, nickname FROM $config->amxadmins WHERE id = '$result2->admin_id' ORDER BY access DESC") or die (mysql_error());
 
		while($result2a = mysql_fetch_object($resource2a)) {
			$admin_info = array(
				"id"		=> $result2->admin_id,
				"username"	=> $result2a->username,
				"nickname"	=> $result2a->nickname
				);
		}
		$these_admins[] = $admin_info;
	}
 
	$resource3	= mysql_query("SELECT admin_id FROM $config->admins_servers WHERE server_id = '$serverid'") or die (mysql_error());
	$these_adminids = array();
 
	while($result3 = mysql_fetch_object($resource3)) {
		$these_adminids[] = $result3->admin_id;
	}
 
	// get a list of all adminIDs (but not those who are active for this server...
	$resource3	= mysql_query("SELECT id, username, nickname FROM $config->amxadmins WHERE username IS NOT NULL AND username != '' ORDER BY id ASC") or die (mysql_error());
	$all_admins	= array();
 
	while($result3 = mysql_fetch_object($resource3)) {
 
		if(in_array($result3->id, $these_adminids)) {
			$admin_info = array(
				"id"		=> $result3->id,
				"username"	=> $result3->username,
				"nickname"	=> $result3->nickname,
				"checked"	=> 1
				);
		} else {
			$admin_info = array(
				"id"		=> $result3->id,
				"username"	=> $result3->username,
				"nickname"	=> $result3->nickname,
				"checked"	=> 0
				);
		}
 
		$all_admins[] = $admin_info;
	}
}
 
/*
 *
 * Template parsing
 *
 */
 
$title	= "Serveradmins";
 
// Section
$section = "server_admins";
 
$smarty	= new dynamicPage;
 
$smarty->assign("meta","");
$smarty->assign("title",$title);
$smarty->assign("section",$section);
$smarty->assign("dir",$config->document_root);
$smarty->assign("this", $_SERVER['PHP_SELF']);
$smarty->assign("submitted",get_post('submitted'));
 
$smarty->assign("thisserver", isset($serverid) ? $serverid : NULL);
$smarty->assign("servers", isset($server_array) ? $server_array : NULL);
$smarty->assign("all_admins", isset($all_admins) ? $all_admins : NULL);
$smarty->assign("these_admins", isset($these_admins) ? $these_admins : NULL);
 
$smarty->display('main_header.tpl');
$smarty->display('server_admins.tpl');
$smarty->display('main_footer.tpl');
 
?>
[PHP] pobierz, plaintext 

Ten post edytował fastlone 29.06.2010, 14:57:44

No bo oczywiście że jest możliwość tylko, że zadajesz tak głupie pytanie że tak naprawdę powinno wylecieć z tego forum. Nie zrozumiałeś ironii.
A skoro znasz odpowiedź na to pytanie to po co się pytasz?

Pytam się, bo w PHP jestem zielony, a potrzebuję takiego skryptu. Nie umiem przerobić żadnego znanego mi kodu.

Szukajcie a znajdziecie.
http://pl.php.net/manual/en/language.variables.external.php
A jak nie umiesz edytować rekordów to kurs sql i jazda.

Umiem to wszystko zrobić przez PHPMyAdmin'a, lecz inne osoby, które się zajmują ustalaniem listy, która jest zawarta w tej tabeli, nie umieją tego.
W tym celu potrzebuję tego skryptu. Czy mógłby takie coś ktoś dla mnie zrobić? Nie zależy mi na estetyce.