RE: [PHP] Inserting data at runtime (php,mysql)
| From: | Dan Parry | Date: | Tue, 21 Mar 2006 12:49:20 +0000 |
| Subject: | RE: [PHP] Inserting data at runtime (php,mysql) | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-232315@lists.php.net to get a copy of this message | ||
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
-----------------------------------------------------
Dan Parry
Senior Developer
Virtua Webtech Ltd
http://www.virtuawebtech.co.uk
-----Original Message-----
From: sathyashrayan [mailto:foraci@gmail.com]
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" <dan@virtuawebtech.co.uk>
To: "'sathyashrayan'" <foraci@gmail.com>;
<php-general@lists.php.net>
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:foraci@gmail.com]
> 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:
>
> <?php
> $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.
>
>