18,960 Topics
I have two servers and one of them have mysql db and one doesnt so is it possible to use mysql db in my other server while hosting my website on another. also if there is how would you do it with php.
[code=php] <?php include 'config.php'; include 'opendb.php'; $result = mysql_query("SELECT * FROM 888db ORDER BY id") or die(mysql_error()); echo "<table border='0'>"; echo "<div id='bodyframe'>"; // keeps getting the next row until there are no more to get while($row = mysql_fetch_array( $result )) { // Print out the contents of each row …
this is not a web design question, i'm actually using it in vb.net but they don't have a database forum in the software development section. what i am doing: i have two tables. customer and customer_phones my visual basic program has a search for customer option, which returns the customers …
Using following HTML Code please show me how to write PHP code to accept and delete the incoming data entered through the form below. from the following MySQL database and table. [B]Database[/B] = hrms [B]Table[/B] = Student [B]Fields[/B] = StdNo(Number), Name(String), Address(String), Contact No(String) [CODE] Student No<Input type='text' name='txtStdNo' /> …
Hi, I'm new member I saw this site and it is really interesting , I have new project I worked on it with html and php it is a web site for songs I built the whole site and now start programming the database for singers and songs what I …
Hi All Friends, I Have a Problem in My PHP Code that The $tree Array not Store Third Value(Parent ID). my Code is Display Below. The Below code Show Parent/Child Tree from MySQL Database.: dhtmlgoodies_tree.class.php [CODE]<?php /* This is one of the free scripts from www.dhtmlgoodies.com You are free to …
Well having thought I'd got over all the hurdles of this damn database with my previous post, it seems I hadn't quite suffered enough, and have been thrown another challenge. I have a piece of code which fills a form in with the current details of a car record. Form …
Hey all you AJAX masters, Here comes a long post but I know someone out there knows what's wrong here.... I have no idea why the following script doesn't work but I think I have isolated the problem. I have an 'order form' page (that calls this script) that generates …
Hi, I need some help searching for extended ascii characters. I keep track of scores for a game along with the user's name. The user can have a crazy name like "»LPk«FËNÎX§" but when he searches for himself it isnt found so he has to search for something like lpk% …
i have two values in a table and instead of returning the values it returns the word "array" twice. [code] $mysql = new sqlConnection(); $query = "SELECT DISTINCT status FROM status ORDER BY status"; $result = mysql_query($query) or die('Error, query failed'); while ($row = mysql_fetch_array($result)) { echo "$row<br>"; } $mysql->close(); …
Dear Developers I have following codes on lostfocus of textbox1.text to search values. It works fine but how to navigate database. I mean what codes should I use for Next Record and Previous Record Buttons. My SQL database name is accounts and table name is employees Please help str = …
Hi, How do i prevent printing "Warning" bit of connection error? I only want see my error message on screen. Note: I deliberetly enter wrong Host IP to see the message thou. [code] Warning: mysql_connect() [function.mysql-connect]: Host '127.0.0.123123' is not allowed to connect to this MySQL server in C:\apache\login\database.php on …
ok so my development folder is in xammp htdocs (php codes) i am trying to insert an image to a table and when i display it on the php pages, it does not show why is this?? i used the absolute and relative path both. the images i need to …
im looking to convert this code using prepared statments if possible but am open to suggestions [CODE=php] function list_owner_notes(){ $id = $this->id; $sql = "SELECT nid, title FROM notes JOIN hubs ON notes.hub_url=hubs.hub_url WHERE owner = '$id'"; $result = mysql_query($sql) or die(mysql_error()); $notes = array(); / for($i=0; $row = mysql_fetch_array($result, …
Hi I have a bunch of .pdf's full of music notes in a library and I want these notes to be [I]search-able[/I] from my site using three values (that, would be very nice if can be [I]combined[/I] using AND and OR operators): 1) author; 2) title 3) keyword. - How …
Hi guys, I'm back for some help. Spent days googling for the answer... cant do it anymore. Could somebody please tell me how to simulate Joomla readmore function. What I mean is: I have a mysql database with news articles. Each article is stored in the 'news' table in the …
Hi everybody I have been using mysqldump utility to dump the contents of database to a file. Everything is ok but i want to eliminate the "USE `db_name`;" statement that appears in mysqldump. Is it possible to do that. Please help:sweat:
I posted earlier on this site for help on where to set a command when a user session timesout. I posted this in the global.asax file: [code]Imports System.Web Imports System.Web.SessionState Imports System.Diagnostics Public Class Global Inherits System.Web.HttpApplication Sub Application_Start(ByVal Sender As Object, ByVal E As EventArgs) Application("CurrentUsers") = 0 Application("TotalSessions") …
Hi! i want to send 10,000 email to my users i have shared web hosting. i think i have only this solution. i want a simple php coding. if some one visit at my site an email automatically send from database list. i have a mysql table -------------------------------- | ID …
Hi I'm doing a project which requires a registration/login page. I have created both registration and login html pages and have done the validation servlet for the login page. I've also attempted the validation servlet for the registration page, but this is where I am struggling because I can't get …
This is the code for my TV guide website (stored on localhost)'s articles in PHP: [CODE] <?php //connect to mysql //change user and password to your mySQL name and password mysql_connect("localhost","root","PASSWORDREMOVED"); //select which database you want to edit mysql_select_db("tvguide"); //select the table $result = mysql_query("select * from epdata"); //grab all …
I am trying to get my date that people enter into a form from mm/dd/yyyy to input it into the database. I can't seem to get this to work, I guess I only know enough to hang myself, what would someone use to get this to function properly? I've been …
Here is an extracted code from my php file. Basically what i want to do now is put the results fetched while in a WHILE loop into an array, lets call it $array99. HOWW??? i am totally stumped here. Just so you can understand the logic of the program(its irrelevant …
Hi, I am using MySQL Version 5.0.45. I am getting time out error while trying to access large data. I am performing 2 operations: a) I am loading the data file into the database b) I am retrieving the data from the database. 1) Loading the data file into the …
hi helpers, i wanted to develop a discussion forum in java,...downloaded jforum 2.1.8 War file,...imported to eclipse,...what else should i do to run the project?.....sadly i didnt find 'how to' any tutorial in net :( i've never worked with any open src projects b4,...how to configure mysql db for it?...where …
Just need to know whether or not mysql server supports multiple strings of databases. Will the performance be hindered ? My company has a server that holds a few large databases for now (20GB and larger). In the near future more and more databases will be added. Adding more databases …
Hello, I want to use CreateUserWizard. Here i want to add some additional fields in that wizard. Also i want my own validation (even for password format) in this wizard. Also i want this to be stored in my sql database, instead of ASP.NET Website Configuration default website (as it …
hey, im wondering what is the best way to go about creating queries... my program.. i am creating a staff search program, i have craeted my databse and have included queries in access. but imnot sure how to call them in vb.net wondering if anyone can help me on that... …
I'm working on this since 3 days, grabbing the web looking after ideas. Hope someone faced this problem and solved it. All is about a picture site Here how it's doing: There are about 15 items with different options offered to the customers. A combination of size, number of figures, …
Hi Everyone, I would appreciate it if someone could have a look at this short mysqli script and tell my why I am getting this parse error: Parse error: syntax error, unexpected T_VARIABLE in /home/james230/public_html/xampp/htdocs/lesson1/login.php on line 10 I had this set up as mysql and it works perfectly, but …
Hey. I'm new to php and I have been looking everywhere for info on how to take information from my sql table field and put it into a html form list.
Hi, Why not uploaded the data into db? Do not show any error. [CODE] string City = "Berlin"; string MyConString = "SERVER=localhost;" + "DATABASE=test;" + "UID=root;" + "PASSWORD=;"; MySqlConnection connection = new MySqlConnection(MyConString); MySqlCommand command = connection.CreateCommand(); command.CommandText = "insert into city(city) VALUES (@City)"; command.Parameters.Add(new MySqlParameter("@City", MySqlDbType.VarChar, 40)).Value = City; …
I get these errors in a script of mine: [CODE]Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\www\vhosts\myradiostation\test.php on line 13[/CODE] and my original page (included in another page): [CODE] <?php //connect to mysql //change user and password to your mySQL name and password mysql_connect("localhost","root","PASSWORDREMOVED"); //select …
Hi everyone, I am trying to figure out the way to check if the file ,that exists on a filestore, is also present in the database. Ultimately i want to flag up the files that exist in the database but are not on the filestore and vice versa. I have …
Right now, I have a PHP script which - ideally - selects "posts" from a table, based whether or not the the time in the post is greater than the current time. [code]if(isset($_POST['id'])) { $id=addslashes($_POST['id']); $time=date("h:i:s"); $sql=mysql_query("SELECT * FROM public_wis WHERE mig_id='$id' AND time >= '$time'"); if(mysql_num_rows($sql)!=0) { while($rows=mysql_fetch_array($sql)) { …
Hi, I was wondering if it was possible to update the value of a mySQL cell by a method similar to using += in php code. For example, I'd like to do: [code] $sql = "UPDATE inventory WHERE userID = '$_SESSION[userID]' SET money+='$ssmoney'"; [/code] I know I can instead run …
Hi There I'm a newcomer to php trying to develop a basic photo album. I have created a simple template in htm, and am trying to use php to show 15 thumbnails per page. However, I am experiencing the error message: "Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL …
How to send SMS on mobile from website for user account registrration using PHP, Mysql ? How to send SMS that contain username & auto-generated password? Plerase, anybody ?......, it's urgent.............. THANK YOU in advance
Hi used the below coding for enrypting and decrypting a text. But with this i dont know how to save to a database, when i tried i am getting many errors. How to do this? [CODE]Private Sub cmdEncrypt_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click ' Encrypt MyText …
For some reason this is killing me, I am trying to update the field available to '-1' and don to '0' when the user submits the correct string into the input box, the thing I cant work out is why available wont update but don will the code is below …
I have a small script that connects using ssh and opens a tunnel on port 3306. It works in the ipython interpreter if i type it in manually. However when I try to run the script from the interpreter or command line I get the error message "Can't connect to …
I've got my website, [url="http://www.bangbangt-shirts.com/"]Bang Bang T-shirts[/url], on a Windows Server 2003 dedicated machine. In the last few weeks, it's crashed a few times and I think it does this when it performs an auto update and tries to restart. When they support staff from the hosting company manually reboot …
First off I apologize for being a newbie to MySQL but one must learn somewhere... I am attempting to create a stored procedure that take input (primary key) and finds a field for that record and output to a variable... my code so far: [CODE]CREATE PROCEDURE sp_dealer_name( IN dealerID CHAR, …
I've been trying to create a database-driven site, am new to this, have looked it up on Google and tried for myself, but need a bit of help. [CODE] <?php // Connects to your Database mysql_connect("localhost", "root", "PASSWORDREMOVED") or die(mysql_error()); mysql_select_db("epguides") or die(mysql_error()); $data = mysql_query("SELECT * FROM epguides) or …
I have 2 tables 1st INVHD 2nd INVDT In INVHD I have following fields InvNo, InvDate,CustCd, CustName, TotalDisc (Discount on total Invoice), GrandTotal In INVDT I have following fields InvNo, RowNo,ItemCode, Qty, Rate, BaseVal, etc…. Now I need a query to be generated for The customer CustCd, CustName, Sum(totalDisc), Sum(GrandTotal) …
Hi, i am a beginner in using ASP.NET. I have this problem. Whenever i select the advanced options in configuring the sqldatasource, the Advanced SQL Generation Options are all greyed out/disabled. Now, i found out that the cause of this is because the table that i am trying to access …
Hai, I had a database with tables id,name,email. ( Total about 25 thousand of rows in that database ) . I want to do mails to these email ids daily. Now in this condition so much email ids are repeating bcoz I converted a excel file to musql. It is …
Hello, I have been checking for data integration / transfer programs able to help with Mysql. I have had some advice from some people but have not found the right software yet. The main feature would be to be able to migrate important quantities of contacts and data every day. …
Hi people, Do you have any good sites for C++ MySQL.Especially how the 'query' part works in the C++. Thanks a lot!!!
The End.