16
PHP / excel - sql
« en: 14 de Febrero de 2008, 02:53:16 am »
hola quisiera saber si hay una forma de importar los datos de una tabla de excel a una tabla en sql gracias de antemano
Esta sección te permite ver todos los posts escritos por este usuario. Ten en cuenta que sólo puedes ver los posts escritos en zonas a las que tienes acceso en este momento.
#Buscamos haver si hay algun mail o nombre de usuario igual al introducido
$consultamos = 'SELECT * FROM miembros WHERE Nombre="' . $_POST['Nombre'] . '" or email="' . $_POST['email'] . '"';
$comprovacion = mysql_query($consultamos);
#Buscamos haver si hay algun usuario o correo ya igual al seleccionado
if(mysql_num_rows($comprovacion)==0){
#Buscaremos si hay errores y si los hay creamos la variable con el contenido adecuado
} else {
$error = "El nombre de usuario y/o el correo electronico ya a sido registrado";
}
#Comprovamos haver si hay alguna variable que contenga un error
if($error){
#Si es asi lo mostramos
echo"$error";
} else {
#Si no hau errores registramos al usuario
$registrar = "INSERT INTO miembros (id,nombre,Telefono,celular,direccion,email,edad,n_dia,n_mes,n_ano,invitado por) VALUES ( NULL , '".$_POST['nombre']."','".$_POST['tel']."','".$_POST['cel']."','".$_POST['direccion']."','".$_POST['email']."','".$_POST['edad']."','".$_POST['cumple']."','".$_POST['n_dia']."','".$_POST['n_mes']."','".$_POST['n_ano']."','".$_POST['por']."')";
if(mysql_query($registrar)){ #Comprovamos si se ha realizado el registro
echo"Has sido registrado, ¡¡¡Enhorabuena!!!"; #Si se a registrado le decimos que a sido registrado
} else {
echo"No se te a podido registrar, ¡¡¡sorry!!!"; #Si no a sido registrado le decimos que no a sido registrado
}
}
<p>nombre: <input name="nombre" type="text" id="nombre"><br>
Telefono: <input name="tel" type="text" id="tel"><br>
celular: <input name="cel" type="text" id="cel"><br>
direccion: <input name="direccion" type="text" id="direccion"><br>
email: <input name="email" type="text" id="email"><br>
edad: <input name="edad" type="text" id="edad" size="5" maxlength="2"><br>
dia: <select name="n_dia" id="n_dia">
mes: <select name="n_mes" class="input" id="n_mes" ;">
<select name="n_ano" id="n_ano">
<option value="1991">1991</option>
invitado por : <input name="por" type="text" id="por">
<input type="submit" value="OK" name="OK"><input type="reset" value="Borrar" name="Borrar"></p>
<? include("conectar.php"); ?>
<?
if (isset($_POST['enviar'])) {
if ($_POST['nick'] != "" && $_POST['r1'] != "" && $_POST['r2'] != "" && $_POST['r3'] != "" && $_POST['r4'] != "" && $_POST['r5'] != "") {
$id = "";
$query = "INSERT INTO `nominar` (`nick` ,`1` ,`2` ,`3` ,`4` ,`5`) VALUES ('".$_POST['nick']."', '".$_POST['r1']."', '".$_POST['r2']."', '".$_POST['r3']."', '".$_POST['r4']."', '".$_POST['r5']."',)";
@mysql_query($query);
echo "<div align=center><font color=#cc0000>Mensaje enviado</font><br><a href=\"panel.php?mostrar=enviarprivado&".session_name()."=".session_id()."\" class=\"EnlaceMenu\">"._RETURN."</a></div>";
} else
echo "<font class=\"Texto\">Has dejado algún campo vacío<br></font><a href=\"panel.php?mostrar=enviarprivado&".session_name()."=".session_id()."\" class=\"EnlaceMenu\">"._RETURN."</a>";
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>cxbshxc</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form name="form1" method="post" action="">
<table width="100%" border="0">
<tr>
<td>Nick</td>
<td><input name="nick" type="text" id="nick"></td>
</tr>
<tr>
<td>Nominado 1 </td>
<td><select name="r1" class="Select" id="r1">
<option value="carlos">carlos</option>
<?
$query = "SELECT * FROM `usuarios` WHERE rol != '0' order by nick";
$resp = @mysql_query($query);
while ($cat = @mysql_fetch_array($resp)) {
if ($_SESSION['nnick'] != $cat['nick']) {
echo "<option value=\"".$cat['id']."\"";
if (isset($_GET['receptor']) && $_GET['receptor'] == $cat['id'])
echo " selected";
echo ">".$cat['nick']."</option>";
}
}
?>
</select></td>
</tr>
<tr>
<td>Nominado 1 </td>
<td><select name="r2" class="Select" id="r2">
<option value="carlos">carlos</option>
<?
$query = "SELECT * FROM `usuarios` WHERE rol != '0' order by nick";
$resp = @mysql_query($query);
while ($cat = @mysql_fetch_array($resp)) {
if ($_SESSION['nnick'] != $cat['nick']) {
echo "<option value=\"".$cat['id']."\"";
if (isset($_GET['receptor']) && $_GET['receptor'] == $cat['id'])
echo " selected";
echo ">".$cat['nick']."</option>";
}
}
?>
</select></td>
</tr>
<tr>
<td>Nominado 1 </td>
<td><select name="r3" class="Select" id="r3">
<option value="caelos">carlos</option>
<?
$query = "SELECT * FROM `usuarios` WHERE rol != '0' order by nick";
$resp = @mysql_query($query);
while ($cat = @mysql_fetch_array($resp)) {
if ($_SESSION['nnick'] != $cat['nick']) {
echo "<option value=\"".$cat['id']."\"";
if (isset($_GET['receptor']) && $_GET['receptor'] == $cat['id'])
echo " selected";
echo ">".$cat['nick']."</option>";
}
}
?>
</select></td>
</tr>
<tr>
<td>Nominado 1 </td>
<td><select name="r4" class="Select" id="r4">
<option value="cnsac">camcnsacj</option>
<?
$query = "SELECT * FROM `usuarios` WHERE rol != '0' order by nick";
$resp = @mysql_query($query);
while ($cat = @mysql_fetch_array($resp)) {
if ($_SESSION['nnick'] != $cat['nick']) {
echo "<option value=\"".$cat['id']."\"";
if (isset($_GET['receptor']) && $_GET['receptor'] == $cat['id'])
echo " selected";
echo ">".$cat['nick']."</option>";
}
}
?>
</select></td>
</tr>
<tr>
<td>Nominado 1 </td>
<td><select name="r5" class="Select" id="r5">
<option value="ncjc">scnjc</option>
<?
$query = "SELECT * FROM `usuarios` WHERE rol != '0' order by nick";
$resp = @mysql_query($query);
while ($cat = @mysql_fetch_array($resp)) {
if ($_SESSION['nnick'] != $cat['nick']) {
echo "<option value=\"".$cat['id']."\"";
if (isset($_GET['receptor']) && $_GET['receptor'] == $cat['id'])
echo " selected";
echo ">".$cat['nick']."</option>";
}
}
?>
</select></td>
</tr>
<tr>
<td> </td>
<td><input name="enviar" type="submit" id="enviar" value="Enviar"></td>
</tr>
</table>
</form>
</body>
</html>
mysql_query(UPDATE usuarios SET puntos = puntos + 1 WHERE nick='$_COOKIE[nick]');Warning: Cannot modify header information - headers already sent by (output started at /home/habboinf/public_html/mc/configtag.php:49) in /home/habboinf/public_html/mc/logear.php on line 25y este es el codigo de logear.php<?
session_start();
session_cache_limiter('nocache,private');
include("configtag.php");
include("conectar.php");
include("funciones.php");
include("language/lang-".$langactual.".php");
if (isset($_POST['entrar'])) {
$login = stripslashes(str_replace(" ","",$_POST['login']));
$password = stripslashes(str_replace(" ","",$_POST['password']));
if (esAdmin($login)) {
$nick = comprobarNick($login, $password);
if ($nick != "-1" && $nick != "0") {
$_SESSION['nnick'] = $nick;
if (!isset($_SESSION['iden'])) {
$iden = idenAdmin($_SESSION['nnick']);
$_SESSION['iden'] = $iden;
$id = idAdmin($_SESSION['nnick']);
$_SESSION['id'] = $id;
}
header("Location: panel.php?".session_name()."=".session_id());
exit;
}
} else {
$error = _INCORRECTPASS;
header("Location: ftag.php?mostrar=error&error=".$error."&".session_name()."=".session_id());
exit;
}
} else {
$error = _NOACCESS;
header("Location: ftag.php?mostrar=error&error=".$error."&".session_name()."=".session_id());
exit;
}
?>
if(!defined('LOAD'))
die('You are not authorized to view this page');
function getQueryArr($mysqlFile)
{
if(!file_exists($mysqlFile))
return array();
$contentStr = '';
$contentArr = @file($mysqlFile);
foreach($contentArr as $key=>$value)
{
if(!preg_match('~^#|-~',$value))
{
$contentStr .= str_replace("\r\n",'',$value);
}
}
$queryArr = explode(';',$contentStr);
return $queryArr;
}
function dbQuery($queryArr,&$errMsg,$show=0)
{
foreach($queryArr as $key=>$value)
{
$result = @mysql_query($value);
if(!$result)
{
if($show)
{
echo $value.NWL;
}
}
}
return TRUE;
}
function dbConnect($dbHost,$dbUser,$dbPass)
{
$con = @mysql_connect($dbHost,$dbUser,$dbPass);
if($con)
return $con;
else
return FALSE;
}
function dbSelectDb($dbName)
{
if(mysql_select_db($dbName))
return TRUE;
else
return FALSE;
}
function updateSubDomainData($domain,$title,$desc,$email,$subDomain,$redirect,$homeDir,$password,$cId,$dbName)
{
$query = "insert into tadas_subdomain values(null,'$domain','$title','$desc','$email','$subDomain','$redirect','$homeDir','$password',now(),$cId,'$dbName')";
$result = mysql_query($query);
if($result && (mysql_affected_rows()>0))
{
return TRUE;
}
else
{
return FALSE;
}
}
function createDb($dbName,$dbHost,$dbUser,$dbPass)
{
$query1 = "create database $dbName";
$result1 = @mysql_query($query1);
if($result1)
{
return TRUE;
}
return FALSE;
}
function grantPermission($dbHost,$dbUser,$dbPass,$dbName)
{
$query2 = "grant all on $dbName.* to $dbUser@$dbHost identified by '$dbPass'";
$result2 = @mysql_query($query2);
if($result2)
{
if(mysql_select_db($dbName))
return TRUE;
}
return FALSE;
}
function getConfig($configFile,$dbName,$dbUser,$dbPass)
{
$configFile = str_replace('{{DBNAME}}',$dbName,$configFile);
$configFile = str_replace('{{DBUSER}}',$dbUser,$configFile);
$configFile = str_replace('{{DBPASS}}',$dbPass,$configFile);
$configFile = '<?php '."\r\n".$configFile."\r\n".'?>';
return $configFile;
}
/**
* Copy a file, or recursively copy a folder and its contents
*
* @author Aidan Lister <aidan@php.net>
* @version 1.0.1
* @param string $source Source path
* @param string $dest Destination path
* @return bool Returns TRUE on success, FALSE on failure
*/
function copyr($source, $dest)
{
// Simple copy for a file
if (is_file($source)) {
return copy($source, $dest);
}
// Make destination directory
if (!is_dir($dest)) {
mkdir($dest);
}
// Loop through the folder
$dir = dir($source);
if($dir)
{
while (false !== ($entry = $dir->read())) {
// Skip pointers
if ($entry == '.' || $entry == '..') {
continue;
}
// Deep copy directories
if ($dest !== "$source/$entry") {
copyr("$source/$entry", "$dest/$entry");
}
}
// Clean up
$dir->close();
}
return true;
}
function removeDir($dirname) {
if (is_dir($dirname))
$dir_handle = opendir($dirname);
if (!$dir_handle)
return false;
while($file = readdir($dir_handle)) {
if ($file != "." && $file != "..") {
if (!is_dir($dirname."/".$file))
unlink($dirname."/".$file);
else
removeDir($dirname.'/'.$file);
}
}
closedir($dir_handle);
rmdir($dirname);
return true;
}
function isNumber($var)
{
if(preg_match('~^[0-9]+$~',$var))
return TRUE;
else
return FALSE;
}
function isFloat($var)
{
if(preg_match('~^[0-9]+\.?[0-9]*$~',$var))
return TRUE;
else
return FALSE;
}
function isEmail($var)
{
if(preg_match('~^([0-9a-zA-Z]([-.\w]*[0-9a-zA-Z])*@(([0-9a-zA-Z])+([-\w]*[0-9a-zA-Z])*\.)+[a-zA-Z]{2,9})$~',$var))
return TRUE;
else
return FALSE;
}
function isEmpty($var)
{
if(strlen(trim($var))<=0)
return TRUE;
else
return FALSE;
}
function isUrl($var)
{
if(preg_match('~^http://([\w-]+\.)+[\w-]+(/[\w- ./?%&=]*)?$~',$var))
return TRUE;
else
return FALSE;
}