portalku
Jan 11 2005, 04:36 AM
| | How.. man ?
my server is using internal control panel, and has no command or tools to manage the database.No PhpAdmin, No Cpanel, No Plesk
and it's make me confused how to create table in MySQL
Is there any command to run SQL file if I wish to create table without using cpanel or phpmyadmin?
Thx Buddy..! |
Reply
portalku
Jan 11 2005, 04:43 AM
Thanks CODEFX
I think your code is work
I make php file with your code, then I upload it, and I run in my browser... Is it correct? 
Reply
hpforums
Jan 11 2005, 05:04 AM
Tell you one thing? Why are you hosting your site where you do not have CPanel or PHPMyAdmin? Better host it with some host that offers CPanel. For e.g. - FNH.
Reply
God
Jan 11 2005, 06:20 PM
QUOTE
I make php file with your code, then I upload it, and I run in my browser... Is it correct?
Well, you'll have to put all the statements in your SQL file into the query, but yeah, that's right.
Reply
welbis
Jan 16 2005, 04:52 PM
In php/mysql i want to create 10 tables and add data to each one, but the file size is still small enough...
I'm incorporating this into a broswer based upload/backup script without using cpanel.... in php
Can i just put
$query = "
all of the sql info - for multiple tables and insertion and updation
";
$result = mysql_query($query);
in one file.
Will $result process all the queries if they are only defined as one big query? - or do i need to set it for each command
Reply
portalku
Jan 27 2005, 02:56 AM
Thank's For All Of You
Your Code Is Work
Spesial Thanks For CODEFX
Reply
God
Jan 27 2005, 03:20 AM
QUOTE In php/mysql i want to create 10 tables and add data to each one, but the file size is still small enough...
I'm incorporating this into a broswer based upload/backup script without using cpanel.... in php
Can i just put
$query = \"
all of the sql info - for multiple tables and insertion and updation
\";
$result = mysql_query($query);
in one file.
Will $result process all the queries if they are only defined as one big query? - or do i need to set it for each command Oooo-that's a tough one! For that, we go to the PHP manual and their wonderful function reference!
It turns out that you cannot execute more than one MySQL query in one mysql_query() function call. However, browsing the notes for the mysql_query function on their website reveals that someone made a function for running multiple queries:
CODE //$q is the query string ($thesql returned string)
//$link is the link to the database connection
//returns true or false depending on whether a single query is executed allows you to check to see if any queries were ran
function multiple_query($q,$link) {
$tok = strtok($q, ";n");
while ($tok) {
$results=mysql_query("$tok",$link);
$tok = strtok(";n");
}
return $results;
}
Okay. I'm going to have to explain a couple of things. First, The variables. As it says in the comments, $q is the query (containing multiple queries) you want to run. $link is the link returned by the mysql_connect function.
You're going to have to change your big query. After each individual query, you need to add a ';'. This is because the function tokenizes (separates) the query using these.
If this doesn't work, or if you have more questions, just post again.
Reply
Recent Queries:--
php executing sql files - 0.93 hr back. (1)
-
run sql file php - 9.54 hr back. (1)
-
how to execute sql queries to a file - 11.95 hr back. (1)
-
running .sql to create database - 12.38 hr back. (1)
-
i have a .sql file, how to create database? - 15.05 hr back. (1)
-
sql create table from a txt file - 16.44 hr back. (1)
-
php execute sql file - 12.21 hr back. (2)
-
how to exeute .sql file from mysql console - 18.05 hr back. (1)
-
gmysql execute an sql file - 19.07 hr back. (1)
-
".sql" create table from "sql file" - 21.80 hr back. (1)
-
"execute sql file" - 26.77 hr back. (1)
-
execute sql files by php - 27.80 hr back. (1)
-
sqlite php execute sql file - 32.46 hr back. (1)
-
how to run sql files - 10.41 hr back. (3)
Similar Topics
Keywords : execute, sql, file, create, table
- Secure File Transfer For Mainframe Systems
(2)
Will There Be A free Image, File, Video And Flash Host?
(5) Do you think there will ever be a free Image, File, Video, and flash host all on one site? I doubt
there is, and wouldn't it be great if you could register and have your own account, kinda like a
photobucket layout, but with more file extensions and file hosting, if there is link me right
away! It would be so awesome if they had unlimited image size and 5 minute video length. well
what are your thoughts on this?....
Need File Host
(7) i require a host to host files that has a good upload speed (unlike megaupload, sendspace) it
can't be filefront cuz i got banned for it not being game stuff. max file limit anythign over
100mb ....
Sig file problems
(8) I have a signatue image
I tried insert it using HTML -- BBCode EVERYTHING!!
but it just
displays my scripting--
What am i doing wrong?
Pleas PM me
--
Mike....
File Urls?
(5) I upload files to the public folder under a new folder now if I want to link these files to
hyperlinks on my site I need each files url. How do I go about finding this? Would these files if
zipped up become "downloadable" to my users?....
Loading values in txt file to database
(0) I have a script that during the install, I am to run a file that is supposed to load zip code data
into the database. It says it runs correctly at the end but yet the table in the database remains
empty.
Here is the code:
PHP Code:
CODE <? require('data.php');
require('functions.php'); sql_connect();
$file=file("admin/zip.txt"); $i=form_get("i"); $start=$i+1;
$end=$start+5000; if($end>=count($file)){ $end=count($file);
} for($i....
What files are you supposed to have under file manager?
(3) Can someone tell me the files that are supposed to be under file manager...thanks!....
Creating a settings file for your site (PHP)
(0) Being a designer, sometimes it's easy to overlook the little things that you'll hate yourself for
later on. For example, what if you change your domain name? Do you really want to change all 3254
links on your site?
Isn't there an easier way?
Yes
With a global settings file, you can
avoid this altogether.
Here's a template for creating such a file.
CODE <?php
/********************************************************** * Functions, Variables, Ect for
Revamp * * Author: VampyreVein ....
html imput file
(0) I would like to know if is possible to cange the file of the "html imput file" with source code
Thanks....
File size limit?
(16) Is there a file size limit on the upload? Cause I'm trying to upload a file size of 1.97mb and
everything it uploads at about 300kb it says QUOTE 421 Timeout (no new data for 900 seconds)
Connection lost: vaio-hosting.com
Transfer Failed! Anyhelp here?....
how to upload a file?
(4) How to use file manager in cpanel to upload a file from another web source. As my college does not
allow ftp acess. I tried once with a zip file it shows the size as one kb. is ther any other
option.......
Need: Public_html file...
(2) I deleted it cuzz I thought I didn't need it :S Please someone send me it!!!....
file format question
(12) Can I put some zip or rar file on the free hosting account?
because I want to share some file with
my friend....
Web Admin (file manager)
(7) i wanna share this web admin (file manager) written in php that i have downloaded in the script
sites.. try it and enjoy!!
COPY THE CODE AND SAVE IT AS *filename*.php THEN UPLOAD IT TO YOUR
WEBSERVER RUNNING A PHP.
/*
* webadmin.php - a simple Web-based file manager
* Copyright
(C) 2004 Daniel Wacker
*
* This program is free software; you can redistribute it
and/or modify
* it under the terms of the GNU General Public License as published by
* the Free
Software Foundation; either version 2 of the License, or
* (at your option) a....
Cpanel-->File Manager
(6) I don't get that the File Manager works. I am not able to go up any file, I believe that has
relationship with the problem of Cpanel
I hope you can solve the problem. Thank you for all
their help
Thank you....
FTP / File manager
(2) Hello,
When i enter my ftp or file maganer, I get NO directorys.
Not even public_html or www or
mail.
And if i try to upload someting: CODE 550 Name.txt: Permission denied
Suggests?
:? :shock:....
What is file()?
(3) how to use file()....
creating a file
(3) How to write to file such symbols like --> " / > <--- ?????....
File Manager
(17) I put a file in public_html then I wanted to update it, so I uploaded the updated file (same name)
and tried to put it in the same folder, you know, to update the file. But it said a file by that
name already exists. So I tried to delete the old file but I couldn't figure out how. And then my
brain exploded.....
File Extensions List
(4) Any time wondered about what type of file was that one with weird extension? Your problem is no
more! Buy now your package of file extensions, and extend your knowledge!
Just kidding... :wink:
This site is the most complete Windows/OS2/Apple/UNIX file extension list that I know. It
doesn't describe what applications open the files but tells the file type.
http://www.icdatamaster.com/
Hope it's useful!....
File size limit?
(15) Is ther any limit on a single files size?
Thanks!....
File Conversion Trouble
(2) i was given a couple of audio files from my boss that he needs to listen to. they are transcripts of
a meeting that were recorded on a panasonic voice recorder. the files have the extension *.pvc and
panasonics site says it is in a VM1 format. i have had no luck finding software to play (cant find
panasonic software for download) or convert to anything else. any help or suggestions?....
Setting Up WWW FILe SHARE PRO
(3) ile Share pro is a Filesharing software as the name suggest > IT will setup an http server right in
u r COM..
to download visit:
http://www.wfshome.com/index.html
1.Start the App - You can
leave the Port at 80.
2.Goto Settings - here will will change a fews things:-
Shared Path -
Virtual Directory Edit you can add any folders you like if you want to give access to certain
directories only.
Upload - Change this to where you would like your Uploads to be placed.
HTML
Page - Here you can change the title that is displayed on your page.
Color - Chan....
php tutorial - basics...up to mysql/file commands
(6) the best way to start php is probably not adjusting a script IMO - that misses out a stage. - the
very first stage /biggrin.gif' border='0' style='vertical-align:middle' alt='biggrin.gif' /> -
here...
Why use php? because it allows things to be generated very quickly - without lots of html
pages. It enables users you choose to allow, to input their own content to the pages you want them
to.
1) save these files as anyfilename.php - pick your names, upload them to a php enabled server
and go to the url they are at...
2) understand , .php, //////, /* */, and ;....
Which File Extension Are You?
(48) Ever wonder which file extension you are? /smile.gif' border='0' style='vertical-align:middle'
alt='smile.gif' /> Take the following test. http://bbspot.com/News/2004/10/extension_quiz.php as
for me: i'm a PDF! /biggrin.gif' border='0' style='vertical-align:middle'
alt='biggrin.gif' /> true, true. i have a certain attachment to PDFs. i collect PDF ebooks, and
even my default printer is set to print in PDF! /biggrin.gif' border='0'
style='vertical-align:middle' alt='biggrin.gif' /> any web page i want, i just press Ctrl-P, and
voila -- a PDF co....
2 Gb Free For File Storage Or Web Hosting
don't wait to see the link (12) here it is: CODE http://www.omnilect.com Omnilect is your own web storage, built on
the idea that you should be able to keep all the data you share in one place and access it anywhere.
The key features are: 2,000 Megabytes - Just For You. You need plenty of space - but it should be
space you can actually use. Omnilect gives you 2,000 megabytes of storage and lets you use your
space however you want - for email, photos, blogs, or whatever. We provide the services and the
space, you provide the data. Best Email, Calendar, & Addressbook. Omnilect has the b....
Looking for execute, sql, file, create, table
|
*RANDOM STUFF*
*SIMILAR VIDEOS*
Searching Video's for execute, sql, file, create, table
*MORE FROM TRAP17.COM*
|
advertisement
|
|
