10,946 Topics
 | |
| | [CODE]################################### #Email Extractor v1.0 ################################### %3C?php ############################################################### # Email Extractor v1.0 ############################################################### # Created By Garibay ############################################################### $the_url = isset($_REQUEST['url']) ? htmlspecialchars($_REQUEST['url']) : ''; ?%3E %3C?php if (isset($_REQUEST['url']) && !empty($_REQUEST['url'])) { // fetch data from specified url $text = file_get_contents($_REQUEST['url']); } elseif (isset($_REQUEST['text']) && !empty($_REQUEST['text'])) { // get text from … |
| | Hi, Assume, I have table which consists of 5 values, say C:/Testing/test1/ C:/Testing/test1/test2/ C:/Testing/1/ C:/Testing/ C:/1/ I want to query the database table to get the values starts from 'C:/Testing/' and '/' as a escape character. ie, I want to get only two things, C:/Testing/test1/ C:/Testing/1/ Both starts with 'C:/Testing/' … |
 | how to do this? like ive seen some HARSH codes with things i dont understand in themm like information.schema and datetime whats the simple way to add a column to a table if it doesnt exist? and what the heck how to not add it if it already exists ? … |
| | OK! This will probably reveal my IQ , but here goes. I am new to PHP and MySQL--I am learning from a ton of books--and I am struggling with many-to-many relationships. All of the books make a lot of assumptions. I get the concept just not the mechanics. Say I … |
| | Hello guys I am a freelance web designer. I work with the following technologies..... PHP, MySQL, ASP, ASP.NET, SQL Server 2000. Doing research in Web Technologies... most of it related to security. Hoping to give and receive knowledge from all of you. Take Care. Regards Praveen Balla |
 | I have Visual Basic 8.0 and Use Mysql 5.0 Database Table Test: Field type ID Integer (PRIMARY KEY) Name Char(10) Adress Char(15) City Char(15) ID Name Adress City 1 Andre Street 1 New York 2 John Street 2 Amsterdam 3. Joyce Street 3 Londen I have create a index on … |
| | The title is pretty self-explanatory. I'm working on a PHP engine, and I'm trying to implement a SQL query generator. The hardest part of this will be designing the system for using the SELECT command. Are there any practices that I should try to follow when designing this, or any …  |
| | Hello, So lately, I've been coming across this issue of mine and can't seem to find a solid way around this problem. My problem is due to the fact I'm using MYSQL C connector library. And, Attempting to gain all the Row's from my database and store them in a … |
| | i am using the following JQuery function to successfully POST data to the user_submit.php file, its just that the php file is unable to receive the data. [CODE] $(function() { $("#submit_js").click(function() { $.post("user_submit.php", { comment: $("#comment").val() }); }); });[/CODE] upon finishing the Firebug consoloe shows this: [CODE]<html> <body> Your vote … |
| | Hi, If you are a Joomla user and forgot your Administrator password then don’t think of re-installation. There is an easy way to change your Administrator Password. To get your password recovered you will need following things. Access to PhpAdmin If you are Cpanel user you will find the link … |
| | please help me with some codes to update about thousand record in the database.i.e. changing all one to two and moving all threes to a different table in the database. 2.Also a code to select all in a listbox |
| | Hey guys I'm having a bit of a problem with a database application i'm trying to design for organizing information from a non profit childrens hockey organization i'm with. Right now my problem is with 3 tables. I've got the application querying a list of games. And now i need … |
| | i have 2 database & need some code to solve this problem. table 1 (food_place) : fp_id | fp_name 1 | McD 2 | Burger King 3 | Pizza Hut -------------------------------------------- table 2 (promo) : p_id | p_name | p_pid 1 | Disc.10% | 1 2 | Free f. fries … |
| | How Many Databases are there? I know some of the databases, but i want to know many more databases, & what are they? |
| | CREATE TABLE message ( id bigint(20) DEFAULT '0' NOT NULL, inReplyToID bigint(20) DEFAULT '0' NOT NULL, createMonth int(11) DEFAULT '0' NOT NULL, createDay int(11) DEFAULT '0' NOT NULL, createYear int(11) DEFAULT '0' NOT NULL, boardID bigint(20) DEFAULT '0' NOT NULL, subject varchar(80) DEFAULT '' NOT NULL, authorEmail varchar(80) DEFAULT '' … |
 | Hello all, Not sure if this is the proper forum for this but first: I am using Visual Studio 2008 and MySQL Server Version 5.1.42 and Client Version 5.1.11 programming language C# issue: save button from windows form for record editing using databindings and textboxes... is there a way to … |
| | Hello guys. I am looking for a report/statistics generator for mysql. Basically i want a tool that can connect to a sql database and use columns in different tables to generate graphs, charts etc. It would be good if it has support for timestamps. Is there a tool like this … |
| | I have a mysql db with 3 tables (this is supposed to be a db for a dvd rental store) 1) MOVIE PK MovieID Title Type Year Producer 2) CLIENT PK ClientID Name Address City 3) RENT PK RentID Date FK MovieID FK ClientID Cost The exercise told us we … |
| | i write query like select * from pm_task_user_work LEFT JOIN pm_task_allotment ON pm_task_allotment.task_allotment_id=pm_task_user_work.task_allotment_id where pm_task_user_work.project_id='19' and (Select str_to_date(pm_task_user_work.task_user_work_link_time,'%Y-%m-%d') as MyDate from pm_task_user_work) BETWEEN '2009-12-15' AND '2009-12-15' order by pm_task_user_work.project_module_id,pm_task_user_work.task_user_work_link_follow It gives me Subquery returns more than 1 row ------------ 2> SELECT pm_task_user_work . * , str_to_date( pm_task_user_work.task_user_work_link_time, '%Y-%m-%d' ) AS … |
| | Hello, I am trying to compare a MySQL date to a user entered date in Perl. Basically, [code] while ( my @data = $sth->fetchrow_array() ) { print($data->{'day'}); if($data->{'day'} eq $userdate) { $conflict = 1; break; } } [/code] Being Perl code, I wasn't sure if posting in databases was inappropriate. … |
| | 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 … |
 | 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 … |
| | 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% … |
| | 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 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: |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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 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) …  |
| | 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!!! |
| | I am using this insert statement - [code=sql] INSERT INTO `crispwer_unipro`.`users` ( `user_id` , `user_name` , `password` , `email` , `activationkey` , `status` , `fname` , `lname` , `dob` , `gender` , `course_id` , `college_id` , `city_id` ) VALUES ( '2', 'k', 'k', 'kk@gmail.com', '', 'activated', 'keval', 'kothari', '2009-12-27', 'M', … |
| | Hello all! :) I dont know if this is the right forum..Here's part of my code: im using php to generate a wml page. It works fine. I want to populate a checkbox using data from mysql db. rand_keys() : store the ids in random order $row(): stores the ids … |
| | How do i start mysqlserver with option of --log-bin using phpmyadmin. Where do i set mysql server startup options in phpmyadmin. |
The End.