Server Side

Hi, I was wondering if anyone would be so kind as to point me in the right direction. I would like to learn to use php and mysql in a practical project. What I would like to achieve: I would like to learn how to build a simple website for say selling cars. So I would like to learn how to design a site where a customer can sign in, upload photos and information of their cars that they want to sell, be able to receive messages from potential customers. Also how to design the website so that people can search for cars that they are looking to buy. I have been through the courses on w3school and codecademy but they do not show you a project like this f…

I had Microsoft SQL Server Express 2005 installed already. I just installed the Microsoft SQL Server Management Studio Express 2005 and tried to open my mdf file. I get an error message that says: There is no editor available for 'C:\Inetpub\wwwroot\intranet\app_data\intranet.mdf). Make sure the application for the file type (.mdf) is installed. Did I do something wrong? I just clicked through the defaults in the Management Studio Express install. How can I get this to work?

Hi there, I wish to create a piece of code that allows you to set up youtube video preferences then returns a video that most closely matches. For example user selects the following: Views: 10k+ Like/Dislike ratio: 2:1 Tag: Football And the script searches for all the relevant youtube videos and displays them in rank of relevance. Does youtube allow you to do this and if so what programming language is best suited as I'm looking to learn from scratch would python have the capability? Thanks.

I have very limited experience with ajax/jquery but was hoping someone would take pity on me. I have a database setup with a table for transactions where there is a status column that contains a boolean value for the transaction status where 0 is pending and 1 is cleared. My html page has a table listing all of the transactions. Each transaction has a text link to change the status based on variables sent with the url to my php processing file which toggles the pending/cleared value. Would anyone be able to give me suggestions on how to accomplish this with ajax so the page doesn't reload each time the status link is clicked for the database update? Also, tryi…

Hi, I need to create an application form for a recruitment site. Applicants need to upload their cv in Word or PDF format only. Can anyone please point me in the right direction for any resources that will enable to do this please. Thanks. JD

I know mysql but please tell me about postgresSQL and difference between postgresql and mysql

Hello, I'm working on a small project, where I want to compare prices of different sellers. I have about 450 sellers with different prices and websites. I need to make a script, which can go through each of the sellers websites and grab the price of their product and store it in a MySQL database on my server. How do I do this? Lets make an example. Seller one's website link is: example1.com. On this page there are 3 tables. The price I'm looking for is in the 2nd table 3rd row, 2nd cell. Seller two's website link is: example2.com. On this page there are only 1 table. The price I'm looking for is in the 1st table 2nd row 3rd cell. I would then create …

I have table with some column fields are name studentid and status(yes/no) If i want to find out those records which have same studentid but different status? What should i do?

I'm wondering how important it is to know ruby/ruby on rails, I am currently learning it as it's a featured course on codeschool, do you need it and would you learn it if you were going for your first web developer job? I am currently learning everything on their website except from mobile development as i don't see that as so important, what's your opinion on this, do you think I need to know this before going for my first job, I guess it's best to just learn as much as you can right?

Hi folks, I need some advice. It's my first post so please bear with me while i try to tell you what i need the principal of what i need is the same but the subject matter is different in case you were wondering. I want to scan a whole page image from a magazine of a garden. the picture of the garden has many different types of flowers and plants which are also all different colours. I will be scanning different pages and magazines all with different images on them but all still showing different plants flowers and colours as before. Now, I would like visitors to my site to be able to search for all the images that have, eg, hyacinths in them. another example …

hi all i have ms access procedure for importing dbf files into ms access but i face a problem with corrupted files is there any code to detrmine if DBF file is corrupted or not to make exception for it ?

SQL is a special-purpose programming language designed for managing data in a relational database, and is used by a huge number of apps and organizations. Watch this Video to learn basics of SQL. This Video covers basic topics about SQL. If any topics are missed in this video means tell your opinions https://www.youtube.com/watch?v=7Vtl2WggqOg&list=PLK2ccNIJVPpCWZdr2bavtP-8xxtKJIXw7

I am looking for just a starting point. I am looking for guidance in simply being pointed in the right direction because this is kind of intense. Me and a couple of other people have put together an e-commerce site (I will not tell you the url because I am not here to promote it). The web site is a wordpress website(yes, the plugins have gotten that advanced now). The distributor, the people who actually make and send out the products, have made is such that I can communicate with them via RESTFUL API calls. I have looked at some of the wordpress plug-ins for this and it seems that they will allow me only to do command-line web server calls to my website from outs…

