Php/mysql Script

panquetofobia

Feb 7 2005, 06:50 AM

hello guys.

the problem with this script is that the insert query dosen't function properly as it depends on the result of a count(*) query.

the update query works fine....

here's some code:

CODE

$code=md5($codea);
if(@$codigo!=$code)// no autenticado - not authenticated
{
header ("Location: main.php");
}
elseif($deporte=="" || $rama=="" || $enc_reg=="" || $centro_trabajo=="")
{
header ("Location: reg1.php?codigo=$code&enc_reg=$enc_reg");
}
else //todo bien - everything is ok
{
// PRINCIPAL - MAIN //
echo "<link href=\"./css/base.css\" rel=\"stylesheet\" type=\"text/css\" />";
echo "<body style=\"background-image:url(./imgs/regbg.gif)\x3b background-repeat: no-repeat\x3b background-position: top right\x3b background-attachment:fixed\x3b \">";
echo "<img src=\"./imgs/paso3.gif\" border=\"0\" alt=\"\">";
echo "Gracias por identificarse $enc_regRegistro de Jugadores de $deporte $rama para el Centro de Trabajo $centro_trabajo ";
$fecha=date("Y-m-d");
$sqlcheck="SELECT integrantes_restantes FROM equipos WHERE Centro_de_Trabajo='$centro_trabajo' and Deporte='$deporte'";
$querycheck=mysql_query($sqlcheck);
$A=mysql_fetch_object($querycheck);
@$merror.="Hasta $A->integrantes_restantes jugadores por registrar.";
if (@$ddok)//enviado - submitted
{
if(@$ape1=="" || $ape2=="" || $nombre=="" || $no_ficha=="" || @$sit_cont=="" || @$sub_sit_cont=="" || $anios=="" || $talla=="")
{
@$merror.="Por Favor Llene el Formulario completamente.";
}
else //lleno - filled
{
//sql ya registrado ó sancionado?? - sql registered or punished ??
$sqlcheck="SELECT COUNT(*) FROM sancionados,participantes WHERE sancionados.No_Ficha='$no_ficha' AND participantes.No_Ficha='$no_ficha'";
$querycheck=mysql_query($sqlcheck) || die(mysql_error());
if($A->integrantes_restantes==0)//no hay lugares libres? - no positions left?
{
@$merror.="CENTRO DE TRABAJO COMPLETO. NO HAY REGISTROS DISPONIBLES. <img src=\"./imgs/error.gif\" alt=\"\">";
echo "<meta http-equiv=\"refresh\" content=\"3\x3burl=index.php\">";
}
elseif(@mysql_result($querycheck,0,0)>0) //ya registrado ó sancionado?? - registered or punished ??
{
$merror.="JUGADOR SANCIONADO, IMPOSIBLE REGISTRAR. <img src=\"./imgs/error.gif\" alt=\"\">";
}
else //no registrado ni sancionado. hay cupo. - neither registered nor punished. positions availables
{
$situacionc="$sit_cont $sub_sit_cont";
$sql="INSERT INTO participantes VALUES ( 0 , '$nombre','$ape1','$ape2','$no_ficha','$situacionc','$talla','$anios','$deporte','$rama','$centro_trabajo','$enc_reg','$fecha')";
$query=mysql_query($sql) || die(mysql_error()); // registro de jugador - storing player info
$sql="UPDATE equipos SET integrantes_restantes=(integrantes_restantes - 1) where Centro_de_Trabajo='$centro_trabajo' and Deporte='$deporte'";
$query=mysql_query($sql) || die(mysql_error()); // una posición menos - minus one position
@$merror.="Jugador $nombre $ape1 $ape2 Registrado <img src=\"./imgs/oki.gif\" alt=\"\">";
}
}
}
form_jugadores(@$desp,$code,@$enc_reg,@$merror,@$deporte,@$rama,@$centro_trabajo);
}
// FIN PRINCIPAL - END MAIN //

thank u very much for your help

