Re: [PHP] Re: Database design
On Thu, 2010-02-25 at 22:03 -0300, Manuel Lemos wrote: > Hello, > > on 02/25/2010 02:37 AM Angus Mann said the following: > > Hi all. I know this is not strictly a PHP question but the code will be > > written in PHP, and I figure the folks here will be well versed in the > > questions I raise. Please feel free to contact me off the list if > > appropriate. > > > > I need some assistance with database design for a project I'm coding in > > PHP. I'm willing to pay for the advice, since I think it will be a bit > > complex. I plan to use MySQLi > > > > If anybody feels they can assist, or can point elsewhere please feel free > > to contact me off list, or reply to the list if you think appropriate. > Hi Angus Mann.. I have been updating database design with various e-books. I think this might be a good time for me to try out some applications. I want to join your project. No money terms needed. All i want is to get involved. Thanks for any reply.. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Online tests for php
On Wed, 2011-04-13 at 09:08 -0400, robert mena wrote: > Hi, > > I am trying to hire some php developers for a local taks and I need to > somehow perform a triage. One of the aspects is the knowledge of PHP itself > so I was wondering if there is any set of questions (multiple choice) to try > to do that. > > I am not looking for a certification level in those tests but a way to at > least know what this guy knows. I am not a regular poster here but I do watch posts. My suggestion is taking your time and learning php/mysql is your only way I suppose. Else be ready to get cheated. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] installing error
On 5/26/07, Tijnema <[EMAIL PROTECTED]> wrote: On 5/26/07, Richard Davey <[EMAIL PROTECTED]> wrote: > Hi Rafael, > > Saturday, May 26, 2007, 12:38:15 AM, you wrote: > > > Hello does anyone know the correct way to install PHP and APACHE (last > > versions both of them) on WinXP???, Im doing it with the installers and I > > cannot even run phpinfo(); script, I see apache's error log and it says that > > i cant find SAM directory > > http://wamp.corephp.co.uk > > Cheers, > > Rich May be this helps. http://www.tanguay.info/wamp/installPhp5.php5 -- "War doesn't determine who is right, war determines who is left." Chinese proverb
Re: [PHP] Inserting data at runtime (php,mysql)
- Original Message - From: "Thorsten Suckow-Homberg" <[EMAIL PROTECTED]> To: "sathyashrayan" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, March 21, 2006 6:00 PM Subject: Re: [PHP] Inserting data at runtime (php,mysql) The connection is successful but the data are not getting inserted into the table. I need to insert all the words into the table. When I change the insert statement with one insert at a time, I can insert values to the database. For exampel: $qure = "INSERT INTO dict VALUES (1,'apple')"; Do I need to check the formatted data in the file? Can any one help me in this regard? I have been working in VC++ for some time. Replace $str = mysql_query($qure); with $str = mysql_query($qure) or die(mysql_error()); I bet there is an enquoting problem with the data you want to insert... That does not show me any error. I think I need to check for the enter character for each data in the file. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Inserting data at runtime (php,mysql)
- Original Message -
From: "Dan Parry" <[EMAIL PROTECTED]>
To: "'sathyashrayan'" <[EMAIL PROTECTED]>;
Sent: Tuesday, March 21, 2006 6:12 PM
Subject: RE: [PHP] Inserting data at runtime (php,mysql)
[snip]
$conn=mysql_connect(" ");/*with the required parameters*/
if(!conn) <<<
{
[/snip]
You are testing conn in your if condition... should that not be $conn?
Dan
No if conn evaluates to false then error.
-
Dan Parry
Senior Developer
Virtua Webtech Ltd
http://www.virtuawebtech.co.uk
-Original Message-
From: sathyashrayan [mailto:[EMAIL PROTECTED]
Sent: 21 March 2006 12:20
To: php-general@lists.php.net
Subject: [PHP] Inserting data at runtime (php,mysql)
I have given a task to create a site which is a clone of www.onelook.com.
As a first stage I have downloaded a list of English words (only words not
meaning)
in a text format. I have created a data structure in the mysql database.
And
wrote the
following code to insert data into the table at the run time.
The code:
The connection is successful but the data are not getting inserted into
the
table. I need to insert all the words into the table.
When I change the insert statement with one insert at a time, I can
insert
values to the database. For exampel:
$qure = "INSERT INTO dict VALUES (1,'apple')";
Do I need to check the formatted data in the file?
Can any one help me in this regard?
I have been working in VC++ for some time.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Inserting data at runtime (php,mysql)
Yes it is a error.Thanks.
- Original Message -
From: Dave Goodchild
To: sathyashrayan
Sent: Tuesday, March 21, 2006 6:16 PM
Subject: Re: [PHP] Inserting data at runtime (php,mysql)
Yes, but it should be $conn, not conn. There is no $ in front of the variable
name...
On 21/03/06, sathyashrayan <[EMAIL PROTECTED] > wrote:
- Original Message -
From: "Dan Parry" < [EMAIL PROTECTED]>
To: "'sathyashrayan'" <[EMAIL PROTECTED]>;
Sent: Tuesday, March 21, 2006 6:12 PM
Subject: RE: [PHP] Inserting data at runtime (php,mysql)
> [snip]
> $conn=mysql_connect(" ");/*with the required parameters*/
> if(!conn) <<<
> {
> [/snip]
>
> You are testing conn in your if condition... should that not be $conn?
>
> Dan
>
No if conn evaluates to false then error.
> -
> Dan Parry
> Senior Developer
> Virtua Webtech Ltd
> http://www.virtuawebtech.co.uk
> -Original Message-
> From: sathyashrayan [mailto: [EMAIL PROTECTED]
> Sent: 21 March 2006 12:20
> To: php-general@lists.php.net
> Subject: [PHP] Inserting data at runtime (php,mysql)
>
> I have given a task to create a site which is a clone of www.onelook.com.
> As a first stage I have downloaded a list of English words (only words not
> meaning)
> in a text format. I have created a data structure in the mysql database.
> And
> wrote the
> following code to insert data into the table at the run time.
>
> The code:
>
> $counter = 0;
> $conn=mysql_connect(" ");/*with the required parameters*/
> if(!conn)
> {
> die('could not connect:'.mysql_error());
> }
> echo "connection sucess\n";
>$file_op = fopen("my_dic.txt","r");
> while(!feof($file_op) && $file_op != NULL)
> {
> $funct_var = fgets($file_op);
> while($funct_var)
> {
>
>$qure = "INSERT INTO dict VALUES
> ($counter,'$funct_var')";
>$str = mysql_query($qure);
>$counter++;
>return;
> }
> fclose($file_op);
> }
>
>
> ?>
>
> The connection is successful but the data are not getting inserted into
> the
> table. I need to insert all the words into the table.
> When I change the insert statement with one insert at a time, I can
> insert
> values to the database. For exampel:
>
> $qure = "INSERT INTO dict VALUES (1,'apple')";
>
> Do I need to check the formatted data in the file?
>
> Can any one help me in this regard?
>
> I have been working in VC++ for some time.
>
>
--
PHP General Mailing List ( http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Inserting data at runtime (php,mysql)
- Original Message - From: "João Cândido de Souza Neto" <[EMAIL PROTECTED]> To: Sent: Tuesday, March 21, 2006 5:54 PM Subject: [PHP] Re: Inserting data at runtime (php,mysql) It gives you any error? No the data are not getting inserted. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Inserting data at runtime (php,mysql)
- Original Message -
From: "Dan Parry" <[EMAIL PROTECTED]>
To: "'sathyashrayan'" <[EMAIL PROTECTED]>;
Sent: Tuesday, March 21, 2006 6:19 PM
Subject: RE: [PHP] Inserting data at runtime (php,mysql)
conn denotes a constant where the value you are assigning is to the
variable
$conn
[snip]
>>> $conn=mysql_connect(" ");/*with the required parameters*/
if(!conn) <<<
[/snip]
Depending on your error level this may evaluate to TRUE creating a false
positive
Or am I wrong?
Dan
You are corrct.
-
Dan Parry
Senior Developer
Virtua Webtech Ltd
http://www.virtuawebtech.co.uk
-Original Message-
From: sathyashrayan [mailto:[EMAIL PROTECTED]
Sent: 21 March 2006 12:45
To: Dan Parry; php-general@lists.php.net
Subject: Re: [PHP] Inserting data at runtime (php,mysql)
- Original Message -
From: "Dan Parry" <[EMAIL PROTECTED]>
To: "'sathyashrayan'" <[EMAIL PROTECTED]>;
Sent: Tuesday, March 21, 2006 6:12 PM
Subject: RE: [PHP] Inserting data at runtime (php,mysql)
[snip]
$conn=mysql_connect(" ");/*with the required parameters*/
if(!conn) <<<
{
[/snip]
You are testing conn in your if condition... should that not be $conn?
Dan
No if conn evaluates to false then error.
-----
Dan Parry
Senior Developer
Virtua Webtech Ltd
http://www.virtuawebtech.co.uk
-Original Message-
From: sathyashrayan [mailto:[EMAIL PROTECTED]
Sent: 21 March 2006 12:20
To: php-general@lists.php.net
Subject: [PHP] Inserting data at runtime (php,mysql)
I have given a task to create a site which is a clone of
www.onelook.com.
As a first stage I have downloaded a list of English words (only words
not
meaning)
in a text format. I have created a data structure in the mysql database.
And
wrote the
following code to insert data into the table at the run time.
The code:
The connection is successful but the data are not getting inserted into
the
table. I need to insert all the words into the table.
When I change the insert statement with one insert at a time, I can
insert
values to the database. For exampel:
$qure = "INSERT INTO dict VALUES (1,'apple')";
Do I need to check the formatted data in the file?
Can any one help me in this regard?
I have been working in VC++ for some time.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Inserting data at runtime (php,mysql)
I have given a task to create a site which is a clone of www.onelook.com. As a first stage I have downloaded a list of English words (only words not meaning) in a text format. I have created a data structure in the mysql database. And wrote the following code to insert data into the table at the run time. The code: The connection is successful but the data are not getting inserted into the table. I need to insert all the words into the table. When I change the insert statement with one insert at a time, I can insert values to the database. For exampel: $qure = "INSERT INTO dict VALUES (1,'apple')"; Do I need to check the formatted data in the file? Can any one help me in this regard? I have been working in VC++ for some time.
[PHP] Beginner's php/mysql connection probs
Dear group, (I am a very beginner so please bear with me for a simple question) I am a self thought php beginner. I wrote my first toy code for database connection in php/mysql. The connection is successful but iam getting a warning and my rows/columns are not showing. I am getting a warning: Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in c:\webs\test\dbs\one.php on line 13 I went through the php manual for the above mentioned function where I get no clue. Pls guide me. code: my first data base page [OT] And one more thing is if I want to replay to a msg in this mail list do I have to hit replay button or replay-all button for posting in the mail list. I use "microsoft outlook 2000" [/OT] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Beginner's php/mysql connection probs
-Original Message-
From: John Nichel [mailto:[EMAIL PROTECTED]
Sent: Friday, April 28, 2006 9:11 PM
To: Php-General
Subject: Re: [PHP] Beginner's php/mysql connection probs
sathyashrayan wrote:
> Dear group,
>
> (I am a very beginner so please bear with me for a simple question)
>
> I am a self thought php beginner. I wrote my first toy
> code for database connection in php/mysql. The connection
> is successful but iam getting a warning and my rows/columns
> are not showing. I am getting a warning:
>
> Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result,
> boolean given in c:\webs\test\dbs\one.php on line 13
>
> I went through the php manual for the above mentioned function where
> I get no clue. Pls guide me.
>
> code:
>
>
>
> my first data base page
>
>
>
> $conn = mysqli_connect("localhost","root","passwd","temp")
> or die("conn failed");
> $temp1 = "select *from grape_varity";
> $result = mysqli_query($conn,$temp);
Your query is failing. I'm guessing that it's because you don't have a
space between '*' and 'from'
Better if you check to make sure the query was successful before trying
to get the data
if ( ! $result = mysqli_query ( $conn, $temp ) ) {
echo ( mysqli_error ( $conn ) );
} else {
while ( $row = mysqli_fetch_row ( $result ) ) {
/// more code
Thanks for the quick help. I changed the code as you sugested and get
"Query was empty" as the result of the line echo (mysqli_error($conn)). So
does that mean the table is empty? But I did filled the table with some
value and mysql query displays the tables.
Simple error handling...you'll want to do more than that, but that will
give you the gist of it
> while($row=mysqli_fetch_row($result))
> {
> for($i =0;$i < mysqli_num_fields($result);$i++)
> echo $row[i]." ";
> echo "\n";
> }
>
> mysqli_close($conn);
>
> ?>
>
>
>
>
> [OT]
> And one more thing is if I want to replay to a msg in this mail list
> do I have to hit replay button or replay-all button for posting
> in the mail list. I use "microsoft outlook 2000"
>
> [/OT]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Beginner's php/mysql connection probs
-Original Message-
From: John Nichel [mailto:[EMAIL PROTECTED]
Sent: Friday, April 28, 2006 10:14 PM
To: Php-General
Subject: Re: [PHP] Beginner's php/mysql connection probs
sathyashrayan wrote:
> -Original Message-
> From: John Nichel [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 28, 2006 9:11 PM
> To: Php-General
> Subject: Re: [PHP] Beginner's php/mysql connection probs
>
>
> sathyashrayan wrote:
>> Dear group,
>>
>> (I am a very beginner so please bear with me for a simple question)
>>
>> I am a self thought php beginner. I wrote my first toy
>> code for database connection in php/mysql. The connection
>> is successful but iam getting a warning and my rows/columns
>> are not showing. I am getting a warning:
>>
>> Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result,
>> boolean given in c:\webs\test\dbs\one.php on line 13
>>
>> I went through the php manual for the above mentioned function where
>> I get no clue. Pls guide me.
>>
>> code:
>>
>>
>>
>> my first data base page
>>
>>
>>
>> > $conn = mysqli_connect("localhost","root","passwd","temp")
>> or die("conn failed");
>> $temp1 = "select *from grape_varity";
>> $result = mysqli_query($conn,$temp);
>
> Your query is failing. I'm guessing that it's because you don't have a
> space between '*' and 'from'
>
> Better if you check to make sure the query was successful before trying
> to get the data
>
> if ( ! $result = mysqli_query ( $conn, $temp ) ) {
> echo ( mysqli_error ( $conn ) );
> } else {
> while ( $row = mysqli_fetch_row ( $result ) ) {
> /// more code
>
> Thanks for the quick help. I changed the code as you sugested and get
>
> "Query was empty" as the result of the line echo (mysqli_error($conn)). So
> does that mean the table is empty? But I did filled the table with some
> value and mysql query displays the tables.
You assigned your query to the variable $temp1, but pass $temp to
mysqli_query()
Yes, now it works, thanks.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
