My Host Has NO PHP, Pull This Data From Another Server
I'm wondering if anyone here can point me in the right direction. My host
does not provide php, and so I need to pull this data from another server
that does support such scripting.
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
PHP/MySql On A Host Server
I'm very new to PHP/MySql and this is probably a complex question with a very simple answer. I have two hosts, godaddy and hostican and have the identical problem on both. I've successfully set up a database with tables. I've inserted data into the table. But I've done this all through cPanels. When I try to do it through PHP the script seems to work but the results (new tables, inserted data) doesn't show up when I go back to cPanels and look for them. Code:
View Replies !
View Related
Getting Ip Or Host Name Of Requesting Server.
I have a web server with a bunch of web services. I have another server calling these web services. I need to get the ip of the 2 server(the server calling the web services) within the actual web service method(the files stored on the first server hosting the web services). i tried $_SERVER['REMOTE_ADDR'] but that give me the ip of the user using the 2nd server, not the ip of the second server.
View Replies !
View Related
Web Host Says I Crashed The Server
My site was running fine until a week ago when the server seemed to be down a lot. When I contacted my web host, they said they would transfer my site to a seconday, "more" stable server. That's when my nightmare began. After moving to the new server, they asked me to change my scripts to accomodate the register globals. Last night, my site got suspended. Web host says that one particular page is maxing out their CPU's 3GHz processing. This never happened before (my site has been up 2 years). One possible explanation (I thought of) was that web owners were leaving them and due to shortage of funds, they have had to downgrade their servers package. Is this logical? If not, Why would or could such a thing suddenly happen supposedly caused by a page that has hardly been updated? Virus?
View Replies !
View Related
Decent PHP Virtual Server Host
I'm currently using startlogic.com for my PHP/MySQL virtual server. At $20, it's hard to beat the price. Unfortunately, I'm getting more and more dissatisfied with their uptime. I need PHP, MySQL, and the ability to host multiple domains. Are there any other hosts y'all have had good or bad experiences with?
View Replies !
View Related
Host Address For Mysql Server
My mysql database resides on the server. I have to connect it by navicat or other conversion tool. But there is some problem of host address. It shows the incorrect host address or port no. It seems that host address is wrong. What may be the host address of mysql server.
View Replies !
View Related
Unknown MySQL Server Host
I have some PHP code, running on my machine which connects with a remote MySQL database. Before deploying the code I test is locally. When deployed it then sits on a hosted server and accesses the same database. There is no conditional code and this was all working well until recently. I needed to enhance the appliation and made the changes but now it fails to connect giving error Quote: Code:
View Replies !
View Related
Uploading A File To A Web Host Server?
In the email they sent regarding the account information, they asked me to put all the html files in the 'public_html' folder. So I thought it should be same for php too. I put some .php files and also a .html file in the 'public_html' folder and when I tried to view the .php file, nothing comes up. But the htlml comes ok in the browser. I used ftp to put the files in their server. Does .php files have some other way to put in the server?
View Replies !
View Related
Pull Data Out Off Mysql
I am making a database using mysql where i have 2 tables, one for car manufacturers and one for car models.I've already done that. I have made a php page where i have 2 drop down menus. The first menu shows car makers(manufacturers) and the 2nd nothing. Now when a user opens the 1st menu and selects a maker , the 2nd automatically fills up with models from that car maker only and it gets its information from the database.That is every time i decide to add a new model to my database the 2nd menu (if selected) must go and search the database for all the models for that maker and show them. Code:
View Replies !
View Related
How Do You Pull All Data From A Field?
How do you pull all data froma field no matter what its result.. like this.. results.php?city=$city&type=ALL&zone=$zone so where type=all i want to get all restaurants in whatever $city in whatever $zone, meaning chinese, mexican, all rest listed in persay newyork zone 1 what is the wildcard to pull that..
View Replies !
View Related
Unknown MySQL Server Host 'localhost '
I'm rather new to both MySQL and PHP. I've been trying to use PHP to write to a MySQL database. I call mysql_pconnect to get a database connection, but then when I call mysql_db_select, I get the following error : Unknown MySQL Server Host 'localhost ' I can connect to the database via the command line ok. Where can I look to find the source of this problem?
View Replies !
View Related
Host Switched Web Server.. Sessions Not Working
our web host switched us to cPanel and now all of our logins on our website are not working at all here is the error message we get. Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /homedirs/sonotek/public_html/sono-tek.com/pdf_download/pdflogin.php:2) in /homedirs/sonotek/public_html/sono-tek.com/pdf_download/pdflogin.php on line 3 I am using session_start(); at the beginning of each script here is a sample: ....
View Replies !
View Related
Upload From Local Host To Server Using Ftp Functions
On my website I upload files from local computer to my server using FTP functions in PHP. It all works perfectly when I run the script from my pc, but once it s on the server it can t find the file. ftp_put(): error opening C:Documents and SettingsAlexanderDesktop r1_1.jpg I guess it happens cos it tries to find it on the server not on my PC. The question is, how can I point it to my pc, not server. Or how can I make it copy files from my local computer to the server while running from the server!
View Replies !
View Related
CURL To Pull Data From A Site
I've been using php and cURL to pull data from a site, and things worked just fine. however, when i used the same script to access a different site, not data is being returned. however, i can go to the url of the site being used and there is clearly html there which should theoretically be scraped. any idea why it is not being gathered and how can i fix this?
View Replies !
View Related
Pull Data From A Second Sql Query Using A Where Clause
I am trying to pull data from a second sql query using a where clause = two fields from the first query. I am trying to gather from the second query, any data where we have a match from either of the two in the where clause. sql=my select 1,2 from t1 while $row { $one=$row[1]; $two=$row[2]; sql=select 1,2 from t2 WHERE 1 = '$one' or 2 = '$two' group by 1,2 while $row2 { //trying to output all rows that either 1 or 2 from t2 match 1 or 2 from t1. so all grouped results from 1 display all unique results in 2all grouped results from 2 dispaly all unique results in 1 where either 1 from t1 = 1 from t2 or 2 from t1= 2 from t2.
View Replies !
View Related
Resource Id #3 - Pull Out Data From My Table
I am trying to pull out data from my table. I know there are some records there, but when I tried the following code: $query = "SELECT * FROM logpage WHERE user = '$user_name'"; $result = mysql_query($query); echo "result is ", $result, "<br>"; I got "result is Resource id #3".
View Replies !
View Related
Script To Pull Data From SQL Table
I'm running a php-enabled dedicated server. All my sites on said server incorporate simple php scripts (includes, month/date, etc.) and that's the extent of my php knowledge. Some of my sites have SQL databases which I administer via phpmyadmin, but I've been unable to track down a simple php script to: * open the database * refer to a specific table * extract data from the table * display the data on a website Can anyone point me to an online doc or provide a simple script to follow which I can customize for my purposes?
View Replies !
View Related
Pull Data From MySQL Database
I'm running a PHP script called phpOnDirectory on thsi website i'm creating so that people can have their companies listed in our directory. Currently, the script displayes the directory in a left-hand column, and the results in the center column. When you access a category, the script displays the number of listings withing that category in parenthesis next to the title. What my client wants is to take that out(easy enough) and have the totals listed next to the categories on the left. Code:
View Replies !
View Related
Pull Data From A Table Using A While Loop
I noticed that when I pull data from a table using a while loop I am always missing the first entry in the set. To solve it for now I have placed a Dummy entry into the database, which works fine for simple lists but when the query begins to ask for any number of combinations of fields it seems like that is not a suitable fix.
View Replies !
View Related
Date Function On Local Server To Remote Host
This little combo was giving me Sunday, April 30 on my local server and Thursday, April 1 on my remote host, and I can't for the life of me figure out why. I could swear it used to work. PHP Code: $today = gmmktime(0,0,0,date('m,d,Y',gmmktime())); echo gmdate('l, F j', $today); (The first function gives me a "midnight" time stamp, so all dates put into the db, and compared to it, are consistent). When I rewrote it thus, it worked fine on both hosts: PHP Code: $m = date('m',gmmktime()); $d = date('d',gmmktime()); $y = date('Y',gmmktime()); $today = gmmktime(0,0,0,$m,$d,$y); Any idea what the heck is going on?
View Replies !
View Related
Using A Loop To Pull Data From Mysql Recordset
This has set me back a couple of days now and I could really use some help or at least a shove in the right direction. What I'm trying to do is list reviews in a database on a page, by artist (byartist.php). The first step is pulling each artist and listing them alphabetically. If the artist has more than one album reviewed, they should still only show up once, so I need to check each row of the recordset, and check the artistname against a variable or something, and if it exists, to just skip it and move on to the next row. Then I need to list the albums reviewed under each respective artists name and use them as links with url parameters to the respective review pages. I've got the recordset down per some advice from another newsgroup, and I'm fairly certain its correct for what I need to do. <?php require_once('conntest.php'); ?> <?php mysql_select_db($database_test, $test); $query_byartist = "select artists.artistid, artists.artistname, areviews.albumid, areviews.atitle from artists join areviews on artists.artistid = areviews.artistid"; $byartist = mysql_query($query_byartist, $test) or die(mysql_error()); $row_byartist = mysql_fetch_assoc($byartist); $totalRows_byartist = mysql_num_rows($byartist); ?> The php example I was given for pulling the results was kind of half-effort and not enough for me to really see what was going on, understand it and build upon it. I'm (obviously) just starting out with php/mysql and I'm pretty good at building upon something in front of me and figuring it out, just need a little help because I've tried it over and over and to no avail, I wind up with syntax errors. Sorry for the wordy post, I didnt want to skimp. Thanks for any help or advice or any points in the right direction. I've got about 3 days of progress to catch up on
View Replies !
View Related
Using The Mysql_fetch_array Function To Pull Data In As An Array.
Im currently pulling in a load of data from my sql table. I found that using the mysql_fetch_array function was the way to pull it all in as an array. The only problem? I cant manage to get it to store a value into another name eg $ip = $row['ip'] and count how many instance's are contained within it. I need to do similar things to the 'url' and the 'time' but as I cant access the data there isnt much I can do!
View Replies !
View Related
How To Pull 1 Line Of Data From A File? NO MYSQL
I have this file that has 2 lines in it. Heres how the files looks. file: fbddata.lbn line1:uncle1234562 line2: As you can see, on line 2 there is actually no data but the file still seems to have a 2 lines. But when I pull the info from the file using the "include" or "require" command it just pulls the 1st line of data. BUT..when I try to use the "include" or "require" php commend within a HTML link code like this.... <a herf="www.mysite.com/Lavishphpfreak/<?php include("fbddata.lbn" ?>/ilovephp.php>LINK[/url] it gives me a link that this... http://www.mysite.com/Lavishphpfreak/uncle1234562 /ilovephp.php now did you notice the code that was added to the link. I have figured out that its doing this because of the blank line 2 thats in the fbddata.lbn im trying to pull the data from. Of course the easy way to fix this would be to just go into the file and delete the blank like 2 but i can't do this because i dont have permission to edit the file. Its created using "root". So does anyone know of a php code that will just pull the 1st line of data from within a file. I can't use mysql cause this is NOT in a database..and plus I haven't advanced to databases yet.
View Replies !
View Related
Mysql_Fetch_array(); Pull An Array Of Data From Mysql
im trying to pull an array of data from mysql. this is the code im using. PHP Code: //the sql syntax below pulls the last 7 records from the database $sql     =    "SELECT * FROM db_news ORDER BY 'id' DESC LIMIT 7"; $query    =    mysql_query($sql) or die('MYSQL QUERY ERROR' . mysql_error()); while($row = mysql_fetch_array($query)) { echo $row['id']; } the code above outputs 'id's' 7 to 1 as 7654321. what i want to do is explode the 7654321 into an array so i can call them any where on the page. and not just while the while loop is running, complicated ? what im trying to do is grab the latest 7 news reports from mysql and then display them in certain places on a webpage.
View Replies !
View Related
Mysql_fetch_array Way To Pull Out All The Data, Store It In An Array
I have a webpage which runs repetitive queries agaist a database in order to extract one item at a time and then put the items in an HTML table. The reason for this is formatting, plus the page hits 4 databases. Instead of running multiple queries pulling one item at a time...is there a way to pull out all the data, store it in an array, and then pull individual items from the array with php as I want to insert them in the table? So, example is Code:
View Replies !
View Related
Pull Data From Database And Show It In Forms
I have created an online survey form for my boss about one of his course. He needs his students to do the evaluation for a topic when he finishes each topic. For example, when he finished topic 1, he told students to evaluate topic 1. Two weeks later, when he finished topic 2, he asked the students to evaluate topic 2, so on. I created the survey form with radio buttons and I would like each student can keep his own record for the previous topic. For example, when it is time to do the evaluation for topic 2, when he opens the survey form, he can see his reply for topic 1. Code:
View Replies !
View Related
Main Page Database Seems To Not Pull Any Data At All.
I have a page that has a connection to a database. I also call a function that makes a connection to a new database, outputs some data and closes. The problem: When I call the function, the main page database seems to not pull any data at all. Im using all new database connection variables and closing them. Still the main connection stops working.
View Replies !
View Related
Pull Data From Mysql Db And Break This Into An Array
I am trying to pull data from mysql db and break this into an array that I can then pull certain bits of data from, hope this makes sence to someone. PHP Code: $dbh=mysql_connect("localhost", "$username", "$code") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("$database"); $query = mysql_query("SELECT * FROM `allflights` WHERE id='$callsign' ORDER BY date DESC LIMIT 5") or die (mysql_error()); I would like to place like data for say these five items so I can have them stored in arrays and then select the different data as needed from each one.
View Replies !
View Related
Pagination Query - Pull The Data From The Database
I'm trying to paginate some query results but when I click on "next" to go to the next set of results, the query fails. Here's what I'm using to pull the data from the database. PHP Code: $sql="SELECT id, student_id, first_name, last_name, address, city, state, zip, DOB, gender, grade, aka FROM student WHERE last_name LIKE '".$_GET['last']."%' and current_student='yes' ORDER BY last_name LIMIT $offset, $rowsPerPage";     $conn = db_security_connect();     $result = mysql_query($sql,$conn);     $query   = "SELECT COUNT(*) AS numrows FROM student WHERE last_name LIKE '".$_GET['last']."%' and current_student='yes'";
View Replies !
View Related
Pull Data From The Database And Generate A Normal Text File
I have a database that is correctly storing characters like the trademark symbol, copyright,ect. I then pull data from the database and generate a normal text file from it. I do not do anything other then echoing out the direct database info into a variable and then building the file from the variable. When I open the text file, ALL my trademarks, copyright, apostrophies, anything other then alphanumeric becomes question marks. "?" I have no idea how to fix this. Can anyone lead me in the right direction on what needs to be done to fix this. The database charset is 8859-1 I beleive, and my html pages are also 8859-1 and also render the data wrong, same "?"
View Replies !
View Related
Mail() [function.mail]: SMTP Server Response: 550 Not Local Host Gmail.com
I do a mail() and get: Warning: mail() [function.mail]: SMTP server response: 550 not local host gmail.com, not a gateway in C:xamppxampphtdocs estsitemail.php on line 7 <?php ini_set("SMTP","rlwatkins.com"); ini_set("sendmail_from","hunter@rlwatkins.com"); mail("huntercjcarroll@gmail.com","hello me","spamtastic","From: hunter@rlwatkins.com"); ?> what is wrong with this, how do i set it so that i can send to something other than localhost?
View Replies !
View Related
DATA VALIDATION ON SERVER!
What I have done is that the user entered info is validated in comparision to that stored in the database.(may be username or password etc).When the server sees that some of the entered data are incorrect it displays some error messages and maintains the user entered data in the textfields as well. But what the problem here is that the user entered data after the "tab" or "whitespace" is trimmed automatically. For ex: Good Boy will be maintained as Good only.
View Replies !
View Related
Displaying Data From MS SQL Server
I have a db set up in MS SQL Server. I want to store webpage content so I set the field to text(7000) The data is displaying in webpage correctly from the db, but in View Source the code is messy. I just want <p> tags to be used but the below is added in... <p><span lang="EN-US" style="FONT-FAMILY: Arial; mso-ansi-language: EN-US">text content here</span></p> Any ideas how to prevent this extra code?
View Replies !
View Related
MS SQL Server Meta Data Question
php's native mssql api in order to read the meta data from an entire DBMS ... I have sql server 2000 up and running and using the provided browsing tools poked around and found that the databases in the system were listed under a database named "master" in a table named "sysdatabases" ... there is a "syscolumns" table there too but it looks like i need specific info about the architecture of sql server's inner workings to use it. the native php support for sql server doesn't have meta data functions like are provided for things like mysql and odbc. I can't use adodb or pear for alot of reasons ... databases -- I have done this one in a round about way tables in those databases attributes in those tables and attribute types I need to do this for Oracle too but I think the native support for Oracle is better and the tools built in ... I think Oracle supports something they call show commands that just do what I want.
View Replies !
View Related
Identify Server That Posted Data.
I am looking into the security aspects of a site, and would like to know if there is any way to identify the source of the data that is posted to the php page responsible for processing the data. in other words I only wantt he php code to process the data if the data was posted from a form hosted on my server.
View Replies !
View Related
|
TRACKER