mastercomputers

Feb 7 2005, 07:56 AM

It sure seems to be getting more problems,

first line maybe incorrect, I don't see $codea declared anywhere, so it's probably meant to be $code

You really need to learn when to use single quoted items compared to double quoted items just for performance sake.

header('Location: main.php'); performs better than header("Location: main.php");

again with setting variables to empty strings or doing comparisons use $deporte = '' although you may want to check the empty() function for these.

Things like

echo '<link href="./css/base.css" rel="stylesheet" type="text/html" />'; is easier to do is it not? There's no need to escape any double quotes.

I think instead of me going over this code, I'll copy it and rewrite it how I would as it's just too much to read in.

Cheers,

MC

mastercomputers

Feb 7 2005, 08:46 AM

CODE

$code = md5($code); // IS THIS CORRECT?

if(@$codigo != $code)
header('Location: main.php');
elseif($deporte . $rama . $enc_reg . $centro_trabajo == '')
header("Location: reg1.php?codigo=$code&amp\x3benc_reg=$enc_reg");
else
{
//PRINCIPAL - MAIN
?>
<link href="/css/base.css" rel="stylesheet" type="text/css" />
<body style="background: url(/img/regbg.gif) no-repeat fixed top right;">
<img src="./imgs/paso3.gif" border="0" alt="">
Gracias por identificarse <?php echo $enc_reg; ?>
Registro de Jugadores de <?php echo $deporte . ' ' . $rame; ?> para el Centro de Trabajo <?php echo $centro_trabajo; ?>
<?php }

$fecha = date('Y-m-d');
$sqlcheck = "SELECT integrantes_restantes FROM equipos WHERE Centro_de_Trabajo = '$centro_trabajo' AND Deporte = '$deporte'";
$querycheck = mysql_query($sqlcheck) or die(mysql_error());
$A = mysql_fetch_object($querycheck);
@$merror .= "Hasta $A -> integrantes_restantes jugadores por registrar.";

if(@$ddok) // enviado - submitted
{
if(@$ape1 . $ape2 . $nombre . $no_ficha . @$sit_cont . @$sub_sit_cont . $anios . $talla == '')
@$merror .= 'Por Favor Llene el Formulario completamente.';
else // lleno - filled
{
// sql ya registrado ó sancionado?? - sql registered or punished??
$sqlcheck = "SELECT COUNT(*) FROM sancionados, participantes WHERE sancionados.No_Ficha = '$no_ficha' AND participantes.No_Ficha = '$no_ficha'";
$querycheck = mysql_query($sqlcheck) or die(mysql_error());
// IS THERE SUPPOSE TO BE $A = mysql_fetch_object($querycheck); HERE?
if($A -> integrantes_restantes == 0) // no hay lugares libres? - no positions left?
{
@$merror .= 'JUGADOR SANCIONADO, IMPOSIBLE REGISTRAR. <img src="/imgs/error.gif" alt="">';
echo '<meta http-equiv="refresh" content="3' . "\x3b" . 'url=index.php" />';
}
else // no registrado ni sancionado. hay cupo. - neither registered nor punished. positions availables
{
$situancionc = $sit_cont . ' ' . $sub_sit_cont;
$sql = "INSERT INTO participantes VALUES (0, '$nombre', '$ape1', '$ape2', '$no_ficha', '$situancionc', '$talla', '$anios', '$deporte', '$rama', '$centro_trabajo', '$enc_reg', '$fecha')";
$query = mysql_query($sql) or die(mysql_error()); // registro de jugador - storing player info
$sql = "UPDATE equipos SET integrantes_restantest = (integrantes_restantest - 1) WHERE Centro_de_Trabajo = '$centro_trabajo' AND Deporte = '$deporte'";
$query = mysql_query($sql) or die(mysql_error());
@$merror .= 'Jugador ' . $nombre . ' ' . $ape1 . ' ' . $ape2 . ' Registrado <img src="/imgs/oki.gif" alt="">';
}
}
}
form_jugadores(@$desp, $code, @$enc_reg, @$merror, @$deporte, @$rama, @$centro_trabajo);
} // WHAT IS THIS CLOSING?
// FIN PRINCIPAL - END MAIN //

