Mysql Interface Generator
I wanted to know if there are any program that generates a webpage with the forms to insert data into the db.
Example: I have a table with {id, url, desc}
The program must generate a page with text fields to enter this information.
View Complete Forum Thread with Replies
Related Forum Messages:
Scribe Report Generator For MySQL And Other RDBMS
We are looking for beta-testers for our new product - Scribe Report Generator. At this moment, Scribe supports 6 relational databases, including Oracle, MS SQL Server 2000, and Sybase. Very briefly: Scribe is written in Java, is based on visual programming and can be extended by adding user-written Java classes; it comes with the API library to let other Java-based apps run Scribe reports programmatically. The details are on our website: www.gestalt.com/Scribe (temporary location). User: guest Password: star We offer a free license to everyone who provides us with a feedback on bugs, inconsistencies, or constructive criticism that helps us refine Scribe.
View Replies !
Mysql GUI Interface
is there any GUI for mysql is availabe ??? just like SQL server or ms access .. not even like apart from phpmyadmin but like windows on which we can make database , tables , reocords .... etc .. i guess micro olap have this .. but its not free ..
View Replies !
Mysql On Linux-gui Interface
Is there a GUI interface that is easy to install to manage MySQL on linux? I'm trying add a user account and password to the db server but I'm not having any luck from the command prompt.I'm trying to setup the nexus discussion software.
View Replies !
Local Interface To MySQL
I need to harvest data from MySQL tables. My experience is with MSSQL and Enterprise Manager. I also connect to MSSQL with Access and ODBC. I don't need to manage anything. I just need the data. What kind of interface can I use to query and save data locally? I don't see any MySQL drivers available when I try to setup an ODBC from my desktop. Can I download one somewhere?
View Replies !
MySQL Interface Required
I hope this question is appropriate for this group. My server provides a MySQL database. Do I need a third-party interface to add tables and records to it, or is their another way?
View Replies !
MySQL C++ Interface Installation
After I downloaded MySQL C++ package & installed it, I can't compile any sources. System notes "undefine reference 'function' ", is anyone familar with gcc & MySQL C++ development package ?
View Replies !
User Interface With MySQL
is there product that provides a developable non-web user interface in the way that Access has one for its database? I've seen many that customize database routines, but what we want to do is create a user interface that includes logic without having to go through Php, Cfm, Net, or any of the web-based technologies.
View Replies !
Question Regarding MySQL Interface Options And MySQL Vs MS Access
First, there are many applications available for interacting with MySQL. One of the things that frustrated me at first was the CLI. I know that it's the foundation and understanding syntax is critical to making it all work in the end, but when dealing with large datasets, I feel that a GUI makes life easier at times. So, I started out with phpMyAdmin, seems to be 'the' geek-preferred application. I also ran into a few shareware ones here and there as well as Navicat, and I recently learned that there are 2 apps from MySQL.com for administrating the DB and creating queries. In your experience, what seems to be the best MySQL interface application? At the moment I couldn't say *exactly* what I'm looking for, but more-or-less something that will ease the headache of creating queries and managing users, tables, etc. Question #2: I have been hired to be a Web Developer, Network Admin, and Database Administrator all-in-one. We have are a retail company selling peuter goods and have a product line-up of about 100 items. The President wants a robust database to deal with everything. Right now we use MS Excel for our needs. He says it's becoming cumbersome and wants to move on. I suggested MS Access because that's exactly what it's built for, companies that have been running in Excel and want more robust control over what they're doing. But the president keeps hearing this 'MySQL' buzzword and wants a MySQL database. Fine with me, I just know Access better, that's all. I've been cramming PHP & MySQL down as fast as I can and am starting to feel more familiar with both technologies. At the moment, I feel MySQL to be more of a headache (my fault I'm sure, I just don't know it yet) But For Example: To properly normalize a DB, I sometimes have to break a table into 3 tables. The first and second are no problem, but the third 'association' table is annoying (at least doing it CLI or phpMyAdmin). See, Access, you just make 2 tables and graphically set associations very easily. So, from what you know of MySQL, do you think it would be still superior to Access seeing as we want to integrate it into osCommerce eventually and possibly some of their user contributions?
View Replies !
SQL Generator
I order data in an excel sheet, export via an old fashioned sql generator I have, and then import to mysql DB I am looking for any good (even paid) SQL generator. Know any? I found many via hostscripts.com and download.com but none of them worked as expected, or was easy to manage for me. I can't remember all the ones I tried, but I really tried many. I would appreciate it if you would kindly share your experience on this.
View Replies !
PHP Generator On Mac
some software for mac that can generate php scripts for managing mysql databases? For windows there is the great phpmaker, high configurable, and can generate a customized web application for update the database, but there isn't any mac version.
View Replies !
Random Password Generator?
I have 3 tables as follows: Lesson: lesson_id | lesson_name | -------------------------| 1 | Lesson One | 2 | Lesson Two | 3 | Lesson Three | 4 | Lesson Four | -------------------------- student_lesson: lesson_id | student_id | ----------------------| 1 | 44 | 1 | 45 | 1 | 46 | 1 | 47 | ----------------------| class_lesson: lesson_id | class_id | -------------------| 1 | 901 | 2 | 902 | 3 | 903 | 4 | 904 | -------------------| The following query: SELECT crs_lesson.lesson_id, lesson_name, count(crs_student_lesson.student_id) AS student_count, count(crs_class_lesson.class_id) AS class_count FROM crs_lesson LEFT JOIN crs_student_lesson USING (lesson_id) LEFT JOIN crs_class_lesson USING (lesson_id) GROUP BY crs_lesson.lesson_id Produces the following result: lesson_id | lesson_name | student_count | class_count | ------------------------------------------------------| 1 | Lesson One | 4 | 4 | 2 | Lesson Two | 0 | 0 | 3 | Lesson Three | 0 | 0 | 4 | Lesson Four | 0 | 0 | ------------------------------------------------------| This shows that the second count is always set to the same value as the first count even though the values should be different.
View Replies !
Automatic Form Generator
Does anyone know of a free software package that would query the schema of a MySQL table and automatically (or interactively) generate a PHP web form for querying/inserting/updating rows of the table? I've done some googling for this and the closest free thing I found was something called Xdobry that was too confusing and badly translated from German.
View Replies !
XA Interface
In 5.0 Manual,I see XA Interface( use SQL[XA START,...],Connector/J ). But, 1. I want know XA Interface in C API. ( using xa_switch_t like other DB ( oracle, infomix, .. ) )I can't find this in Manual. 2. If MySql is not support this, does Mysql have the plan?
View Replies !
XML Interface
Does anyone know of any project that would provide an XML interface to a database? I would like to create an XML document describing what I want to do, send it to a server and get some XML results back. Has anyone heard of anything like this?
View Replies !
Interface
MySQL is just the language that the database is programmed in, in a nutshell is that right? If so, it's not like Microsoft Access where you can create a user interface so the user can input data and apply queries to data etc. These are my assumptions, so my question is: Is there an open source application that applies a user interface to a MySQL database so a user can do these things?
View Replies !
Visual Interface
i tried the gui tools in mySQL.com but Im having some trouble instaling them, eventually ill be successful but I heard there are simpler packages, I just want to see the ER diagram of my databases, for the rest I can handle.
View Replies !
End User Interface
My goal is to set up a database to track our inspection data at our company. Currently, we are using Excel spreadsheets to make inspection reports. I would like to be able to get this information into a database so that a technician can set up the inspection plan before the inspector gets the part (the inspection plan would include the Customer Name, Part No., Revision, Items to inspect, etc.) Then when the inspector receives the part, they can pull up the inspection plan and enter the dimensional values obtained for each attribute on say six or ten parts and print an inspection report. Then this data can be sorted and viewed in different ways. We have three Windows 95 computers and three Windows 98 computers we are currently using on an ethernet network. I am thinking of using MySql, Apache and PHP to set this up. Would there be a simpler way to create an end user interface to MySql other than using PHP and Apache?
View Replies !
MS-Windows Front End Interface
Is there an MS-Windows front end interface for mySQL ? I'm thinking of an MS-Access sort of approach for basic database configuration and maintenance. Maybe there's a back door way to ODBC myself from MS-access to mysql on a Windows system ? Does Mysql have an ODBC front end I can get in through ? Any pointers to some directions ? I plan to use perl/my-sql for web work. But, it seems like a _lot_ of work to build the databases and populate them via mysql commands. I'd like to be able to work them _locally_ through a basic data maintenance program and then move it to the (web) server when ready.
View Replies !
Graphical Interface Hangs
In the older version of mysql, when I pressed browse, I could see the content of the table. If I ran a query, such as select * from table, it would scroll out the result. Now, with the newer version, all it does is hang. Is there some setting I'm missing that needs to be changed? This was newly installed on our apple server.
View Replies !
Interperted Language To Interface
my question is, what is the best interperted language to interface with MySQL? i was told Perl by some and Python by others. the reason i am looking is because i wanted to create a custom gui and atmysqlt to make it easy to add entries or pull up certain records from the database.
View Replies !
Microsoft Word Interface
I am developing an online app that helps many editors review articles, check for errors, add new articles, etc. The editors are used to using Word to help them go through several articles at once. Because of this, I'm hoping to figure out a way to allow several persons access to their content on a MySQL database online via their local install of MS Word. I have been working some with the OBDC mysql provides at http://www.mysql.com/products/connector/odbc/ (ver 3.51) and have been able to connect and retrieve some data. My problem is how do I update the users' articles online after they have finished reviewing them in MS Word?
View Replies !
Database And Client Interface
I am planning to use MySql for my building my database. I already installed MySQL on my system. I would like to know have two databases. 1. for developement 2. for storing the correct data from the development database. Can i have two databases on the same server, so that I can copy data from one database to another. Also, I am planning to interface matlab with MySQl. i.e., Matlab would be my client program. What drivers or connections do I need to download in order to talk to the database from Matlab.
View Replies !
GUI Interface Rennie Garcia
I have experience using other databases and wanted to find out if there is a high level GUI interface for MYSQL which enables me to create a database. I am using as a backend to a large PHP site and need any easier way of creating tables etc rather than using the command line editor.
View Replies !
GUI Interface Book By DuBois
I have only read the book by DuBois and used samples at the command line. I would like to use this for work. I am avoiding the IT push to use Microsoft Access. I have 10 people in our group who need to share data (now about 50 excell spreadsheets). What I am really looking for is a GUI that can get me most of the way there. I can have my own server behind the firewall in our corporation so I am free to do my own thing. What I have found on the net so far is: Control Center Front SQLyog NAvicat Any feedback on these? Ease of use and reporting are most important attributes.
View Replies !
Export Table To .csv Via Web/PHP Interface
I have a website running Apache 1.3.31, PHP 4.3.0 and MySQL 3.23.45 (yes, I know...). Data from different tables is presented in lists on the webpage. I've been asked to add functionality to download lists as .csv-files. I have failed to find info about how to do this smoothly through a PHP script (not via command line).
View Replies !
GUI Interface For Unix Linux And Solaris Etc.
Is there a GUI Interface for MySQL ... that runs on Unix (Solaris, Linux, etc) There was an earlier thread about it - http://forums.devshed.com/showthread.php?t=51564&page=1&pp=15&highlight=GUI but most of these seem to run on Windows only.
View Replies !
Graphical Interface Hangs When I Try To View Conents Of Table
In the older version of mysql, when I pressed browse, I could see the content of the table. If I ran a query, such as select * from table, it would scroll out the result. Now, with the newer version, all it does is hang. Is there some setting I'm missing that needs to be changed? This was newly installed on our apple server.
View Replies !
ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (13)
I have a problem connecting to sql and can't find anything on the net to solve the problem. I have some sql databases running on a server. when I'm root on the server and I want to login to sql I do "mysql -ustudent -p -Dwordnet30 and it works fine. when I'm logged in with the user account on the server, i get this error message: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) so with the same user name in mysql, i can log on when i'm root, but not when i'm the user. the grant table for the user looks like this: Code:
View Replies !
Can't Connect To Local MySQL Server Through Socket '/home/data/mysql/mysql.sock' (13)
I just installed mysql on linux. If I open a terminal, su to root, then type "mysql", I am able to connect to the server and run my queries. If I exit out of su so that I am my own id (baisley) and type "mysql", I get this error: Can't connect to local MySQL server through socket '/home/data/mysql/mysql.sock' (13) Any idea why? mysql.sock has full permissions (read/write/execute), so it should be accessable by user baisley. If I am baisley and I run "mysql -u mysql" (as mysql is the user that the RPM set up), it will connect. What I would like to be able to do is run this without having to be user mysql all the time. How do I go about setting that up, or is it better to run all my queries/make tables as 1 user?
View Replies !
ERROR [HY000][MySQL][MyODBC 5.00.11][MySQL] 2006 MySQL Server Has Gone Away
Hosting Package Environment: ASP.NET ver 2 MySQL 5.0 FP Extensions 2003 Progression: Developed Website Outline Developed Database in Access2003 Migrated AccessDB to MySQL @ Hosting Service using Migration Tool. Can connect using MySQL Admin tools and run queries fine and all data, relations etc. are there. PROBLEM: (The heart of the matter) Starting simple, created GridView Control using Microsoft Visual Web Developer 2005 Express, a few glitches here and there, used the MySQL Connector/ODBC v5.00.11 followed instructions. Can see database in Database Connections Window but when I try to connect the GridView Control to it I get: "Database schema could not be retrieved for this connection. Please make sure the connection settings are correct and that the database is online. ERROR [HY000][MySQL][MyODBC 5.00.11][MySQL] 2006 MySQL server has gone away" Had thought that "Microsoft Visual Web Developer 2005 Express" might be messing with the ODBC driver so thought to download the .NET Connector. That's when it all went bad. The documentation does not say how to install or use the connector or where to put the files. It seems to assume that these bits of information are common knowledge and I suppose that if I had kept up with the technology it might be. But alas I didn't and it Isn't and It Don't work.
View Replies !
Could Not Load MySQL Driver! Compile Php --with-mysql Or Install The Mysql.so Module.
I am trying to install Media Wiki 1.5.2 on Windows XP and I have already installed apache_2.0.55-win32-x86-no_ssl ,mysql-5.0.15-win32 and php-5.1.1-Win32 . When I am trying to install Media Wiki 1.5.2 I receive the following message : Warning: dl() [function.dl]: Not supported in multithreaded Web servers - use extension=mysql.so in your php.ini in C:Program FilesApache GroupApache2htdocsmediawikimediawiki-1.5.2install-utils.inc on line 17 Could not load MySQL driver! Please compile php --with-mysql or install the mysql.so module.
View Replies !
Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (11)
We run Bitrix CMS and upon installing the web statistics module, it will sometimes show this error: Error! mysql_connect('-', '-', '-') Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) The max connections has been raised to a 1000... and SHOW GLOBAL STATUS says for the maxed used connections: Max_used_connections 273 The server does not really max out...
View Replies !
How To Configure MySQL ODBC Driver To Connect To A Mysql Server On My Own Side Of The Router?
Using MS Access, I have attached to MySQL servers in other states and other countries on the other side of my router. But when I use the MySQL ODBC driver 3.51 to connect to a MySQL server on my own LAN, the driver tells me it cannot make the connection. Here are the ODBC driver connection parms: Data Source Name: (free field - name my "my linux box" will do nicely) Host/Server Name (or IP) - something like MSQLUserName@ServerName.net has worked fine for me in the past. Now I'm trying 192.168.1.106 Database Name - whatever, mysqldb works fine, any valid db User - root Password - myrootpass Port - 3306 has worked fine 4 me N the past. Dunno whether 2 use now SQL Command On Connect - haven't ever put anything here Perhaps there is some configuration in mysql user privilege for the mysqluser "root" that would prevent him from logging from a remote PC to the mysql server?
View Replies !
Warning: Mysql_query(): Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (2)
I'm trying to connect to my MySQL database (sitehosted by GoDaddy) using PHP. I am having these errors and don't understand what they mean Warning: mysql_query(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 Warning: mysql_query(): A link to the server could not be established in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 Notice: Query: SELECT * FROM types MySQL error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 here4 Warning: mysql_close(): no MySQL-Link resource supplied in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 13 I've checked paths and connection settings and don't see any problems. My guess is now that the problem is coming from the opening and closing of the DB. my script, c_register.php uses a require_once('../mysql_connect.php') to open the connection to the database. But I also have a function definition in c_register.php that uses require_once('../mysql_connect.php') when called because it needs a connection to the DB. Here's a visual that might help:
View Replies !
MySQL Error Number 2003 :: Can't Connnect To MySQL Server On 'hostname'(10065)
I was running an older version of the query browser a while back to connect to an older version of mySQL (3.0) running on a linux box. The server hasn't changed, but the query browser has been upgraded to 1.1.10. I can't go back to the older version of the query browser because the machine that ran it got re-formatted so I downloaded the new version and installed it. So ... I get the following error when I try to connect: MySQL Error Number 2003 Can't connnect to MySQL server on 'hostname'(10065) Interestingly, I wrote a simple PHP script to connect to the server and pull some data off of it:
View Replies !
Table Rows Inserted By Embeddded MySQL Cannot Be Retrieved By MySQL Tcp Client
I have encountered a weird behavoir of embedded MySQL. Through a simple program I made (in Delphi 6), I can insert rows to a table through embedded MySQL and I can retrieve the rows from my program. But using mysql.exe which points to the same table (through 127.0.0.1, with the same basedir and datadir), I cannot see the rows I inserted using my embedded program. Another way around, the rows inserted by mysql.exe can be seen in my embedded program. But after a row is inserted by mysql.exe, the rows inserted by the embedde program are deleted (or cannot be queried). Can anybody explain why is this? Is there a way to fix it?
View Replies !
DBD::mysql::st Execute Failed: Lost Connection To MySQL Server During Query
I am using perl to connect to a database and then pull the rows off of the table one by one to manipulate the data. If I use a smaller table (~8 MB), I wait for around 20 seconds but then the table values are read just fine. However if I use a larger table (~30 MB), I wait for a while and then I get the message: DBD::mysql::st execute failed: Lost connection to MySQL server during query I have tried searching for the solution to this problem and haven't found anything that helps yet. I have changed the values of 'max_allowed_packet' and 'wait_timeout', with no effect. Any ideas?
View Replies !
|
TRACKER