Evening all, Can anyone help with this error in gulp? Users/richard/projects/website/public/../node_modules/font-awesome/fonts/* events.js:141 throw er; // Unhandled 'error' event ^ Error: spawn jekyll ENOENT at exports._errnoException (util.js:837:11) at Process.ChildProcess._handle.onexit (internal/child_process.js:178:32) at onErrorNT (internal/child_process.js:344:16) at doNTCallback2 (node.js:429:9) at process._tickCallback (node.js:343:17) Any help would be appreciated, it's got me stumped

for a e commerce tool we have coded an automatic email delivery. but for customers with a outlook.com/.de the mails from the server are blocked error code: Oct 15 07:50:05 v22014052219018655 postfix/smtp[2467]: 73F4311ED1E: to=<keytest@outlook.de>, relay=mx4.hotmail.com[65.54.188.126]:25, delay=1.4, delays=0.04/0.02/0.49/0.85, dsn=2.0.0, status=sent (250 <3d1cb10e06528242149d7c7c84d099c4@swift.generated> Queued mail for delivery) Does somebody has any idea thanks flo

Currently having a jolly time migrating a site on Windows 2003 server to Windows 2012 Can anyone tell me if directories containing ASP and PHP used on the site should be added to the site in IIS simply as virtual directories or do they have to be converted to applications? Needless to say, nothing is working and I'd like to know I've got the basics right before wading through all the other possibilities. Thanks. Paul

I'm using an API to query a third party that brings me back some information that I need, as well as the Tweet URL including the ID. I am now trying to query the Twitter API for my application to fetch the Tweets by the Tweet ID. I'm currently working locally using wamp and have setup the application on Twitter but I am getting an issue with retrieving the data I need. I'm currently using the answer from Peter Mortensen from here - but I keep having issues with the 'PHP CURL Error 60 SSL' Any help appreciated even if it is to use a different method of retrieving tweet data

I've already searched thoroughly for tutorials on how to configure .htaccess but I just can't get it work properly no matter what I try. Hopefully you will be able to help me out, let me explain the current situation. There are already several 301 and other redirections in htaccess files, so let me simplify it and if it still won't work, I'll post full .htaccess files for a more detailed description. Folder of old HTML website: public_html/old Folder of new Wordpress based website (Site Address is set to www.domain.com): public_html/new As of now, new Wordpress website works fine if one opens www.domain.com or www.domain.com/new. However, the old website is still…

Hi I've been faffing around with mod_rewrite in virtual hosts for some time and i think i've got the hang of it now. However, I now wonder if it is what i thought it was at the start and if it will do what i wanted. I started out trying to replicate how the bbc website handles urls. I got it working fine with the main pages just by passing the title of the page and using mod_rewrite to apply the page name to my index.php. That worked great but the issue then became article names. When you hover over article links on bbc news they come up as world-asia-43439 or something like that. I thought at first that this was a way to pass menu-submenu-articleid back t…

Hey, I am looking to start a website which contains some basic information about Scottish footballers. I'm not sure if this should be in the Front End forum but it is a bit in the middle. The database would be updated fairly frequently (multiple times a week) to keep on top of goals, assists etc. I am not particularly keen on using MySQL or messing about with the more complicated database software, I am more looking for something simple (nothing more complicated than Microsoft Access really) which can handle the basic database features and is easy. I am fairly comfortable with MySQL because I have done the basics at Uni but multiple people will have access to the …

Hi guys, I am really a beginner with PHP, so I need your help on this one. I get this error on one of my pages. Warning: mysql_fetch_array() [function.mysql-fetch-array]: The result type should be either MYSQL_NUM, MYSQL_ASSOC or MYSQL_BOTH. in /home/a8744633/public_html/pages/user_panel.php on line 9 Line 9 in that file is this: $account_info = mysql_fetch_array(mysql_query('SELECT create_date, function, real_name FROM account WHERE login="'.$_SESSION['username'].'"'),0); What is the problem?

Hello Friends I am just starting out with NodeJS and Gulp. I have everything working as I want, and I now want to keep track of my changes via Git. What are the files and folder that I should add to `.gitignore`? Attached is the folders I have. Inside public I have two folders. These are `src` and `dist`. Any help would be greatly appreciated. Thank you.

Hi all, I've got a page which calls users from a JSON file loaded via ajax. It uses datatables, which is something nice I've discovered and am very impressed with it. <script type="text/javascript"> $(document).ready(function() { $('#user_list_deactive').DataTable( { stateSave: true, "pageLength": 20, "ajax": { "url": "data/JSON_users_list_deactive.php", "dataSrc": "", }, "columns": [ { "data": "profile_photo_path" }, { "data": "first_name" }, { "data": "email" }, { "data": "active" }, { "data": "id"} ], "columnDefs": [ { sClass: "user-name", "targets": [ 1 ] }, { sClass: "action-links", "targets": [ 3 ]…

Here is a screencast of the issue to make it clearer.... http://screencast.com/t/KXD8U1oA0yU6 Hello again, still working on the same page! This is my first project where I'm trying to get my head round AJAX so I am running into a few stumbling blocks. I have a datatable that loads user details from a JSON output via AJAX. There is a "Deactivate" button which deactivates the user account. I have applied the popconfirm id to each row... <script type="text/javascript"> $(document).ready(function() { $('#user_list').DataTable( { stateSave: true, …

Hi again all, I have a datatable which lists users, and on that same page is an "add user" form which gets submitted via ajax and processed with PHP, it then sends back a success variable, plus more variables such as "username", "first_name", "email" etc. It passes these back as well so I can add this new entry into the datatable without having to refresh the page. This worked fine until I changed the way I populate the datatable. Originally I populated it rather messily with a PHP while loop and iterated through the table rows, so I decided to run it less messy like this.... <script type="text/javascript"> $(document).ready(function() { $('#user_list'…

I have a question that you might be able to help me with. I have a client who wants me to develop on a replica of his own live server. He has suggested setting up a dev area and a sub-domain but he's not sure what he needs to do on his actual server folder wise since it has an IP address already which loads up the live site. How does he get it so that subdomain will load up the dev site its supposed to load up? There is no control panel (e.g. go daddy, 1&1 or anything like that!) Many thanks!

I'm not sure if this is PHP or a Drupal thing, so bear with me. I'm very new to PHP and Drupal and have noticed that a lot of the functions I'm using, while creating a theme for it, that I've found around the internet tend to start like this: function NAME($variables) { or function NAME($vars) { or function NAME(&$vars) { I'd like to understand what this does. I get that what's inside the brackets is a parameter that gets passed to the function due to knowing some Javascript. But I don't understand where 'variables' comes from, exactly? And is $vars exactly the same thing as $variables, just a shortening? And in the third example, why the & before $vars? …

Morning all, I've had an account here for a while but for the life of me can't remember the login details, so I created a new account. This has been bugging me for hours and after trawling the web I thought I'd best bite the bullet and ask... This is a bit PHP and a bit Jquery/Javascript, so apologies if this is in the wrong forum. I have a user profile page and I want to be able to upload a profile image (via dropzone), get the new upload path, retrieve the path via JSON and then update the image via some javascript. At the moment, the image disappears after a new upload (great), but the src is "undefined". For some reason I am not being able to retri…

Hello... A few years ago I got to grips with Dreamweaver's built in server behaviours and built a few simple web apps. In Dreamweaver CC they were missing so after looking into it, the technology is becoming depreciated so the panels have been removed. That sucks as I'm a bit of a slow learner and it helped me build websites that actually did things. Can anyone recommend a stable and long-term alternative to this that to would be worth me learning? So I really just want to be able to update databases via forms (post/get) and log users in/out etc. What would be the best technology/language to start learning? Thanks

Hi, I currently have a website im building, but ive come to the point where i need to implement a members zone, im not great with php, I can edit/manipulate scripts and have a basic understanding of it, but a members zone is way out of my league.. I only need something simple, potentially a pre written script or someone to assist in the creation of the members zone with my guidance of direction, i am willing to pay for your time i merely just need professional help, if you feel you can help me and would like to earn some extra money hit me up as im ready for immediate start!

Hi, I need to discuss a project which i need starting immediately. If there are any PHP experts out there who would like to earn some extra money contact me on here on preferably skype, my user is willows420 Thanks

Hello, I want to build a website that will manage customers, inventory and prices. Not too complicated. I need to build 2 types of web pages: 1. Pages that display information from the DB as a table and as a customize form. 2. Pages that will allow the user to add or edit information from the DB, again as a table and a customiz form. I'm familiar with codding and DB SQL. i don't know which method to choose: php or .net. I also got a recommendation on these tools: laravel,codeigniter,symfony2, Yii, Zend Framework I want to find the best and easiest way or tool to build this website. I don't care to pay for a tool if it will ma…

Looking for someone to help me out via skype if possible with a PHP project, pay available.

Recently, I had an offer to create a website for a real estate agency. However, I've never done such a thing before and the biggest issue in functionality I see is the interactive house search options.. Examples: zillow.com, reality.sk, novostavby.sk (not english sites, but for a demo, you get the idea). How would I go about coding such a thing? Is it just php going through and filtering a database of properties based on user preferences ? This might be a lame question, but this is the first time I'm dealing with such a request and I have no idea what the development procedure would look like. Thanks

Hello everyone, I have problem with local server, I doesn't matter if I use XAMPP or WAMP my website looks different in local than on server. Problem I think is in php include part of my website. On test server in web its looks allright but on local its not so good. I use dreamweaver. In liveview in index.php I have for now only one part in php for news and here is problem I will show you screens This is how to looks in localhost And the same code looks on website server

Hi all, I'm a graphic designer with no real knowledge of writing code. I work with wysiwyg builders (Muse, Wix etc.) but they are limited and have no CMS. Now, I want to build 2 websites for myself: 1. Real Estate listings website 2. Ecommerce website Both need to allow users to search listings/products and sort results by multiple criteria, such as: color, size, place, type etc., Also, users should be able to add/edit listings/products and their profiles. I found a couple of great plugins for WordPress which do all that - for the real estate website, but not for the other one. Problem is: as I know no code, I can't design anything myself..which is really…

Hi guys, I've just tried to move a PHP website (no CMS) to a new server but keep getting the following error: Fatal error: require_once(): Failed opening required '../cgi-bin/functions.php' (include_path='.:/usr/lib/php5.6') in /homepages/18/d229507269/htdocs/xxxxxxxx/xxxxxxxx/index.php on line 4 Can anyone help? I'm crap with PHP!! (The "xxxxxx" is just me protecting the ID of the directory) Thank you.

Hi all, I am a novice when it comes to server communication, but... I would users to be able to send an suggestion by email which returns a confirmation. The cell doesn't change on the spot but their email will contain: - their edit suggestion - what the currently is - and all the other row information? See images: Click a cell, submit a data change, send email. Then get a confirmation: Any suggestions? Thanks

Hey all, I'm trying to get certain records to display on my website depending on which day of the month it is. I'm not that experienced with PHP so am trying to fudge something together with multiple recordsets... mysql_select_db($database_db, $db); $query_recordsA = "SELECT * FROM jobs WHERE band = 'A'"; $recordsA = mysql_query($query_recordsA, $db) or die(mysql_error()); $row_recordsA = mysql_fetch_assoc($recordsA); $totalRows_recordsA = mysql_num_rows($recordsA); mysql_select_db($database_db, $db); $query_recordsB = "SELECT * FROM jobs WHERE band = 'B'"; $recordsB = mysql_query($query_recordsB, $db) or die(mysql_error()); $row_recordsB = mysql_fetch_assoc(…

Hi! I would like to read an rss feed that is generated with az .ashx file. The file I need to read is : http://www.mylottoadserv.com/Services/GetDrawInfo.ashx?format=rss&feedtype=next&aff=38043&lotteryid=153,99,20,159,160,60,25,11&lang=HU I could not fine a way to do it. Any help is appreciated! Thank you!

Hiya, I'm attempting to move a couple of old sites from Dreamhost across to my new host, but I'm having some issues restoring the database in cPanel. I've managed to generate a backup of my database on Dreamhost (I think!), downloaded it, and now I'm attempting to upload it to my new account. In the cPanel 'Backups' section, I select the database file in the box marked 'Restore a MySQL Database', and then hit 'Upload'. A new tab opens, and I get about twenty seconds of a white "loading" screen, and then eventually get a message that says 'Restoring Database' with a little uploading image...and that's it. The page doesn't do anything after that, and the database ne…

So I'm working on a project and everything has been going smoothly and then today my sessions would randomly destroy themselves, and I say randomly with emphasis. In some cases I'd log in and and I'd be logged out upon refresh, other times I might navigate a page or two before being logged out and sometimes I could refresh or navigate 20+ times before being logged out and I'm running out of ideas as to why this is happening. My php.ini is using the default cookie settings so the session shouldn't be destroyed until the browser resets or until it is manually destroyed and I only have session_destroy() in my logout script which is definitely not being accessed at any ti…

I use the code below to send emails via a contact form on my websites. I didn't write it myself (but have made slight modifications) as I only know a little PHP. What I want to do is make it so it also sends a copy to the sender via the email address they provided in the contact form. <?php $errors = ''; $myemail = 'EMAIL@EMAIL.COM'; if(empty($_POST['contactname']) || empty($_POST['email']) || empty($_POST['message'])) { $errors .= "\n Error: all fields are required"; } $name = $_POST['contactname']; $email_address = $_POST['email']; $message = $_POST['message']; if (!preg_match( "/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})…

Hi all, I would really appreciate some help here: I have the following script with which I intend to: email the details of the data entered in 3 fields on the webpage (html part). The fields are: Leave Type (options) Start Date (text) End Date (text) I'm already picking up the Staff number from a XML file using pHp which works great. Now I just need to also include in this email the Leave Type, Start Date and End Date as part of the email Body <?php session_start(); if(!file_exists('users/'.$_SESSION['username'].'.xml')){ header('Location: login.php'); die; } $hre = new SimpleXMLElement('users/hremail.xml', 0, true); $epos=$hre->emai…

I am working on a side project for a local small business (pro bono). Currently they sell a line of products. The orders and shipping are managed by the popular webapp ShipStation. Since they have been growing, there have been issues managing inventory (the current system is excel and manual counting). My goal is to create a simple inventory management system that will look at shipments, and debit the appropriate skus from the inventory. What I am trying to figure out is how to effectively accomplish this. I am a SQL Server BI developer by trade so this is how I see it working (with my limited webapp knowledge): Some automated process grabs incremental shipme…

Hello Everyone, First post for a long while, haven't had much on web design and building for the last few months due to moving into my first home. Anyways, it appears i'v become rusty when it comes to PHP. I am trying to set up an simple contact form for my client, and I seem to be getting nothing but empty emails back from it. Which I assume is something wrong with my variables being called. I have matched and matched and matched, all I can, with names for my inputs but getting nowhere. Can someone please give me a fresh pair of eyes and please tell me its something so simple I just can not see. Here is the form on my contact page. <div class="form_con…

I am new to PHP (please be gentle!) and so getting my head around it. I have just created my contact form and the code looks like this <form action="/sendform.php" method="post"> <p>Your name: <input type="text" name="name"></p> <p>Your email: <input type="text" name="email"></p> <p>Your telephone: <input type="text" name="telephone"></p> <p class="nospam">Leave this empty: <input type="text" name="url"></p> <p><textarea name="message"></textarea></p> <p><input type="submit" value="Send"></p> </form> I have created a separate sendform.php file …

Hi I have been asked to fix an error on a WP website where the right sidebar appears underneath the page content. When I checked it I did think it may be a plugin issue or even CSS pushing it down but have noticed the sidebar seem to appear outside page wrapper div? Here is the php code for the blog page, I think (which is why i need help) when I checked it in Notepad++ the wrapper div is not actually closed?

Hi, Can anyone help me work out how I can get the data to save and then pull it in on the front end of my site? <?php function meta_box_add() { add_meta_box( 'page-heading', 'Page Heading', 'meta_box_cb', 'page', 'side', 'low' ); } add_action( 'add_meta_boxes', 'meta_box_add' ); function meta_box_cb( $post ) { $values = get_post_custom( $post->ID ); $text = isset( $values['my_meta_box_text'] ) ? esc_attr( $values['my_meta_box_text'][0] ) : ''; ?> <p> <label for="my_meta_box_text">Page Heading</label> <input type="text" name="my_meta_box_text" id="my_meta_box_text" value="<?php echo $text; ?>" /> …

Hello, I am having issues adding extensions to the web.config file. I made it because it was returning webm files with a 404 error despite being on there. when I upload this to the root folder of my godaddy hosted server, it gives me an error "The page cannot be displayed because an internal server error has occurred." Is it returning an error because it is poorly formatted or why else? thanks <?xml version="1.0" encoding="utf-8" ?> <configuration> <system.webServer> <staticContent> <remove fileExtension=".svg"/> <remove fileExtension=".ttf"/> <remove fileExtension=".eot"/> <remove fileExten…