panquetofobia

Feb 7 2005, 04:09 PM

the problem is with the count(*) query.

everything else works fine.

@MC

what's the difference in performance between

header('Location: main.php'); and header("Location: main.php"); ???

i know there r some easy ways... but i learned php using google.

it doesn't
please read my comments below. hope u'll find out the solution

CODE

$code = md5($code); // IS THIS CORRECT?-> yes it is. no problem with this line.

if(@$codigo != $code)
header('Location: main.php');
elseif($deporte . $rama . $enc_reg . $centro_trabajo == '')
header("Location: reg1.php?codigo=$code&amp\x3benc_reg=$enc_reg");
else
{
//PRINCIPAL - MAIN
?>
<link href="/css/base.css" rel="stylesheet" type="text/css" />
<body style="background: url(/img/regbg.gif) no-repeat fixed top right;">
<img src="./imgs/paso3.gif" border="0" alt="">
Gracias por identificarse <?php echo $enc_reg; ?>
Registro de Jugadores de <?php echo $deporte . ' ' . $rame; ?> para el Centro de Trabajo <?php echo $centro_trabajo; ?>
<?php }

$fecha = date('Y-m-d');
$sqlcheck = "SELECT integrantes_restantes FROM equipos WHERE Centro_de_Trabajo = '$centro_trabajo' AND Deporte = '$deporte'";
$querycheck = mysql_query($sqlcheck) or die(mysql_error());
$A = mysql_fetch_object($querycheck);
@$merror .= "Hasta $A -> integrantes_restantes jugadores por registrar.";

if(@$ddok) // enviado - submitted
{
if(@$ape1 . $ape2 . $nombre . $no_ficha . @$sit_cont . @$sub_sit_cont . $anios . $talla == '')
@$merror .= 'Por Favor Llene el Formulario completamente.';
else // lleno - filled
{
// sql ya registrado ó sancionado?? - sql registered or punished??
$sqlcheck = "SELECT COUNT(*) FROM sancionados, participantes WHERE sancionados.No_Ficha = '$no_ficha' AND participantes.No_Ficha = '$no_ficha'"; // here's the problem.
$querycheck = mysql_query($sqlcheck) or die(mysql_error());
// IS THERE SUPPOSE TO BE $A = mysql_fetch_object($querycheck); HERE? -> no, i take the object from the first mysql_fetch object. works fine. no problem here.
if($A -> integrantes_restantes == 0) // no hay lugares libres? - no positions left?
{
@$merror .= 'JUGADOR SANCIONADO, IMPOSIBLE REGISTRAR. <img src="/imgs/error.gif" alt="">';
echo '<meta http-equiv="refresh" content="3' . "\x3b" . 'url=index.php" />';
}
else // no registrado ni sancionado. hay cupo. - neither registered nor punished. positions availables
{
$situancionc = $sit_cont . ' ' . $sub_sit_cont;
$sql = "INSERT INTO participantes VALUES (0, '$nombre', '$ape1', '$ape2', '$no_ficha', '$situancionc', '$talla', '$anios', '$deporte', '$rama', '$centro_trabajo', '$enc_reg', '$fecha')"; this query works, but its function depends on the count(*) query above.....
$query = mysql_query($sql) or die(mysql_error()); // registro de jugador - storing player info
$sql = "UPDATE equipos SET integrantes_restantest = (integrantes_restantest - 1) WHERE Centro_de_Trabajo = '$centro_trabajo' AND Deporte = '$deporte'"; //works fine.
$query = mysql_query($sql) or die(mysql_error());
@$merror .= 'Jugador ' . $nombre . ' ' . $ape1 . ' ' . $ape2 . ' Registrado <img src="/imgs/oki.gif" alt="">';
}
}
}
form_jugadores(@$desp, $code, @$enc_reg, @$merror, @$deporte, @$rama, @$centro_trabajo);
} // WHAT IS THIS CLOSING?- the end of the firt 'else'
// FIN PRINCIPAL - END MAIN //

