[Bulk Insert => MYSQL]

Since people keep ignoring me... Ill post the question in a different way, without the source.

 

How do I instert multiple rows of SQL into a database from a php file?

Is there a way to have a PHP file read a MYSQL DUMP (.sql) file and run it?

 

==

 

Please reply this time.. -,-!

[!!!!!SMTP - WTF]

I have run every SMTP server I have found on the net, and unles me and 8 other people don't know how to install an SMTP server, our ISP blocks SMTP.

 

Is there a way to find out if they do?  I can't even use external SMTP servers, it says it can't connect.

[Parse error: syntax error, unexpected ';' in C:\*\*\*\sql.php on line 13218]

please?

[Role Play Fantasy & Xin Dynasty & Lunentia]

yes, but how do I speed up the entire thing? I have the fla... im in the edit... I don't see framerates...

 

IN ANY CASE, there is a "Skip This" link right underneath it...

[OMITTAG & SHORTTAG]

So... where does it go, and how do I put it in?

[Request Feeback : EasyRead Feature]

that page is yet to do validation

 

the rest of the site checks out though.

[Role Play Fantasy & Xin Dynasty & Lunentia]

It will be a full website with menu, soon.  right now it is a quikc flash splash, meant to be around 5secs not that slow.  I couldnt compile it with faster frames, so im just waiting for v2 to finish. the direct link is in teh main post to:

 

http://24.86.150.207/forum/forum.php

[PHP upload progress bar]

you can't unless you make cgi unload ALL of its variables to a text file and then make php read thattext file every time you want them to talk... althoguh if hte cgi redirects to a url iwth variables..?  you could use $_GET['var'] in php...

[PHP upload progress bar]

I would suggest, don't use php if you want a progress bar, or recompile php, or dont use an upload progress bar (that was my choice).

[Parse error: syntax error, unexpected ';' in C:\*\*\*\sql.php on line 13218]

that IS what I did, but for some reason it doesnt expect a ; somehwere near the end -,-.

 

Uh... so... I wish there was another way to insert the sql, but I can't link sql files like you would a css file -,-,-,-,-.

 

I originally did, uh.. fopen then fputs all the sql to a variable, but that had huge buffer problems, so I did this.

 

IF YOU HAVE ANOTHER WAY PLEASE TELL ME.

[Role Play Fantasy & Xin Dynasty & Lunentia]

I am asking for feedback on three sites hosted using my netowrking site.

 

the links are below:

 

http://24.86.150.207/forum/index.php (RolePlayFantasy)
http://24.86.150.207/XIN/forum/ (Xin Dynasty Beta)
http://24.86.150.207/Lunentia/ (Lunentia, Open)

We are getting domain names soon enough.

==

Each site is a SEPERATE site and the themes are not supposed to work together.  The main site I want feeback on is RPF.  I know the flash intro SUCKS but I'm working on it, and im really new at flash.  I might just use DHTML, but that is not xhtml compatible !!

 

Please tell me what you think of RPF, XIN, and Lunentia.

[Request Feeback : EasyRead Feature]

Yes I know, it i overly whitespaced.  I impleemented hte entire NETWORK of sites.  but i am specifically requesting help with the Easy Read feature.  Yes, the .. Tables are a problem, but I am right now working on making it all on one field (as it should be).  This is meant to convert entire threads into one large paragraph or page to make it easier to read role plays.

[[For Hire] Extremeties Validator, PHP, Mysql!]

I can be hired to do any of the following jobs:

 

Fix Validation or Browser Resolution Issues,

Convert pages to XHTML Strict 1.2 Valid...

Program many functions and page/programs in PHP and MYSQL.

 

I can also do much with CSS if needed.

 

Please post jobs

[[SOLVED] CSSGEN]

Any good working css generator programs?

 

I have been using the subsystem in DREAMWEAVER for a long time,

but it sucks.  Doesn't generate the css properly and doesnt support many inputs.

[PHP upload progress bar]

as I said above, its not supported in php.  It doesnt work properly and sometimes you will get notices and warnings in your scripts.  thats is, the html and xml part of it.

