Bytes - answers

retrieving multiple values with one mysql query

fishnfrogs — Fri, 20 Nov 2009 21:48:18 GMT

Hello everyone! I have an app that uses a for loop to go through an array and it selects all the values from my MySQL database and returns the values. I can't imagine that this is the best approach. My code kinda looks like this:

Expand|Select|Wrap|Line Numbers

	
$array = array('blah', 'bleep', 'bloop');

$password = 'test';

$name = 'something else';
 
$userArray = array();

$passArray = array();

$nameArray = array();
 
for($i=0; $i

    {

    $result = mysql_query("SELECT * FROM `table` WHERE `user`='$array[$i]' AND `password`='$password ' AND `name`='$name ' ORDER BY `date` DESC LIMIT 60");

        if($result) {

            while ($row = mysql_fetch_object($result)) {

            $userArray[] = $row->user;

            $nameArray[] = $row->name;

            $passArray[] = $row->password;

            }

        }

    }

Cna anyone offer up a better, more efficient way of going about this? Thanks in advanced!!

http://bytes.com/topic/php/answers/515554-using-local-php-ini-files

blackhowk — Fri, 20 Nov 2009 21:11:29 GMT

Hello All.
I have the same problem like in this post's:
http://bytes.com/topic/php/answers/515554-using-local-php-ini-files
the topic is closed. what should i do?

Confirming deletion of records

simonf — Fri, 20 Nov 2009 18:53:19 GMT

I have been developing a website over the past couple for my wife who is an artist. During that time I have taught myself PHP and mySQL and developed a content management system that allows her to upload and edit pictures, and and delete information like links and exhibitions and generally stop hassling me.

I have now extended it cover a couple of her art groups where she can create and delete new artists and they then have the same control.

As t has been just a hobby and only for her security hasn't been my greatest concern. However now that others are using it I am a bit concerned about hackers.

So my question is: How can I intercept a delete artist command and send an email to the person who has administrative rights to confirm that they really want to continue with the deletion as it could mean deleting hundreds of pictures. I already have an "are you really sure" page for accidents.

Many thanks in advance,

Simon

PS Her site is here and the group site here

Insert new row into middle of array

bugboy — Fri, 20 Nov 2009 16:36:19 GMT

I have an array which i want to insert a new value into the middle without losing any values. Is there an array function for this?

Expand|Select|Wrap|Line Numbers

	ARRAY(  [1]  =>  "a"  [2] =>  "c"   [3] =>  "d" )

//I would like to insert "b" at key [2]..  creating this:

ARRAY(  [1]  =>  "a"  [2] =>  "b"   [3] =>  "c"  [4] =>  "d" )

Thanks!

Update Item price based on prices of gold and silver.

santoshsri — Fri, 20 Nov 2009 15:16:21 GMT

Hi ,

I have a requirement in which the client's portfolio's net worth should change dynamically based on current price of Gold and silver.

Please advise how can I get this done.

Thanks !!

Combox data selecttion

kallol123 — Fri, 20 Nov 2009 10:32:42 GMT

I have a combox which contains the following values.

Expand|Select|Wrap|Line Numbers

	
As Per Spec

O.K.

Normal

Satisfactory

Good

N.A.

Form mySql query I got value 'Good'.
My problem how get selected the text 'Good' of combobox.

Pls help asap.

Kallol

php connection problem

yeshello54 — Fri, 20 Nov 2009 05:11:03 GMT

Here is my problem. I have a small php page that has a search function that returns the table that you search. It works fine . but my problem is that i dont want the data to show up until the user hits search. as of now when you go to the webpage all of the data tables are displayed and dont change untill you submit a new search. Any Ideas on how to fix this..

Thanks.

HTML email shows as text plain

matheussousuke — Thu, 19 Nov 2009 20:27:04 GMT

I'm having trouble with e-mail sending, I mean, the website is suposed to send a confirmation email after sign up, but it gets like text plain instead of HTML

May someone help me, please?

Here's the code

Expand|Select|Wrap|Line Numbers

	
require_once 'path_cnfg.php';
 
require_once(path_cnfg('pathToLibDir').'func_common.php');

require_once(path_cnfg('pathToLibDir').'func_checkUser.php');

require_once(path_cnfg('pathToCnfgDir').'cnfg_vars.php');

require_once(path_cnfg('pathToLibDir').'vars_gbl.php');
 
$myDB = db_connect();
 
$cookie = $HTTP_COOKIE_VARS['log_in_cookie'];
 
$content = array();
 
$submit = $HTTP_POST_VARS["submit"];
 
if ( !checkUser('', '') )

{   if ( $submit && $submit != 'validate' && checkForm() )

    {   $gbl["try_register"] = true;

        if ( prelim_insert() )

        {   $gbl["register_message"] = 'Um c�digo de registro foi enviado para seu endere�o de email.
Siga as instru��es no email para verificar seu registro.
' ; 

        }

        else

        {   $gbl["register_message"] = 'O registro preliminar falhou.
'.$gbl["register_message"];

        } 

    }
 
}
 
if ($gbl["loggedIn"])

{   $content[] = "echo 'Voc� j� est� logado no sistema.';";

}

elseif (!$submit)

{   $content[] = "echo 'Apenas n�meros, letras, e o caractere underline( _ ) s�o permitidos no nome de usu�rio.
';";

    $content[] = 'doForm();';

}

elseif ($gbl["errors"]!="")

{   $content[] = "echo 'Erros:
';";

    $content[] = "echo '';" ;

    $content[] = 'echo $gbl["errors"] ;' ;

    $content[] = 'echo "
";' ;

    #echo $content[(count($content)-1)]."
";

    $content[] = 'doForm();';

} 

elseif ($gbl["try_register"])

{   $content[] = 'echo $gbl["register_message"];';

}
 
// This line brings in the template file.

// If you want to use a different template file 

// simply change this line to require the template 

// file that you want to use.

require_once(path_cnfg('pathToTemplatesDir').cnfg('tmplt_register'));
 
db_disconnect($myDB);
 
# --- START FUNCTIONS ---
 
// *********** START FUNCTION prelim_insert() *************
 
function prelim_insert()

{ 

    GLOBAL $gbl, $myDB, $HTTP_POST_VARS ;
 
    $new_user_name = $HTTP_POST_VARS["new_user_name"];

    $email = $HTTP_POST_VARS["email"];

    $password1 = $HTTP_POST_VARS["password1"];
 
    $query = "SELECT user_name FROM std_users 

              WHERE user_name='$new_user_name'";
 
    $result = mysql_query($query, $myDB);
 
    if (mysql_num_rows($result) > 0)

    {   $gbl["register_message"] .= 'Sinto muito, mas este nome de usu�rio j� est� sendo usado, por favor digite outro nome.
';

        return false;

    }
 
    srand((double)microtime()*1000000);
 
    $the_rand = rand(1, 10000);

    $the_rand2 = rand(1, 10000);

    $the_rand3 = rand(1, 10000);
 
    $the_rand = ''.$the_rand.''.$the_rand2.''.$the_rand3;
 
    $query = "INSERT INTO std_temp_users(user_name, password, email, sign_up_date, prelim_rand) VALUES('$new_user_name', '$password1', '$email', ".time().", '$the_rand')";
 
    $result = mysql_query($query, $myDB);
 
    if (!$result) 

    {   if ( preg_match("/duplicate entry/i", mysql_error()) )

        {   $gbl["errors"] .= "Por favor digite outro nome de usu�rio.

                                Este j� est� em uso.";

        }
 
        return false;

    }
 
    $to = $email;

    $subject = 'Seu cadastro';
 
    $the_link = cnfg('deDir').'verify_registration.php';
 
    $message = '
 
    Por favor siga estas instru��es para verificar seu registro:

    1. Clique no link abaixo:

    2. Digite o usu�rio e o c�digo de confirma��o que est� localizado abaixo desta linha.

    Observa��o: Ap�s verificar seu cadastro voc� far� login no site usando o nome usu�rio e senha  que voc� cadastrou. 

    O c�digo de confirma��o � usado apenas para confirmar o seu cadastro.

    Username: '.$new_user_name.'

    C�digo de confirma��o:  '.$the_rand.'

     ' ;
 
    $message .= "$the_link";
 
    $message .= '';
 
    #$headers = "MIME-Version: 1.0\r\n";

    #$headers .= "Return-Path: <".cnfg('replyEmail').">\r\n";

    #$headers .= "X-Sender: <".cnfg('replyEmail').">\r\n"; 

    #$headers .= "X-Mailer: PHP\r\n"; // mailer

    $headers .= "De: <".cnfg('replyEmail').">".$gbl['newLine'];

    $headers .= "Responder para: <".cnfg('replyEmail').">".$gbl['newLine'];

    $headers .= "tipo de conte�do: text/html; charset=iso-8859-1".$gbl['newLine'];
 
    if ($result) 

    {   if ( mail($to, $subject, $message, $headers) )

        {   return true;

        }

        else

        {   echo 'erro ao enviar email
';

            return false;

        }

    }

    else 

    {   return false;

    }
 
} // end function prelim_insert()
 
// *********** END FUNCTION prelim_insert() *************
 
// *********** START FUNCTION doForm() *************
 
function doForm()

{

    GLOBAL $HTTP_POST_VARS ;
 
    $new_user_name = $HTTP_POST_VARS["new_user_name"];

    $password1 = $HTTP_POST_VARS["password1"];

    $password2 = $HTTP_POST_VARS["password2"];

    $email = $HTTP_POST_VARS["email"];
 
    if (!$submit || $errors!="")

    {

        ?>
 
        register.php" METHOD="POST">

         Nome de usu�rio: 

          " SIZE="15">        

        Embora este site seja seguro, n�o � poss�vel evitar tentativas de invas�o de hackers, por favor, evite usar senhas pessoais, como por exemplo, senhas de email.

Senha:

" SIZE="15">

Digite sua senha novamente:

" SIZE="15">

Endere�o de Email:

" SIZE="15">

Termos de utilização

Apesar dos administradores deste site tentarem remover ou editar qualquer material indesej�vel logo que detectado, � imposs�vel rever todos os an�ncios. Como tal voc� reconhece por este meio que todos os an�ncios colocados no site expressam os pontos de vista e opini�es dos seus respectivos autores e n�o dos administradores, moderadores ou o encarregado das p�ginas (exceto an�ncios colocados por essas pessoas) n�o sendo por tais respons�veis.

Voc� aceita n�o colocar qualquer mensagem ou imagem abusiva, obscena, invulgar, insultuosa, de �dio, amea�adora, sexualmente tendenciosa ou qualquer outro material que possa violar qualquer lei em vigor, como por exemplo, pedofilia e racismo. Se tal acontecer isso ir� conduzir � sua expuls�o imediata e permanente (al�m de ser notificado o seu fornecedor de Internet). Voc� concorda que quem faz e mant�m estas p�ginas, administradores deste site t�m o direito de remover, editar, mover ou encerrar qualquer an�ncio em qualquer altura que eles assim o entendam e seja impl�cito. Como utilizador voc� aceita que qualquer informa��o que forneceu acima seja guardada numa base de dados. Apesar dessa informa��o n�o ser fornecida a terceiros sem a sua autoriza��o, o encarregado das p�ginas, administradores n�o podem assumir a responsabilidade por qualquer tentativa de ato de "hacking" (intromiss�o for�ada e ilegal que conduza a essa informa��o ser exposta).

Este sistema de an�ncios usa "cookies" para guardar informa��o no seu computador. Esses "cookies" n�o possuem nenhuma das informa��es acima fornecidas, apenas serve para melhorar o seu prazer a quando e enquanto visita este site. O endere�o de e-mail � apenas usado para confirmar a informa��o do seu registro e a senha (bem como para enviar novas senhas caso se esque�a da que acabou de submeter).

Ao clicar em �Enviar�, voc� concorda com as condi��es impostas nos Termos de Utiliza��o.

} // end if

} // end function doForm()

// *********** END FUNCTION doForm() *************

// *********** START FUNCTION checkForm() *************

function checkForm()

{

GLOBAL $gbl, $HTTP_POST_VARS ;

$new_user_name = $HTTP_POST_VARS['new_user_name'];

$password1 = $HTTP_POST_VARS['password1'];

$password2 = $HTTP_POST_VARS['password2'];

$email = $HTTP_POST_VARS['email'];

$submit = $HTTP_POST_VARS['submit'];

if ($submit)

{ if ($new_user_name)

{ if ( preg_match("/[^0-9a-zA-Z_]/", $new_user_name ) )

{ $gbl['errors'] .= '� Invalid characters
' ;

$new_user_name='';

}

if ( (strlen($new_user_name) < cnfg('userNameMinLength') )

|| (strlen($new_user_name) > cnfg('userNameMaxLength') ) )

{ $gbl['errors'] .= '� Nomes de usu�rios devem ter menos de ';

$gbl['errors'] .= cnfg('userNameMaxLength').', e mais de ';

$gbl['errors'] .= cnfg('userNameMinLength').' caracteres.
';

}

else

{ $gbl['errors'] .= '� Voc� n�o digitou um nome de usu�rio.
';

}

if($password1 && $password2)

{ if($password1 != $password2)

{ $gbl['errors'] .= '� As senhas digitadas n�o correspondem uma a outra
';

$password1 = '';

$password2 = '';

}

if ( (strlen($password1) < cnfg('userPassMinLength') )

|| (strlen($password1) > cnfg('userPassMaxLength') ) )

{ $gbl['errors'] .= '� Senhas devem ter menos de ';

$gbl['errors'] .= cnfg('userPassMaxLength').', e mais de ';

$gbl['errors'] .= cnfg('userPassMinLength').' caracteres.
';

}

else

{ $gbl['errors'] .= '� Voc� precisa digitar uma senha.
';

$password1 = '';

$password2 = '';

}

if ($email)

{ if ( !preg_match("/([\w\-\.])+@([\w\-\.])+\.([a-zA-Z])+/i", $email) )

{ $gbl['errors'] .= '� Endere�o de e-mail inexistente.
';

$email = '';

}

else

{ $gbl['errors'] .= '� Voc� precisa digitar um endere�o de email.
';

}

} // end if($submit)

if ($gbl['errors'] != '')

{ return false;

}

else

{ return true;

}

} // end function checkForm()

// *********** END FUNCTION checkForm() *************

best way to display a word file on a php page in the same format

kkshansid — Thu, 19 Nov 2009 05:26:08 GMT

what is the best way to display a word file on a php page in the same format
as it is on word format ?
word file has some very well diplay of data in tabular format
php page has includes header,footer,left,right
i want to display it in the middle but by simply copy pasting error it doesnt display in the same format

Flash into Wordpress

duffydj — Wed, 18 Nov 2009 21:59:36 GMT

Hi. First of all, thanks for all your answers on this website.
Now it's my turn to try to get an answer.
I'm trying to insert a rotating header or banner into my wordpress blog and I have the SWF file already done. I just need help how to put into wordpress.
I know very little or nothing of PHP.
Could you please give me a little help on this?
Thanks!

Displaying data based on URL

artemishawk — Wed, 18 Nov 2009 21:17:37 GMT

I am kind of new to PHP and I would like to set up a page that displays information based on the url visited. For example, a user visits www.website.com/test. I need the page to determine if there is a "test" in my SQL database and display a default page filled in with the data associated with that entry in the database if there is. If not, a message stating the data was not available would be displayed.

I really appreciate any help that can be offered. Thanks!

mysql_num_rows(): supplied argument is not a valid MySQL

matheussousuke — Wed, 18 Nov 2009 18:20:07 GMT

I'm having the following trouble:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mghosped/public_html/anuncieaki/lib/func_common.php on line 149

This is the line 149

Expand|Select|Wrap|Line Numbers

for ($i=1; $i

The same script works fine in another server, but not in that one.

Sliding menu of images

phobia1 — Wed, 18 Nov 2009 16:48:22 GMT

Hi to all
I can make a presentation of fixed images easily in Flash.
I want to ask if its possible to do it dynamically from a database?
Regards
F

PHP Memory Limit

code green — Wed, 18 Nov 2009 14:45:37 GMT

Is there a maximum or recommended limit to the amount of memory allocated to a PHP script.
Some queries on a MsSql database are breaking a temporary 72mb limit.

I feel comfortable increasing this to 128mb but how far can the limit be set?
And should the limit be multiples of 8mb or can say 100mb be allocated?

I am working on happinessworks website and in that i have upload the image of product

prabhakar shelke — Wed, 18 Nov 2009 14:32:32 GMT

I am working on happinessworks website and in that i have upload the image of product. i successfully done it on localhost but i can't upload on the server plz help me. Thanks inadvance.