greetings from México.

avalon

Feb 7 2005, 09:29 PM

you asked:---------------------

what's the difference in performance between

header('Location: main.php'); and header("Location: main.php"); ???

----------------------------------

Answer: No difference, they work as well.

As for your "Count(*)" problem, i will get back to you later.

arez

Feb 11 2005, 11:03 AM

o copied an used it and with me it wrosk perfect i don't understand what doens't work/.

mastercomputers

Feb 11 2005, 10:54 PM

There is a performance difference indeed, hardly noticable on such a small scaled script, but when you get into large scaled projects, you're bound to find better performing ways for your server.

doube quotes tells the PHP interpreter that it may have to interpolate, so it checks everything within the double quotes looking for things it can interpolate, like variables and escaped characters. e.g. $string = "This $variable will be interpolated, as well as this newline character.\n";

$variable will be replaced by whatever is contained within it's elements and \n will be replaced with a newline.

single quotes are shown as is, no interpolation at all. e.g. $string = 'This $variable will not be interpolated, nor would this newline character.\n';

If you echoed this single quoted string out, all you should see is:

This $variable will not be interpolated, nor would this newline character.\n

And that's it, displayed as is, without checking the innards of the variables or newline character.

So the main difference is that double quotes requires the interpreter to thoroughly check within the string, looking for certain things it can change.

Maybe if you test it out for yourself?

<?php
$variable = 'VaRiAbLe';
$string1 = "This $variable.\nAnd Newline"; // check HTML source to see the newline.
$string2 = 'This $variable.\nAnd Newline';
$string3 = 'This ' . $variable . '.' . "\n" . 'And Newline';
$string4 = 'This ' . $variable . '.\nAnd Newline';

echo 'String 1: ' . $string1 . ' ';
echo 'String 2: ' . $string2 . ' ';
echo 'String 3: ' . $string3 . ' ';
echo 'String 4: ' . $string4 . ' ';
?>

Hopefully you'll understand the results, in testing these out. Just remember, if an item needs interpolation, it might be easier to do the whole string in double quotes like String 1 or just do parts of it like in String 3. String 2 and String 4 would not be your desired results.

Cheers,

MC

Recent Queries:-

header(location: main.php); - 101.79 hr back. (1)
mysql_query or die - 183.32 hr back. (1)

Similar Topics

Keywords : php, mysql, script

Which Language Is Easy And Secure Today For Web Development

is PHP MYSQL is easy and Secure ? (2)

Web development Application now a day using PHP MySQL Mostly as i observed on discussion topics on
Forums friends switch to PHP MYSqL, Did PHP MYSQL is Easy and Secure for todays environment what
you are say about this Hacking tracking stolen password are very much popular now a days his website
hacked by X person so many time comes to news please emphasis on security issue when you go to
develop any web tools . what is the right way to tight security on PHP what thing i kept in mind
which logic i use that any one can not hack webtools. when i was use java/j2ee languag....

How To Design The Popup Menu Item Using Javascript(1)

Java script is powerfull to design Menu (0)

I want to Design the POP up Menu for I have reach the final stage to design the Menu but it is come
come in desired format as i want the logic which i use here i am presenting with Javascript code
file CODE var NoOffFirstLineMenus=7;                 var
LowBgColor='#685776';                 var LowSubBgColor='ACE5AA';
    var HighBgColor='blue';                 var HighSubBgColor='blue';
    var FontLowColor='ffffff';                 var FontSubLowColor='1E2B70';
    var FontHighColor='....

How To Validate The Login Form Using Php Pcre

PHP Validation is on Server Side and Java Script on Client Side. (0)