[Parse error: syntax error, unexpected ';' in C:\*\*\*\sql.php on line 13218]

cmon people, please?

[PHP upload progress bar]

see... php 5.1.2.0 was compiled WITHOUT one important C header file that would make it possible for php to be used with ajax asa per request platform

 

Either you recompile php with 5.1.2 and the cuproq.c and cuproq.h files,

or you find another wya of doing it, without ajax or cgi...

[[SOLVED] http to https on different domain]

one site can read another's cookies, althgouh its a security whole in IE7m it still can.

 

in the cookie http read request choose domain="whatevertheredirectsitewas"

and because of IE7 bad programming, and IE6, and FF2 not being fixed. u will get it -,-.

[[SOLVED] SELECT statement problem...]

to do sql on a seperate table from the one currently in:

 

''.''

 

In your instance you would need to call the usernames like this:

$result1 = "WHERE user.userid=mail.senderid'";
$result2 = "WHERE '".$result1."'.'userid' == 'user.userid'";

 

That example is in php though...

[Parse error: syntax error, unexpected ';' in C:\*\*\*\sql.php on line 13218]

ok im runnign word crawler now...

 

crawl("SQL.PHP,REPLACE ALL WHERE \" WITH \\");

 

It's replacing... I'll upoad SQL.php if the site lets me upload 3.5mb files -,-.

 

EDIT, replace finished, im running the program now....

 

EDIT, Page is loading... SQL.php is being parsed now...

EDIT, Page Parsing complete, now its inserting the SQL...

 

EDIT, 64912 files copied... Moving on to SQL...

 

Parse error: syntax error, unexpected ';' in C:\Inetpub\wwwroot\VB3.6.7\sql.php on line 13218

 

CURRENT SOURCE:

 

PHP FILE WITHOUT SQL:

<?PHP

function sql($DB) {
   $g_link = mysql_connect( '127.0.0.1', 'root', '') or die('Could not connect to server.' );
   mysql_select_db($DB, $g_link) or die('Could not select database.');

$sql = "
";

mysql_query($sql, $g_link) or die('Could not perform SQL.' . mysql_error();echo 'End of SQL.';

mysql_close($g_link);
}

?>

 

the full file can be found here:

http://24.86.150.207/sql.php.txt

 

The file is: 5,971 KBytes.

 

oh and to the quotes, it was BY HAND!!

I tried the file with double quotes now, escaping all $ and "... and I still got the same error.

[[SOLVED] Gah I hate MYSQL Queries.]

try using quotations in the php then:

 

<?php
 $query = "SELECT mem_dname FROM gs_mem WHERE mem_validate='".$mem_validate."'";
 $result = mysql_query($query);
 if ($result)
   {
   header("Location: http://www.veraci7y.net/GameSpaces/signup.php?step=three");
   }
 else
   {
die(mysql_error());
   }
?>

[[SOLVED] Gah I hate MYSQL Queries.]

its because your hash is not in quotes...

try

 

SELECT mem_dname FROM gs_mem WHERE mem_validate='e4b0f8a3528fe910f5225c95380f4417'

 

instead, in the phpmyadmin console.

['SOURCE' alternative?]

Are there any other ways to insert queries besides;

 

Source <filename>

and actually running all the sql?

[Request Feeback : EasyRead Feature]

I have just finished MAKING a vbulletin feature from scratch.

It took a long time, and I think most of the bugs are gone.

 

Please tell me if you get any errors with it..

 

http://24.86.150.207/forum/~asyread.php?&t=1

 

In "Thread Tools" at the top of every thread is a link "EasyRead This Thread".

Please tell me what you think of the EasyRead feature... Please tell me if it gives

any XHTML errors on those pages... IE: "Done, but with errors on the page"...

 

Our website is completely valid as you can see at the bottom of every page .

Please tell me if this page ~asyread.php. and its output, is valid.

[[SOLVED] Gah I hate MYSQL Queries.]

IT is taling about line one in your SQL

 

SELECT mem_dname FROM gs_mem WHERE mem_validate = 'somecode';

what are you looking for in the datbase (examlple of what goes in mem_validate

Run that through an SQL host... dio you have PHPMYADMIN acess?