I am Design a Sample Login form Using This Code : CODE { if(empty($_POST )) {
$fnmerror='Invalid First Name'; } elseif(empty($_POST )) { $lnmerror='Invalid Last
Name'; } elseif(empty($_POST )) { $ageerror='Invalid Age'; } elseif(empty($_POST )) {
$cityerror='Invalid City'; } elseif(empty($_POST )) { $pinerror='Invalid Pin No.'; }
elseif(empty($_POST )) { $moberror='Invalid Mobile No.'; } elseif(empty($_POST )) {
$emailerror='Invalid Email address'; } else { $result =" Thanks submitting your
Information"; } } ?....

Mysql Overhead

(3)

Sometimes in a table especially if i do alot of things in it i start seeing overhead then a size
near it? what is overhead? and is it essential to optimize the table to fix it? I know its just a
press of a button but i'd like to know what happens when i optimize a table. Also when you make
a new table you can limit the size of VARCHAR to a number, that number would be the number
characters allowed in that column per entry. I'd like to know how the limit works for texts, is
it in KB? or number of characters? Cuz i made a messaging system. And i remember reading s....

[fl]snow Effect

Simple Snow Efect Script (4)

Here is a simple snow script that i will show you. Its pretty nice /smile.gif"
style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" />. Let's get started.
1.Draw a snow flake. (Using circle tool) 2.Select it and conert it to a symbol ( Ctrl+F8 ). Press
movie clip, but don't click "ok" yet. Where it says "Linkage" click on export for action script.
3.For identifier put in, "flake". 4.Than put in following action script: CODE amount = 100;
mWidth = Stage.width; mHeight = Stage.height; for (var i = 0; i thisFlake =
this.attachMovie("flake", "fla....

Automatic Typing Script

(3)

I need to construct an automatic typing script that type a specific string of text (less than 30
characters) in a Flash object running in any browser. It must be run in Windows. What programming
language do I do this in? How do I do it? Another option is to have a GreaseMonkey script to do
this within Firefox. But I have no clue how to do this. The program needs to "type" a predefined
string into a Flash object (there isn't a text field in the Flash object). Timing must be
controllable so that the program types 5 characters per second or whatever I define it to. T....

What You Need Before You Can Create A Text-based Game..

Using PHP, HTML and MySQL (7)

Please comment and rate, after you finished reading! /smile.gif" style="vertical-align:middle"
emoid=":)" border="0" alt="smile.gif" />
################################################################# Change log: Aug 22 2008: The
Tutorial Was Created. V1.0.0 Aug 30 2008: Added XHTML and a small CSS part. Also corrected some
small things and added this change log. V2.0.0
################################################################# OK.. Many people here want to
create text based games. Many of you ask us here on the forums: "how to create a text-based game....

Mysql Multiple Tables

(1)

It is good practice to use multiple tables to sort out big amounts of data. But once you do that it
becomes increasingly hard to cross reference the tables. Mysql has a little beautiful command
structure that they have added. You can select multiple tables within one sql query. Example of a
basic sql query CODE $sql = "SELECT * FROM table WHERE row=1"; If you noticed that I selected
all of the rows in the table. Normally you will try to not select the entire table from the database
unless you absolutely want all of the table. I would recommend against it; just gra....

Any Website Provide Free Host Mysql Host?

(4)

any website provide free host mysql host? i need it because i am using 000webhost.com now but it
only provide 2 mysql database... can i know where or how can i get more databases regards....

How To: Display A Members/user List.

With PHP, Mysql, and HTML. (3)

Alright, some of you might want to display your User's or Members on your site. Notes: 1.This
is to fit in with Feelay's register and Log-in scripts you can find in the tutorial section. 2.I
made this to show the members of my site who is a member and what their ID is. First off, we must
set up a connection to our MySQL Database. CODE $con =
mysql_connect("localhost","database_username","database_username_password"); if (!$con) {
die('Could not connect: ' . mysql_error()); } What it does: 1.It is starting a PHP
document. 2.Next it sets....

Looking For Script

need help (5)

i am making a web site about cell phones (tones-themes-wallpapers) and i am looking for good script
for my site with some nice options ....can any body help me /rolleyes.gif"
style="vertical-align:middle" emoid=":rolleyes:" border="0" alt="rolleyes.gif" />....

Myspace Gold Script

How to install (2)

Hello, I have a MySpace Gold Script but do not know how to use it. Can someone help!? I have a
MySpace gold script, this will let me build my own social networking site. I dont know much about
MySQL or Myphpadmin. This is my installation instructions To start with open the mainfile.php and
edit the settings to reflect your own. You will need to know your mysql database settings. If you do
not know what these are please ask you webhost and they will provide them to you. After this file
has been edited to your server settings, make sure that it is chmod to 444 (read only....

Php Tutorial: Making A Shoutbox

Requirements: PHP, MySQL (12)

Hi everyone, I'm going to tell you how to make a simple shoutbox using PHP and MySQL. To start
off, open up mysql in the command line, or phpmyadmin, and create a database called shoutbox. Next,
enter the following sql into the command line, or the phpmyadmin sql box, while using the shoutbox
database: CODE create table messages(author varchar(30), message text, time timestamp, mid int
auto_increment, primary key(mid)); This creates the table we need to store the messages, note the
"mid" column, this gives each message a seperate id number, we'll see why ....

Ajax + Php + Sql = Simply Superb! ( With Visitor Tracking )

A small tutorial to explain integrating php, ajax and MySQL Database (11)

Hi all.. I'm back with a new small tutorial! Introducation A tutorial to integrate
Ajax, Php And Database ( Im using MySQL) + Visitor Tracking! Here you can enter values to some
input fields, and by clicking some enter button, ( or u can call the function on some other event)
those values will be sent to the database, along with visitor details ( IP Address, Input Value,
Visitor Agent etc)! Those values will be stored in some database and you can retrieve the same using
some simple php code and even deleted some rows from those databases! Requiremen....

Need A Javascript To Enable / Disable Buttons

I need a script! (2)

Hey... I need a javascript script(I think its java) What i want the script to do: You have 2
buttons on a page 1 is a enter a different part of the site the other one is a vote which brings up
a pop-up page. i want the script to make it so you have to click the vote button before being able
to click the enter button. If you can do it, Thanks. post the script here....

Qupis : Free Cpanel Web Hosting (one Line Text Ad At Bottom)

150 MB space, 10000 MB Bandwidth, php, mysql, CPanel (10)

Hello Members, We are proud to introduce a new member to Xisto group of sites.
Qupis : Free Web Hosting 150 MB space, 5000 MB Bandwidth, php,
mysql, CPanel (Latest). Emails, FTP, Addon domains, Parked Domains etc.
http://www.Qupis.com
Feel free to add your reviews and comments about it. -AstaHost
Management ....

Navcat For MySQL

is Navcat any good? (9)

Hello all, i ve recently come across NavCat (GUI tool) for MySQL. I have not bought a copy yet, just
played around with the demo. Has any one used it beore, if so please let me know if its worth
buying. I already have PhpMyadmin, Just wanna know if NavCat is better than PhpMyAdmin in usibility
and functionality. Regards....

PHP & MySQL: Displaying Content From A Given ID

(6)

Okay so I got this sample link (not working): http://www.acosta.com/joo.asp?id=654 Now suppose
I have a PHP file that would use MySql in order to get all values in the row where id 654 is found.
Here's a sample DB: Table: demnyc ______________________________________ | id |
Name | Age | Email | *----------------------------------------------------* | 1
| Albert | 17 | no email |
*----------------------------------------------------* | 2 | YaPow | 888 |
no email | |__________....

Running Vba Script In Excel

(7)

Hi, I need help. Im generating a excel file using jakarta poi. I have added a vba to my excel
template so that it creates a chart on file open using the data populated using the poi map. Now
this works fine in a windows machine. But on a linux machine the vba does not execute. I need to
release my prod in linux too and im losing time. Is there any workaround for this???? Thanks in
advance Karthik....

CuteNews: PHP-based Blog System - No MySQL

(11)

I don't know if you guys have heard about CuteNews, but I think it's an awesome blogging
system. If you don't know where to get it or how to set it up, here is a quick run-down.
Download the zip file (virus free) from http://www.mysharebox.com/dl.php?key=8276639 . 1) Unzip
the file. 2) Make a folder titled "cutenews". 3) Upload the contents of the cutenews folder into the
one you've just created. 4) CHMOD the file index.php to 777. 5) CHMOD the folder "data" to 777.
6) Then CHMOD all the files and folders inside of "data" to 777. 7) Go to http://YO....

Important: Basics Of Using PHP And MySQL

(10)

I generally notice confusion with new users to PHP and or MySQL and first of all I believe that
unlike HTML which is automatically associated with a IE browser in a Microsoft system. HTML is
automatically rendered with whatever browser is the default browser, be it Internet Expolrer Firefox
Netscape or any other browser that has been set. PHP is a different matter to view the output of a
PHP file it must be run on a webserver, and if you do not have one set up on your local PC it simply
will not work. (Note serverside langauge requies a server) HTML is client side and ....

MySQL Output Database Question

(18)

I am new to MySql and have just created a database after using a script. My problem is not the
script, but what it says about putting it into the output file. I cant figure out the right terms
to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE
'location' but it isnt working. I'm lost with this stuff, I really am. Can someone
please help me out?....

MySQL For EasyPHP Users

Does anyone use this program? (5)

I installed a program called EasyPHP because it was an easy install and I wanted to be able to learn
php and still be able to down the road learn MySQL. But I can't figure out how to use MySQL.
Does anyone out there use this program that could tell me alittle about it. Alot of the product
site is written in a different language, but everything on the program is english so that is good.
Any help would be appreciated.....

[PHP + MySQL] Encrypting Data

To protect the password of your DB, for example. (11)

Hi! This is my 2nd code of PHP + MySQL. This code is VERY simple: it encript the data in the MySQL
DB. Here we go! ------------------------------------------------------------------------ CODE
$password = "abc"; $new_password = md5($password); echo $new_password; ?> The password "abc"
was codfied using md5() This will be: 900150983cd24fb0d6963f7d28e17f72 CODE $normal_pass =
"abc"; $encripted_pass = "900150983cd24fb0d6963f7d28e17f72"; if(md5($normal_pass) ==
$encripted_pass) echo "Login Sucessful!"; else echo "Incorrect password."; ?> This c....

Recover Tables From A MySQL .frm File

(8)

I have a couple of .frm files with no corresponding data or index files. Is it possible to recover
the table structure (field names, types, sizes, rows,col, etc) from these files? The table type is
innodb....

PHP: Writing A Generic Login And Register Script

(15)

Now there are basically 3 functions that a user management system provides: login, register, and
protection. A user management system can do more than this but that is all that this tutorial will
be covering. I will try to explain what I am doing as I go along but to fully understand what is
happening you should have a basic knowledge of PHP, SQL, and HTML. This tutorial assumes you are
using MySQL, adjust accordingly for a different DBMS. First off lets define the database table
where our users will be stored. Using phpMyAdmin run this statement to create our table....

MySQL Realtime Replication

how to replicate mysql in realtime (4)

i dont know if this might be useful to ppl here, but this is a very good knowledge for serious
siteadmins. while i was digging for mysql backup techniques, i've found that mysql is able to
do realtime replication. the idea is that there are master server and slave server. both are having
the same version of mysql installed. the data flows; Master >copy> Slave ( in realtime!)
you'll never have to manually copy the database file of wasting your time to manually use the
mysqldump command. here are the links; http://dev.mysql.com/doc/mysql/en/Replication_HOWTO.h....

How To Make A Text Based Online Game Script ?